PL/SQL Developer connecting to a remote Oracle database

Transferred from: http://zhengdu.net/archives/152

First, see if the remote end Oracle service is started

If it does not start, start the Oracle service

PS: Create or delete Oracle Listener

Second, remote-side Oracle Configuration

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.10) (PORT = 1521))
Oraclr_connection_data =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
(Connect_data =
(SID = ORCL)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.10) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)

Iii. Local PL/SQL Developer configuration

SERVER10 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.10) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)

It is now possible to connect a remote Oracle database with PL/SQL developer.

PL/SQL Developer connecting to a remote Oracle database