PL/SQL Configure the Oracle client to log in to the remote database configuration

The Oracle database is not installed locally, but you want to use PL/SQL to connect to the server-side database.

1. Create a new network folder, under which you create a new admin folder under which to create a new Tnsnames.ora file (copy the contents of the following file as modified according to your database IP Port instance name)

Modify files under the Network\admin folder: Database IP and DB instance name in Tnsnames.ora (red part, modify port if necessary, colleagues need to be aware of DB instance name)

# Tnsnames.ora Network Configuration file:d:\develop\oracle11g\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools. LISTENER_ORCL=(ADDRESS= (PROTOCOL = TCP) (HOST =192.168.30.152) (PORT =1521)) Oraclr_connection_data=(DESCRIPTION=(Address_list=(ADDRESS= (PROTOCOL = IPC) (KEY =EXTPROC1521)) ) (Connect_data=(SID=Clrextproc) (PRESENTATION=RO)) ) ORCL=(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP) (HOST =192.168.30.152) (PORT =1521)) (Connect_data=(SERVER=dedicated) (Service_Name= ORCL)) )

2. Copy the network folder to the Instantclient_11_2 folder

3. Copy the Instantclient_11_2 folder directly to the PL/SQL installation directory

4. Open PL/SQL, set the "Tools" > "preferences" in PL/SQL at >1,2 two:

5. "OK" to restart PL/SQL login.

Attention:

1. The client version and the computer version need to correspond

2.ip, port, instance name

3. The path does not contain Chinese

Thanks: Plsql developer installation, Tnsnames.ora configuration solution

PL/SQL Configure the Oracle client to log in to the remote database configuration