Cause of the problem:
Plsql developer cannot connect to 64-bit Oracle server because Plsql is 32-bit, there is no 64-bit version, and Oracle is 64-bit incompatible.
Configuration method:
1, download 64-bit Oracle, extract two files, unzip the completion of the file merging, installation;
2, download PL/SQL, decompression or installation;
3, download Oracle32-bit client instantclient-basic-nt-11.2.0.2.0.zip, unzip and cut Instantclient_11_2 folder, paste into the Oracle installation directory of the product folder ( Path such as: D:\app\Administrator\product);
4. Copy from the Oracle installation directory. \network\admin folder (path such as D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\), and in instantclient_11_ 2 Create a network folder within the folder, paste into the new network folder (path such as D:\app\Administrator\product\instantclient_11_2\NETWORK\);
5, do not login open PL/SQL, modify the Oracle home directory name in Tools-preferences-connections (tool>preferences>connection) (such as D:\app\Administrator\product\ Instantclient_11_2, this is the path to the Instantclient_11_2 folder), modify the OCI library (such as D:\app\Administrator\product\instantclient_11_2\ Oci.dll);
6, close PL/SQL, reopen, found a few databases identified, the configuration is successful!
PL/SQL Connection 64-bit Oracle configuration method