1) Install Oracle 12c 64-bit
2) Installing the 32-bit Oracle Client (INSTANTCLIENT-BASIC-NT-12.1.0.1.0.ZIP)
Download Instantclient-basic-win32-11.2.0.1.0.zip, must be the Win32 version, the Oracle official website downloads, unzip it to the Oracle installation directory under product: D:\oracle\product\ Instantclient_12_1.
Copy Network\admin\tnsnames.ora This file into the D:\oracle\product\instantclient_12_1 directory
3) Install PL/SQL Developer
Install PL/SQL Developer, set the OCI library and Oracle_home inside the perference->connection, for example, set to:
Oracle Home:d:\oracle\product\instantclient_12_1
OCI Library:d:\oracle\product\instantclient_12_1\oci.dll
4) Set Environment variables (modify path and tns_admin environment variables)
Run cmd into DOS, enter command sqlplus/as SYSDBA view Nls_lang
For Nls_lang environment variables, it is best to set to the same as the database side, first query the character set information from the database side:
Sql> Select Userenv (' language ') Nls_lang from dual;
Nls_lang
----------------------------------------------------
Simplified Chinese_china. Zhs16gbk
Right-click Computer-Properties-Advanced system settings-environment variables-system environment variables:
1> Select "Path"-click "Edit" to add "D:\oracle\product\instantclient_12_1;"
2> Click "New", the variable name is set to "Tns_admin", the variable value is set to "D:\oracle\product\instantclient_12_1;", click "OK";
3> Click "New" and the variable name is set to "Nls_lang" and the variable value is set to "simplified Chinese_china. ZHS16GBK ", click" OK ";
Finally click "OK" to exit.
Start PL/SQL Developer and run without problems.
WINDOW8 64-bit + Oracle 12c 64-bit solution with PL/SQL Developer
