Shulou(Shulou.com)05/31 Report--

This article mainly introduces "Oracle static and dynamic monitoring methods". In daily operation, I believe that many people have doubts about the methods of Oracle static and dynamic monitoring. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "Oracle static and dynamic monitoring methods". Next, please follow the editor to study!

I. static registration

Static registration refers to reading the listener.ora configuration file when the instance is started and registering the instance and service with the listener. Whenever a database is started, two pieces of information are registered with the listener by default: the instance and the service.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = rman)

(ORACLE_HOME = / u01/oracle)

(SID_NAME = rman)

)

(SID_DESC =

(GLOBAL_DBNAME = gel)

(ORACLE_HOME = / u01/oracle)

(SID_NAME = gl)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost.localdomain) (PORT = 1521))

)

)

Description:

1) (ORACLE_HOME = / u01/oracle) oracle_home directory, which is fine without adding the test.

2) this static monitor is used to monitor two database instances, and the static monitoring of each instance is written to SID_DESC.

3) in the non-open state of the database, you can remotely connect to the database and operate on the database.

4) when using static monitoring, the tns of the client should be configured as SERVICE_NAME. Of course, you can also configure SID and SERVICE_NAME at the same time. After the database is started, both sid and SERVICE_NAME in tns can access the database.

Second, dynamic registration

Dynamic registration does not need to display the configuration listener.ora file, when the instance is started, the PMON process dynamically registers the instance and service into listerer according to the instance_name,service_name parameter. If instance_name is not set, the parameter value is initialized using db_name. If service_names is not set, the db_name and db_domain parameter values are concatenated to register snooping.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = rman)

(ORACLE_HOME = / u01/oracle)

(SID_NAME = rman)

)

(SID_DESC =

(GLOBAL_DBNAME = gel)

(ORACLE_HOME = / u01/oracle)

(SID_NAME = gl)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost.localdomain) (PORT = 1521))

)

)

Description:

1) No manual intervention is required. After lsnrctl start, the instance_name,service_name of the database is automatically registered, and then tns can connect to the database regardless of whether SID or SERVICE_NAME is used.

2) modified SERVICE_NAME or SID without modifying listener.ora file

At this point, the study of "Oracle static monitoring and dynamic monitoring methods" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.