在Oracle/network/admin中的tnsnames.ora中添加对应的如下代码:
LISTENER_ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.25.51.209)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
其中LISTENTER_ORCL为随意名称。SERVICE_NAME是对应的sid