Remote connection to Oracle is troublesome. It usually takes the oracle client to be installed. You can use instantclient to easily connect to a remote Oracle database.
1. Create a Directory D: \ Oracle_Cleint to store related files. Create a Directory D: \ Oracle_Cleint \ NETWORK \ ADMIN to store tnsnames files.
2. Download the corresponding version and the system's instantclient compressed package, decompress the package to obtain the instantclient folder, and place the content in the folder under D: \ Oracle_Cleint.
Oracle11GR2 instantclient file: http://pan.baidu.com/s/13YKtK
3. Obtain the tnsnames. ora file in/home/app/oracle/product/11.2.0/dbhome_1/network/admin.
4. Modify the tnsnames. ora file as follows:
# 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)))
Modify the preceding Oracle IP address.
5. Place the modified tnsnames. ora file in the D: \ Oracle_Cleint \ NETWORK \ ADMIN directory.
6. set environment variables (my computer-> right-click "properties"-> advanced-> environment variables-> User variables) to create a new user variable named NLS_LANG. The variable value is SIMPLIFIED CHINESE_CHINA.ZHS16GBK.
7. Configure PLSQL Developer, tools → preferences → Oracle → connection. Enter "D: \ Oracle_Cleint \" in the Oracle main directory \
Enter the OCI Library: D: \ Oracle_Cleint \ oci. dll