Solution for Oracle 10g X64 connection error in PLSQL limit 8

The operating system is Windows 7 Enterprise X64 and the Oracle 10g X64 client is installed,PLSQL DeveloperConnectionOracle 10g X64. The following error is reported:

 
 

  
  
[Window Title]  
  
  
 
  
  
(Not logged on)  
  
  
 
  
  
[Content]  
  
  
 
  
  
Initialization error  
  
  
 
  
  
Could not initialize "C:\oracle\product\10.2.0\client_1\bin\oci.dll"  
  
  
 
  
  
Make sure you have the 32 bits Oracle Client installed.  
  
  
 
  
  
OracleHomeKey:  
  
  
 
  
  
OracleHomeDir: C:\oracle\product\10.2.0\client_1  
  
  
 
  
  
Found: oci.dll  
  
  
 
  
  
Using: C:\oracle\product\10.2.0\client_1\bin\oci.dll  
  
  
 
  
  
LoadLibrary(C:\oracle\product\10.2.0\client_1\bin\oci.dll) returned 0 
 
 

This is because PLSQL developer does not support 64-bit versions. PLSQL developer is developed in delphi, and this development tool itself does not have 64-bit versions );

PLSQL Develpoer official: http://www.allroundautomations.com/plsqldev.html.click it to download oracle's Instant Client, official: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

After the download is complete, decompress the package to a path, and enter the Oracle Home Directory and OCI library in PLSQL Developer 8-tools-preferences-to write the path information extracted by the Oracle Instant Client, as follows:

Oracle main directory: The Directory extracted by the Instant Client.../instantclient_11_2.

OCI Library: oci. dll file in the Oracle main directory.../instantclient_11_2/oci. dll.

The above configuration is actually equivalent to replacing the Oracle client. Next we need to configure the system environment variables.

The following two items are required:

Variable name: TNS_ADMIN.

Variable value:.../product/11.2.0/dbhome_1/NETWORK/ADMIN in the Oracle installation directory.

Variable name: NLS_LANG.

Variable value: AMERICAN_AMERICA database character encoding ).

In addition, the following configuration is required when Oracle is installed. Otherwise, a TNS protocol adapter error may occur)

Variable name: oracle_sid

Variable value: Oracle database instance

The database character encoding can be queried by entering SQL PLUS select userenv ('language') from dual.

In this way, restart PLSQL Developer and then access it.