Connecting a remote Oracle instance using Plsql Developer

Client: WIN10

Server: Oracle server installed on Linux

1, download Plsqldeveloper11.zip, Instantclient_11_2.rar and unzip to the corresponding directory

D:\instantclient_11_2, D:\PLSQL Developer

2. Add environment variables on WIN10

Variable name: Tns_admin variable Value: D:\instantclient_11_2\NETWORK\ADMIN

Variable name: Nls_lang variable value: Simplified Chinese_china. Zhs16gbk

Variable tns_admin is the directory where the Tnsnames.ora file resides

3./u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora the files on the Oracle server

Uploaded to the D:\instantclient_11_2\NETWORK\ADMIN directory. WIN10 can ping the Oracle server ORACLE11G01.

The contents of the Tnsnames.ora file are:

# Tnsnames.ora Network Configuration File:/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = oracle11g01) (PORT = 1521))

(Connect_data =

(SERVER = dedicated)

(service_name = ORCL)

)

)

4, set Plsql developer:tools->preferences->connection

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M00/88/64/wKiom1f0rSXw8xFCAADapqUS1RM117.png-wh_500x0-wm_3 -wmp_4-s_693479425.png "title=" Qq20161005153427.png "alt=" Wkiom1f0rsxw8xfcaadapqus1rm117.png-wh_50 "/>

5. Re-Login

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/88/60/wKioL1f0ryXRyyZtAACkx_AwgN4365.png-wh_500x0-wm_3 -wmp_4-s_3542383134.png "title=" Qq20161005154315.png "alt=" Wkiol1f0ryxryyztaackx_awgn4365.png-wh_50 "/>

Connecting a remote Oracle instance using Plsql Developer