After Oralce is re-installed on Windows 7x7, the following error message is displayed when you connect to the database through PL/SQL.
Environment
64-bit Windows 7
Oracle win64 11gR2
PL/SQL v9.0
Detailed error message
[Plain]View
Plaincopy
- Initialization error
- Cocould not initialize "C: \ oracle \ product \ 11.2.0 \ dbhome_1 \ bin \ oci. dll"
- Make sure you have the 32 bits Oracle Client installed.
- OCIDLL forced to C: \ oracle \ product \ 11.2.0 \ dbhome_1 \ bin \ oci. dll
- Loadlibrary (C: \ oracle \ product \ 11.2.0 \ dbhome_1 \ bin \ OCI. dll) returned 0
The cause of the problem is that Oracle's oci. dll is 64-bit after installation, and the 32-bit application PLSQL Developer cannot load it. Solution 1. Download Oracle from http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
Client Package. I downloaded the Instant Client for Microsoft Windows (32-bit) unzip instantclient-basic-nt-11.2.0.zip] 2. unzip the instantclient-basic-nt-11.2.0.2.0.zip to c: \ oracle, oci. dll Directory: c: \ oracle \ instantclient_11_2 \ 3. set the environment variable TNS_ADMIN = c: \ oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN NLS_LANG = AMERICAN_AMERICA.ZHS16GBK (
Note: The first half of NLS_LANG must be AMERICAN_AMERICA, Because instant client does not support other languages. The latter half can be adjusted based on the character set of your database. If the database uses AL32UTF8, you can set AL32UTF8.4) Start PL/SQL Developer and click "cancel". Choose "Tools"> "Perferences"> "Connection" to modify the configurations of Oracle_Home and OCI Library:
OracleHome: OraDb11g_home1
OCI library: C: \ oracle \ instantclient_11_2 \ oci. dll5. restart PL/SQL and log on to the corresponding database. The connection is normal. The problem is solved successfully! From: http://blog.csdn.net/hemingwang0902/article/details/7027543
