Oracle, Web, Script, SQLserver, Tips & Trick

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

Advertisements

September 14, 2017

How to connect oracle 12c from toad 9.7

Filed under: oracle,oracle:12c,toad — sikathabis @ 3:34 am
Tags: , ,

You must have Oracle Client 10g and then replace 12c
https://sikathabis.wordpress.com/2013/09/12/menjalankan-toad-dengan-oracle-client-basic-lite-for-windows/

Example
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.111)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orclpdb)))

September 12, 2013

Menjalankan TOAD dengan oracle client basic lite (for windows)

Filed under: oracle,toad — sikathabis @ 12:18 pm
Tags: ,

PRAKATA

Bagi anda yang tidak mempunyai Oracle Database atau Oracle Developer untuk menghubungkan ke database Oracle di server/di tempat lain melalui TOAD maka

SOLUSI

Memakai Oracle client basic lite, karena ukurannya kecil dan mudah dalam Installasi

LINK

Download Oracle client basic lite 32 bit ( gdrive | ziddu )

Download Oracle client basic lite 64 bit ( gdrive | ziddu )

Download Tutorial Installasi Pdf ( gdrive | ziddu )

February 2, 2013

Fungsi sort output pada session browser di tab Long Ops (TOAD)

Filed under: oracle,toad — sikathabis @ 4:50 pm
Tags: ,

sort output

Pada gambar diatas merupakan contoh proses Sort output pada session browser di tab long ops software TOAD. Proses tersebut sedang berlangsung REBUILD INDEX terhadap suatu index. Sebagai contoh ada perintah:

ALTER INDEX ln_master_audit_idx REBUILD TABLESPACE vbs_master_idx

Blog at WordPress.com.

Pureblood

DONT WANNA BE NUMBER ONE

Learning is not a spectator sport

Connor McDonald on SQL and the Oracle Database

Teknologi Pendidikan

Just another WordPress.com weblog

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