Configure PLSQL developer to connect to a remote ORACLE database

After PLSQL developer is installed, there are always some problems during connection configuration. The following describes the direct channel:

 

1. The client needs to install the compressed client package downloaded from the Oracle official website, for example, decompress it to D:/sqlplus.

 

2. The host information and SERVICE_NAME information in the tnsnames. ora file in the D:/sqlplus directory of the client must be consistent with the file of the same name in the Oracle database.

 

3. Configure the host file (C:/Windows/system32/Drivers/etc/) to indicate the name of the IP address of the Oracle database to be connected. It must be the same as that in tnsnames. ora.

 

4. Add Path = D:/sqlplus; tns_admin = D:/sqlplus; nls_lang = simplified chinese_china.zhs16gbk to the environment variable.

5. On the login interface of PLSQL developer, enter the user name and password. Enter SERVICE_NAME in tnsnames. ora at the database.

 

 

For details about how to download the compressed package, see

Http://blog.csdn.net/cityeremite/archive/2009/11/16/4818403.aspx