Listener Register
LISTENER_PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = atom04-10g)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = atom04-10g)(PORT = 1621))
)
)

PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD)
)
)

OMR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OMR)
)
)

alter system set local_listener='listener_prod' scope=both;
alter system register;
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License