2 listeners are serving for 1 instance .
1, netca .
2, vi /home/oracle/OraBase/OraHome1/network/admin/tnsnames.ora
LISTENERS_MAMBO =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hzdevdb1.mambo.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = hzdevdb1.mambo.com)(PORT = 1522))
)
3, SQL> alter system set local_listener="LISTENERS_MAMBO";
4, vi /home/oracle/OraBase/OraHome1/network/admin/tnsnames.ora
TEODB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hzdevdb1.mambo.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = hzdevdb1.mambo.com)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = teodb.mambo.com)
)
)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16348200/viewspace-608733/ ，如需转载，请注明出处，否则将追究法律责任。
