PL/SQL Developer and instantclient client installation configuration

PL/SQL Developer and instantclient client installation configuration

Oracle installation I will not write, will not be installed on the Internet casually find a tutorial can be installed, installation is relatively simple. However, PL/SQL developer and instantclient clients are not well configured, easy error, configuration is not good PL/SQL Developer unable to connect to Oracle database.

1) Install Oracle 11g 64-bit

　　2) Installing the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0)

Download Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not make the wrong version number.) The Oracle website is downloaded), unzip it to the Oracle installation folder under product (native named: instantclient_11_2): D:\Oracle\app\e\product\instantclient_11_2.

Copy a folder under the root folder of the database installation D:\Oracle\app\e\product\11.2.0\dbhome_1\NETWORK to the Oracle Client folder D:\Oracle\app\e\product\ Instantclient_11_2 (in fact only needs Network\admin\tnsnames.ora)

　　3) Install PL/SQL Developer

Install PL/SQL Developer, set up OCI library and Oracle_home in Perference->connection, for example, this machine is set to:

Oracle home:d:\oracle\app\e\product\instantclient_11_2

OCI Library:d:\oracle\app\e\product\instantclient_11_2\oci.dll

　　 4) environment variable settings (change path and tns_admin environment variable)

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 My Computer-Properties-advanced-environment variables-system environment variables:
1> Select "Path"-click "Edit" to add "D:\Oracle\app\e\product\instantclient_11_2;"
2> Click "New", the variable name is set to "Tns_admin", the variable value is set to "D:\Oracle\app\e\product\instantclient_11_2;", 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 perform no problem.

PL/SQL Developer and instantclient client installation configuration