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.
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.
please try to run as administrator, this solved the issue for me.
ReplyDelete