Leech SitesLeech link generator

[Fixed] SQL Navagator cannot find Oracle client file oci.dll


Error: "Cannot find Oracle client file(s) DLL: oci.dll" or "Can't initialize OCI. Error -1"

Solution: Your OS is running a 64bit system or SQL Navigator don't install Oracle Client.

Here's the fastest way to fix SQL Navigator cannot find Oracle client file oci.dll. This method solved Can't initialize OCI problem without install Oracle Client.

So, Database not blank to select. That mean SQL Navigator detected tnsnames.ora path, you can select which database to run after open SQL Navigator.

If you have an old Oracle Product folder, this guide don't waste your time or space to install Oracle Client.

sql navigator cannot find oracle client file dll oci fixed # www.k3lvinmitnick.com

sql navigator cannot initialize oci #www.k3lvinmitnick.com

Here's how:

Step 1: Control Panel > All Control Panel Items > System > Advanced system settings > Environment variables > System variables > Path

Add your Oracle Client Product FOLDER to the end of Path.

E.g: D:\product\11.2.0\client_1\BIN

fixed sql navigator database not blank to select system variables @k3lvinmitnick.com
Step 2: System variables > New >
TNS_ADMIN
Value=Path that contain tnsnames.ora file
system variables TNS_ADMIN

Step 3: System variables > New >
ORACLE_HOME
system variables ORACLE_HOME d_product_11.2.0_client_1
Step 4: Restart Your OS

Note: Some special cases, your OS need to setup Microsoft Office (Word and Excel only)

Final, SQL navigator can select "Database"

sql navigator database not blank to select @k3lvinmitnick.com

Related Post

widgets by blogtips


Share your views...

0 Respones to "[Fixed] SQL Navagator cannot find Oracle client file oci.dll"

Post a Comment

Vote, Comment, Email to [email protected]

 

© 2013 LEECH LINKs vs LEECH SITEs

This blog run on iThesis Theme