First turn on the computer, to the specified directory of PL/SQL installation
"D:\app\DZL\product\10.2.0\dbhome_1\NETWORK\ADMIN" or
"D:\oracle\product\10.2.0\db_1\network\ADMIN" or is not logged into PL/SQL
Locate your installation path via the
Find it again. "Tnsnames.ora" under the \network\admin
Open the "Tnsnames.ora" file to increase the string you need to connect remotely .
For example:
XXXX =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = XX.) Xx. Xx. XX) (PORT = 1521))
)
(Connect_data =
(SERVER = dedicated)
(service_name = XXXX)
)
)
Especially for some important field descriptions:
MyDB for connection database alias, HOST = 192.168.7.23 for the database you are connected to Ip,port = 1521 for your data port, service_name = TestDB for your DB instance name
After setting up, open "PL/SQL Developer" Enter the user name password, select the database you just added, click OK to successfully connect to the remote database.
The remote database was successfully connected.
PL/SQL Developer how to connect to a remote database