Oracle, Web, Script, SQLserver, Tips & Trick

August 29, 2019

How to kill Anydesk (full screen with keyboard locked) ~ Windows

Filed under: dos,windows — sikathabis @ 9:05 am
Tags: , ,

Sometimes I’m using anydesk with fullscreen mode, and keyboard locking with another application happened, I tried to kill anydesk with task manager or kill manually on the task bar is useless. Then I try to another way to kill anydesk, with CMD run as administrator, and it works.

Follow this instruction to solve the problem.

Run as administrator on CMD
On CMD
type taskkill /IM anydesk.exe
if not success then taskkill /IM anydesk.exe /F

July 22, 2019

How to unlock weblogic

Filed under: Uncategorized — sikathabis @ 9:39 am
Tags:

–Erase lok file ~ Hapus file lok

cd /home/oracle/Middleware/user_projects/domains/<domain_name>/servers/AdminServer/tmp
rm *.lok

–Erase inside ldap folder ~ hapus file didalam folder ldap

cd /home/oracle/Middleware/user_projects/domains/<domain_name>/servers/AdminServer/data
rm -rf ldap/

–find Middle id (like search in task manager on windows) ~ cari id Middle

ps -ef | grep Middle

kill -9

–start weblogic

sh /home/oracle/Middleware/user_projects/domains/<domain_name>/bin/startWebLogic.sh

June 20, 2019

Pengalaman Mengurus Roya di Kantor BPN Tangerang Selatan (September 2015)

Filed under: Uncategorized — sikathabis @ 3:40 am

Tahukah anda bahwa Kantor BPN Kota Tangerang Selatan buka di hari Sabtu dan Minggu? 🙂 🙂 🙂

Ya! Pelayanan akhir pekan ini memang khusus ditujukan bagi Masyarakat umum. Secara umum, Pelayanan terbagi menjadi 2 yaitu :
1. Pendaftaran dan Pemrosesan dokumen – dari jam 09.00 s.d. 11.00
2. Penyerahan Produk / Sertifikat yang telah di proses – dari jam 12.00 s.d. 13.00

Belum lama ini saya datang ke BPN Kota TangSel untuk mengurus Penghapusan Hak Tanggungan terhadap Sertifikat Tanah/Rumah yang saya miliki, atau lebih dikenal dengan istilah Roya. Proses administrasi ini diperlukan untuk membuktikan bahwa kita sebagai Pemilik Tanah/Rumah sudah tidak lagi memiliki hutang dengan Bank, tentunya karena kita telah menyelesaikan pelunasan kredit pinjaman tersebut.

Adapun syarat-syarat yang diperlukan sbb:
20150921_112718-1

Nah – semua informasi persyaratan dapat dengan mudah diperoleh dari Brosur resmi BPN yang tersedia di kantor tersebut.

Secara garis besar ada 3 “ruangan” yang perlu kita kunjungi. Pertama adalah…

View original post 488 more words

May 8, 2019

How to connect Form/Report dev6i to Oracle Database 12c

Filed under: dev6i,oracle,oracle:12c — sikathabis @ 2:21 am
Tags: , , ,

We have database 10.2.0.5, want to convert to 12.2.0.1, the step are:
– exp from 10.2.0.5
– imp to 12.2.0.1
import Oracle 12.2.0.1 has been completed.

And then the first problem is oracle form crash when connecting to oracle 12.2.0.1

After searching, the solution come from this website:
https://www.youtube.com/watch?v=V0Achdev4gA

CONNECT AS SYSDBA
CONNECT SYSTEM USER (SYSTEM/(OWN YOUR DATABASE PASSWORD))
SHUTDOWN IMMEDIATE;
STARTUP RESTRICT;
ALTER DATABASE CHARACTER SET INTERNAL_USE WE8MSWIN1252;
SHUTDOWN;
STARTUP MOUNT;
SHUTDOWN;
STARTUP RESTRICT;
SHUTDOWN;
STARTUP;

After solving the first problem, then the second problem is coming, ORA-28040: No matching authentication protocol

For second problem, this reference is the solution:
http://logic.edchen.org/how-to-resolve-ora-28040-no-matching-authentication-protocol/

Adding SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 to sqlnet.ora in 12.1 database server (not the old client).

Connecting successfulle but still got malformed TTC package message, will solved later ..

SQL*Plus: Release 8.0.6.0.0 – Production on Wed May 8 15:24:46 2019

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-5] [0]
[0x000000000] [0x000000000] [0] [0] [2080] []

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production

SQL>



April 19, 2019

XAMPP Solved : the procedure entry point ocistmtgetnextresult could not be located in the dynamic …

Filed under: Uncategorized — sikathabis @ 3:10 pm

Notes . Noted

I’ve just got new laptop and when I re-installed the XAMPP I got this error :

the procedure entry point ocistmtgetnextresult could not be located in the dynamic …

So this was my setup when It’s error :

  • I was using Windows 10 64 bit
  • My PC using architecture 64 bit
  • I installed XAMPP x86
  • I used Oracle Install Client 12.2 64 bit, set into PATH environment

So after I configured php.ini (uncommented the extension)

extension=php_oci8_12c.dll 

that error occurred, after trial and error it was solved by doing these actions

  1. Download 32 bit Oracle Install Client, and reset the PATH environment variable to that folder
  2. Add oci.dll, oraociei12.dll, and oraons.dll to apache/bin folder. Replace the existing one
  3. Restart the Apache

Basically, I change the oracle client according to the XAMPP/apache/php version (x86 v 64 bit)

View original post

April 13, 2019

How to access sharing folder using UTL_FILE (Oracle Database)

Filed under: Uncategorized — sikathabis @ 3:07 pm

When start service, run as user who can access the host system. See PDF file for details

July 6, 2018

PL/SQL: Sleep without using DBMS_LOCK

Filed under: Uncategorized — sikathabis @ 11:50 am

Oracle Deli

If you want to wait in your PL/SQL program (“sleep”) you may want to use the procedure “SLEEP” from the package “DBMS_LOCK“. While this function does exactly what you want, your DBA may not grant you access to this package, because it contains some other mighty and dangerous procedures.

But there is help! Here are some valid alternatives:

Option 1: APEX_UTIL.sleep

If APEX is installed you can use the procedure “PAUSE” from the publicly available package APEX_UTIL.

Example – “Wait 5 seconds”:

SET SERVEROUTPUT ON ;
BEGIN
    DBMS_OUTPUT.PUT_LINE('Start ' || to_char(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));
    APEX_UTIL.PAUSE(5);
    DBMS_OUTPUT.PUT_LINE('End   ' || to_char(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));
END;
/

Option 2: java.lang.Thread.sleep

An other option is the use of the method “sleep” from the Java class “Thread”, which you can easily use through providing a simple PL/SQL wrapper procedure:

CREATE OR REPLACE PROCEDURE SLEEP

View original post 48 more words

February 2, 2018

How to fix Cannot load OCI DLL: D:\oracle\instantclient_10_2\oci.dll

Filed under: oracle,toad — sikathabis @ 7:34 am
Tags: , ,

We have Oracle database 11.2.0.4 (red hat linux 64bit) and the client connect from Windows 10 64bit

Firstable, on the client we are using Oracle client 10.2.0.5 32 bit and setting ORACLE_HOME by environment variables using this tutorial:
https://sikathabis.wordpress.com/2013/09/12/menjalankan-toad-dengan-oracle-client-basic-lite-for-windows/

But we have a problem, the toad cannot find the setting ORACLE_HOME, after we searching how to fix it, then we set the ORACLE_HOME on the regedit:
Clipboard03
Second problem is show message “Cannot load OCI DLL: d:\oracle\instantclient_10_2\oci.dll” and then try to fix it by using Oracle Instant Client 32bit with same version Oracle Database 11.2.0.4, and …… the toad connected from windows 10

December 16, 2017

How to convert xml into text file [python]

Filed under: phyton — sikathabis @ 10:51 am
Tags: , ,

import xml.etree.ElementTree as ET
tree = ET.parse(‘test.xml’)
notags = ET.tostring(tree.getroot(), encoding=’utf-8′,method=’text’)
f = open(‘test.txt’,’w’)
f.write(notags)
f.close()

reference : link1 | link2

November 18, 2017

How to Install DosBox with QBASIC

Filed under: dos,qbasic — sikathabis @ 10:35 pm
Tags: , , ,
  1. First you must download dosbox on this link
    https://www.dosbox.com/download.php?main=1
    If your Operating System (OS) Windows choose Windows, if your OS Mac OS X
  2. Download QBASIC on this link http://www.qbasic.net/en/qbasic-downloads/compiler/qbasic-interpreter.htm
  3. Extract zip file from point 2 to new folder example c:\oldDos\qbasic
  4. Run DosBox , shortcut on the Desktop or programs Clipboard01
  5. Type mount C c:\oldDos
  6. Type c:\
  7. Type CD\qbasic
  8. Type Qbasic, now you can use Qbasic

 

Next Page »

Create a free website or blog at WordPress.com.

Pureblood

DONT WANNA BE NUMBER ONE

Teknologi Pendidikan

Just another WordPress.com weblog

BLOG KATAKAMI

Jurnalisme Yang Dapat Dipercaya

Tonk Kosonk Baonk Bunyinya

Penampungan Serapah Tanpa Sumpah

Qey050489's Blog

Ayo Bangkit sobat..!!!!!

B. S. Totoraharjo

Orang Desa Yang Mencintai Desa dan Kebudayaannya

culturekitchen foodlab

New Food and Art in Yogyakarta

Wahyu Catur Wibowo

Musafir Dunia Maya

SQL.... Still Learning

My Reference on SQL Server

arihdyacaesar

"Tuhan tidak menuntut kita untuk menang. Tuhan hanya meminta kita untuk berjuang tanpa henti.” -ean-

neinframe

Street Photography is like a box of a chocolates, you're never know what you're gonna get - Thomas Leuthard -

Be a good Moeslim

Menuju Pribadi Muslim Sejati yang Bertaqwa

TuanSUFI

Manajemen Sholat, renungan spiritual, Teknologi Informasi

Pelangi di khatulistiwa....

Mari berbagi kebaikan, pengalaman dan senyum denganku

Angkasa13

Ceritanya saya, Pikirannya saya, Hatinya saya

sikathabis

sikathabis semua informasi disini

Don Charisma

because anything is possible with Charisma