PL/SQL initialization error Could not initialize

Little scum · Posted on 8/14/2016 10:18:45 PM

[Window Title]
PL/SQL Developer

[Content]
Initialization error
Could not initialize "C:\oracle\test\product\11.2.0\dbhome_1\bin\oci.dll"
Make sure you have the 32 bits Oracle Client installed.

OracleHomeKey:
OracleHomeDir: C:\oracle\test\product\11.2.0\dbhome_1
Found: oci.dll
Using: C:\oracle\test\product\11.2.0\dbhome_1\bin\oci.dll
LoadLibrary(C:\oracle\test\product\11.2.0\dbhome_1\bin\oci.dll) returned 0

[OK]

Cause of the problem
After installation, Oracle's oci.dll is 64-bit, while the 32-bit application PLSQL Developer fails to load.
solution
1. Download the Oracle Client Package from http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html. I downloaded Instant Client for Microsoft Windows (32-bit) [instantclient-basic-nt-11.2.0.2.0.zip]
2. Unzip the instantclient-basic-nt-11.2.0.2.0.zip as H:\Oracleinstantclient and the oci.dll directory is: H:\Oracleinstantclient\instantclient_12_1\
3. Set the environment variables
TNS_ADMIN=c:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN
NLS_LANG=AMERICAN_AMERICA. ZHS16GBK (If it already exists in the registry, it can be dispensed with, it generally already exists in the registry when installing Oracle)
4. Launch PL/SQL Developer, click "Cancel" to modify the configuration of Oracle_Home and OCI Library from the menu --> Tools --> Perferences --> Connection:
OracleHome: Install your own OracleHome, such as: E:\app\Chen\product\11g\dbhome
OCI library: H:\Oracleinstantclient\instantclient_12_1\oci.dll

5. Restart PL/SQL and log in to the corresponding database, the connection is normal, and the problem is successfully solved!

[Source] PL/SQL initialization error Could not initialize

Related Posts

Sections viewed