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 Win32 version, Oracle official website has downloaded,: http://www.oracle.com/technetwork/topics/ Hpsoft-090268.html, unzip it to product under the Oracle installation directory: 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 in 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 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 +ORACLE12C 64-bit use Pl/sqldeveloper solution