Configuration of Oracle Client and plsql Developer

In the management of the Oracle database or in the development activities often using the Plsql developer tool to manage our database, of course, to let our operations on the Plsql developer in the remote database system, we first need to install Oracle client.

Get ready:

1,oracle Database Instant Client

Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

2,plsql Developer

This tool is a charge, of course, can be found on the Internet some processed.

Installation process:

1. Unzip the downloaded Oracle client into a directory, such as D:\development\oracle, for example:

650) this.width=650; "title=" Oracl1.png "alt=" wkiom1ony3bgit9faadpfrzw1ns668.jpg "src=" http://s3.51cto.com/wyfs02/ M00/30/6d/wkiom1ony3bgit9faadpfrzw1ns668.jpg "/>

2, create the "network" folder under this directory, and then create the "admin" folder in the network folder.

3, create "Tnsnames.ora" file in the Admin folder, file content format:

db1 =   (DESCRIPTION =      (address_list =       (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.1 ) (PORT = 1521 ))       )     (Connect_data =       (service_name = sidname1 )  //DB instance    )  ) DB2 =   (DESCRIPTION =     (address_list =        (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.2 ) (PORT = 1521 ))  & nbsp; )     (connect_data =       (service_name = Sidname2 )    )  )

4, open Plsql Developer, select Tools, Preferences, and then follow the configuration:

650) this.width=650; "title=" Oracl2.png "src=" http://s3.51cto.com/wyfs02/M02/30/73/wKiom1On2DfiYO_ Kaalw0ici3va019.jpg "alt=" Wkiom1on2dfiyo_kaalw0ici3va019.jpg "/>

5. Add System Environment variables

1) variable name: tns_admin

Variable value: D:\development\oracle\instantclient_12_1\network\admin. The directory where the Tnsnames.ora is located.

2) variable name: Nls_lang

Variable value: Simplified Chinese_china. Zhs16gbk

Now that the configuration is complete, the Plsql developer can be restarted to establish a connection to the remote database.

This article comes from the "Simple and Easy" blog, so be sure to keep this source http://dengshuangfu.blog.51cto.com/8794650/1429826