Configuration of ORACLE multiple instance snooping
Configuration of multi-instance snooping
There are three situations:
1. One listener listens to multiple instances on one IP port
2. One listener listens to multiple instances on different ports of an IP
3. Multiple monitoring and monitoring multiple instances
Case 1:
Listener.ora file:
# listener.ora Network Configuration File: e:\ app\ product\ 11.2.0\ dbhome_1\ NETWORK\ ADMIN\ listener.ora# Generated by Oracle configuration tools.SID_LIST_ORCL = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL) (SID_NAME = ORCL)) (SID_DESC = (GLOBAL_DBNAME = NHL) (SID_NAME = NHL)) ORCL = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.152.131) (PORT = 1521)) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC)
Tnsnames.ora file:
# tnsnames.ora Network Configuration File: e:\ app\ product\ 11.2.0\ dbhome_1\ network\ admin\ tnsnames.ora# Generated by Oracle configuration tools.NHL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.152.131) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = NHL)) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST) = 192.168.152.131) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)
Case 2:
Listener.ora file:
# listener.ora Network Configuration File: e:\ app\ product\ 11.2.0\ dbhome_1\ NETWORK\ ADMIN\ listener.ora# Generated by Oracle configuration tools.SID_LIST_ORCL = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL) (SID_NAME = ORCL)) (SID_DESC = (GLOBAL_DBNAME = NHL) (SID_NAME = NHL)) ORCL = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.152.131) (PORT = 1521)) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.152.131) (PORT = 1522) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC)
Tnsnames.ora file:
# tnsnames.ora Network Configuration File: e:\ app\ product\ 11.2.0\ dbhome_1\ network\ admin\ tnsnames.ora# Generated by Oracle configuration tools.NHL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.152.131) (PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = NHL)) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST) = 192.168.152.131) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)
Situation 3:
Listener.ora file:
# listener.ora Network Configuration File: e:\ app\ product\ 11.2.0\ dbhome_1\ NETWORK\ ADMIN\ listener.ora# Generated by Oracle configuration tools.SID_LIST_ORCL = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL) (SID_NAME = ORCL)) (SID_DESC = (GLOBAL_DBNAME = NHL) (SID_NAME = NHL)) SID_LIST_TEST = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = TEST) (SID_NAME = TEST)) ORCL = (DESCRIPTION_LIST = (DESCRIPTION = (PROTOCOL = TCP) (HOST = 192.168.152.131) (PORT = 1521) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC)) TEST = (DESCRIPTION = (ADDRESS = () PROTOCOL = TCP) (HOST = 192.168.152.131) (PORT = 1523)
Tnsnames.ora file:
# tnsnames.ora Network Configuration File: e:\ app\ product\ 11.2.0\ dbhome_1\ network\ admin\ tnsnames.ora# Generated by Oracle configuration tools.NHL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.152.131) (PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = NHL)) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST) = 192.168.152.131) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)) TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.152.131) (PORT = 1523)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = test)
Change the configuration and start it.
