Plsql Connecting the Oracle Database

Recently in the work of the Oracle database, need to plsql client to connect to the database, the whole process has a lot of problems, now summarize the entire configuration process.

First, installation Oracle 11g bit, will 1 and the 2 unzip separately, will 2 overwrite the contents of the 1 the.

Second, installation + bit of Oracle Client ( instantclient-basic-win32-11.2.0.1.0 )

1. Download instantclient-basic-win32-11.2.0.1.0.zip ( must be in the first place ) ), unzip it to Oracle of the installation directory Product under (This machine is named: instantclient_11_2 ): D:\app\sunyiqing\product\instantclient_11_2 .

2. Copy a directory under the root directory of the database installation D:\app\sunyiqing\product\11.2.0\dbhome_1\NETWORK to the Oracle In the client directory D:\app\sunyiqing\product\instantclient_11_2

Third, installation PL/SQL Developer

installation Pl/sqldeveloper , in tools, preferences Connect inside Set OCI Library and the Oracle_home , for example, the native setting is:

Oracle Home Directory : D:\app\sunyiqing\product\instantclient_11_2

OCI Library : D:\app\sunyiqing\product\instantclient_11_2\oci.dll

iv. Setting Environment variables ( Modify PATH and tns_admin environment Variables )

1. For Nls_lang Environment Variables , preferably set to the same as the database side , first, enter from the database-side command Window :

Select Userenv (' language ') Nls_langfrom dual;

2. Right-click " My Computer " - " Properties " - " Advanced " - " Environment Variables " - " System Environment Variables ": 

1). Select "Path"- Click " Edit ", put "D:\app\sunyiqing\product\instantclient_11_2;" Join ;

 2). click " new "Tns_admin", "D:\app\sunyiqing\product\instantclient_11_2;", click " OK

3). Click " New ", the variable name is set to "Nls_lang", variable value is set to "Simplifiedchinese_china. ZHS16GBK ", click " OK ";

finally click " OK " to exit .

This is the whole process, of course, not only using Plsql but also using Navicat. The configuration principle is similar.

Required Software: Http://pan.baidu.com/s/1kTKLSjX

Plsql Connecting the Oracle Database