Plsql developer Connecting a remote Oracle Method (non-installation client)

Remote connection to Oracle is cumbersome and usually requires the installation of Oracle's client talent.

The instantclient can be easily connected to remote Oracle.

1. New Folder D:\Oracle_Cleint is used to store related files, new folder D:\Oracle_Cleint\NETWORK\ADMIN for tnsnames files
2. Download the corresponding version number and the system's instantclient compression package. Unzip to get the Instantclient directory. Place the contents of this directory under D:\Oracle_Cleint.

ORACLE11GR2 instantclient File: Http://pan.baidu.com/s/13YKtK
3. Get the Tnsnames.ora file with the file location under/home/app/oracle/product/11.2.0/dbhome_1/network/admin.
4. Change the Tnsnames.ora file, such as the following

# Tnsnames.ora Network Configuration File:/home/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools. ORCL=(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP) (HOST =Oracle) (PORT =1521)) (Connect_data=(SERVER=dedicated) (Service_Name=ORCL )))

Change the above Oracle to the appropriate IP address to
5. Place the modified Tnsnames.ora file under the D:\Oracle_Cleint\NETWORK\ADMIN folder.
6. Environment variable settings (user variable, environment variable, "Properties", "My Computer," right), create a new user variable, variable name nls_lang, variable value simplified Chinese_china. Zhs16gbk
7. Configure Plsql Developer, tools → preferences →oracle→ connection, complete Oracle home folder name: D:\Oracle_Cleint\
OCI Library Completed: D:\Oracle_Cleint\oci.dll

Plsql developer Connecting a remote Oracle Method (non-installation client)