Pl_sql develope How to connect a remote database

Need to modify the path of the data you are installing under the Tnsnames.ora file (my installation path is F:\app\Aside\product\11.2.0\dbhome_1\NETWORK\ADMIN)

The content in Tnsnames.ora is as follows:

# Tnsnames.ora Network Configuration File:f:\app\aside\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (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 = localhost) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)

You need to copy an ORCL content ORCL is your instance name you can take it, localhost instead of the IP address you want to connect to, 1521 instead of the port number of the database you want to connect to, SEVRVICE_NAME=ORCL Change the name of the ORCL to the instance of the remote data you want to connect to. For example

aside =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.120.110.119) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = hollooracle)
)
)

Then, in Pl_sql develope, select the instance name of the database you want to connect to enter the user name and password.

Pl_sql develope How to connect a remote database