配置多个监听

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-2009)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.1)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
在原来的监听器中增加一个监听地址。

[@more@]

修改tnsnames.ora

TEST2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.1)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = test2)
)
)
增加一网络服务名

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9031/viewspace-1022587/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9031/viewspace-1022587/