One
cannot load OCI DLL,126
Solution: Tools->Options-> OCI and select the oci.dll in the bin in the oracle installation directory
2. Oracle 11g R2 is installed under Win7, and the following error is displayed when connecting to Oracle with Navicat:
Cannot load OCI DLL, 126: Instant Client package is required for Baic and TNS connection
For more information: http://wiki.navicat.com/wiki/index.php/Instant_client_required
Looking at the above link, I found that Navicat only supports 32-bit instant client, so even though we installed 64-bit Oracle, since Navicat only supports 32-bit client, we also need to download a 32-bit client, Download address: http://www.oracle.com/technetwork/topics/winsoft-085727.html. Here's a complete workaround:
1: Download the file :instantclient-basic-nt-11.2.0.3.0.zip at the above address
Download at: http://download.oracle.com/otn/nt/instantclient/112030/instantclient-basic-nt-11.2.0.3.0.zip
2: Unzip this installation package and merge the extracted files into :D:appuserproductinstantclient_11_2
3: Open Navicat, select Tools → Options→ Other → OCI, and set OCI library to: D:app\user\product\instant\client_11_2\oci.dll,
Set SQL *plus to: D:app\user\product\11.2.0\dbhome_1\BIN\sqlplus.exe. Are you sure. This is a misunderstanding, in fact, there is no need to set it
4: The test is successful.
|
Posted on 9/7/2016 9:38:06 AM
|
|
|
|
