Friday, 28 December 2018

Toad Error - Cannot load OCI DLL: C:\Oracle\instantclient_11_1\oci.dll

Toad Error - Cannot load OCI DLL: C:\Oracle\instantclient_11_1\oci.dll

Or

Oracle Home is not Valid on TOAD
 Instant Client - 11.2.0.1.0
ORACLE_HOME_NAME: C:\Oracle\app\product\11.2.0\client_1\bin
ORACLE_HOME: C:\Oracle\app\product\11.2.0\client_1\bin
ORACLE_SID:
NLS_LANG:
SQLPATH:
LOCAL:
C:\Oracle\app\product\11.2.0\client_1\bin exists.
C:\Oracle\app\product\11.2.0\client_1\bin is in PATH.
Client DLL: C:\Oracle\app\product\11.2.0\client_1\bin\oci.dll
Client Version: 11.2.0.1.0
Home is NOT valid!


Solution:

Toad only works with Oracle11g client-32 bit on Windows 10- 64 bit or any version of windows,in my case it was windows 10-64bit.

firstly i was installed Oracle11g client 64bit on Windows 64 bit and was getting error as above mentioned then
de installed and installed 11gclient-32bit on Windows-64 bit,after that toad is working fine.

1 comment:

  1. please try to run as administrator, this solved the issue for me.

    ReplyDelete