Configuration of ORACLE Multi-instance monitoring

configuration of multi-instance monitoring

Three types of cases:

1. One listener listens on multiple instances on one IP port

2. One listener listens on multiple instances on a different IP port

3. More than one listener listens to multiple instances

Scenario 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))     )   ) 

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/AE/wKioL1Rtmg3B1mfcAAHiMffyG2Y429.jpg "style=" float: none; "title=" Figure 1.png "alt=" Wkiol1rtmg3b1mfcaahimffyg2y429.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/B0/wKiom1RtmZXQUCh5AAHQps7Bd4Q040.jpg "style=" float: none; "title=" Figure 2.png "alt=" Wkiom1rtmzxquch5aahqps7bd4q040.jpg "/>

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)     )   )

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/53/AE/wKioL1RtmjuA3gtfAAGmnOLTyJI386.jpg "style=" float: none; "title=" Figure 3.png "alt=" Wkiol1rtmjua3gtfaagmnoltyji386.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/B0/wKiom1RtmcPgLo6EAAGmvHq-ocw883.jpg "style=" float: none; "title=" Figure 4.png "alt=" Wkiom1rtmcpglo6eaagmvhq-ocw883.jpg "/>

Scenario 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.13 1) (PORT = 1521)) (Connect_data = (SERVER = dedicated) (service_name = ORCL)))

Scenario 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 =       (address =  (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&NBsp;=     (address =  (protocol = tcp) (host = 192.168.152.131) ( port = 1523)      (connect_data =       (SERVER  = dedicated)        (service_name = test)      )   )

Change the configuration and start.

This article is from "Operation and maintenance record Mei Ling" blog, please be sure to keep this source http://meiling.blog.51cto.com/6220221/1580178

Configuration of ORACLE Multi-instance monitoring