L/sql Developer and instantclient Client installation configuration

One: PL/SQL Developer installation

Download installation file installation, my version number is PLSQL7.1.4.1391, the installation directory is: D:\soft\PLSQLDeveloper

II: Instantclient_10_2 Client Configuration

Instantclient_10_2 has the following two configuration methods, choose one.

Method One:

1. Download Client http://www.oracle.com/technetwork/topics/winsoft-085727.html

Extract to Directory: D:\soft\instantclient_10_2

2. Add the network and admin folders and Tnsnames.ora files under the installation directory.

D:\soft\instantclient_10_2\network\admin\ Tnsnames.ora,tnsnames.ora File Contents:

HOST: IP of the database server

SERVICE_NAME: The name of the DB instance, consistent with the SID

Method Two:

1. Same method download the client to extract to directory: D:\soft\instantclient_10_2

2. Add Sqlnet.ora file D:\soft\instantclient_10_2\sqlnet.ora, Sqlnet.ora file contents:

3. Edit Tnsnames.ora file D:\soft\instantclient_10_2\ tnsnames.ora, file contents same as method one.

4. Add Environment variables

Variable name: Tns_admin variable Value: D:\oracle_client\instantclient_10_2

If you do not add this environment variable, you will be prompted with an error when landing PL/sql:

5. If you have previously installed ORACLE and uninstalled, you will be left with the Nls_lang=na key. Enter regedit to open the registry hkey_local_machine/software/oracle.

Find Nls_lang=na on the right and delete it, otherwise it will be reported ora-12705:cannot access NLS data files or invalid error

Three: Configure PL/SQL Developer

Open the PL/SQL Developer, open Preferences under the Tools menu

Oracle Home directory Name: D:\soft\instantclient_10_2

OCI Library: D:\soft\instantclient_10_2\oci.dll

 

Four: Log in to PL/SQL Developer with username and password

L/sql Developer and instantclient Client installation configuration