PLSQL developer cannot connect to 64-bit Oracle solution 1 Date: Source: smallsilver shared:
Oracle10.2.0.4 but pLsQl cannot be connected.
Cause:
Oci. the dll is 64-bit, and the 32-bit application PLSQL Developer cannot load it, And PLSQL Developer only supports 32-bit. Therefore, if we need 64-bit Oracle, we have to find another solution;
Reference: http: // zhIdAo. baiDu. Com/question/409525812.html
? 1. Download the 32-bit Oracle InstantClient and expand it to a directory, for example, D: \ PLSQL Developer \ instantclient_10_2;
? 2. Copy the system tnsnames. ora to this directory;
? 3. Set Oracle_Home and OCI Library in PLSQL Developer:
Tools? PrefereNcEs? Oracle? Connection:
Oracle_Home: D: \ PLSQL Developer \ instantclient_10_2
OCI Library: D: \ PLSQL Developer \ instantclient_10_2 \ oci. dll
Figure 1
? 4. Edit the following bat file in the PLSQL Developer directory, replace the shortcut, and start PLSQL Developer:
@ Echo off
SetPath = D: \ PLSQL Developer \ instantclient_10_2
Set ORACLE_HOME = D: \ PLSQL Developer \ instantclient_10_2
Set TNS_ADMIN = D: \ PLSQL Developer \ instantclient_10_2
Set NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
Start plsqldev.ExE
OK !~
Http://www.linuxso.com/windows/29456.html