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

This article mainly introduces "static registration and dynamic registration of how Oracle DBA monitors". In daily operation, I believe that many people have doubts about static registration and dynamic registration of how Oracle DBA monitors. 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 questions of "static registration and dynamic registration of Oracle DBA monitoring". Next, please follow the editor to study!

Static registration can be configured through a graphical net manager. The corresponding relationship between the configuration options in net manager and the relevant files.

Static registration and dynamic registration of how to monitor Oracle DBA

You need to configure [listener (listener.ora)] for static registration on the server side, including:

Listening location (protocol, host, port)

Database service (global database name: the global database name here corresponds to the service name of the client [Service naming (tnsnames.ora)], Oracle home directory, SID)

Other services (when I tested, I found that I could not leave blank, but just fill in some characters in the program name and SID here)

Adding a listener needs to be configured through netca, and netca under win will create a service.

Listener.ora (server side)

SID_LIST_SL01 =

(SID_LIST =

(SID_DESC =

(PROGRAM = xx)

(SID_NAME = xx)

)

(SID_DESC =

(GLOBAL_DBNAME = gdbn01)

(ORACLE_HOME = d:\ oracle\ product\ 10.2.0\ db_1)

(SID_NAME = ORCL)

)

)

SL01 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = duzz) (PORT = 8899))

)

Tnsnames.ora (client side)

S01 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = duzz) (PORT = 8899))

)

(CONNECT_DATA =

(SERVICE_NAME = D01)

)

)

Static registration and dynamic registration of how to monitor Oracle DBA

= [dynamic registration] =

In order for PMON to dynamically register ports other than 1521, you need to configure the connection information (protocal,host,port-the connection information must exist in the listening location of [listener (listener.ora)]) www.linuxidc.com to the tnsnames.ora on the server side, and then modify the local_listener parameter to point to the configuration option in tnsnames.ora.

Listener.ora (server side, SL01 is a new listener created through netca)

SL01 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = duzz) (PORT = 8899))

)

Tnsnames.ora (server side)

DL01 = (ADDRESS = (PROTOCOL = TCP) (HOST = duzz) (PORT = 8899)

Alter system set local_listener='DL01'

Alter system set service_names='d01,d02,d03'

The client only needs to enter the appropriate SERVICE_NAME in the tnsnames.ora:

Tnsnames.ora (client side)

S01 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = duzz) (PORT = 8899))

)

(CONNECT_DATA =

(SERVICE_NAME = D01)

)

)

For PMON to dynamically register the default port of 1521 is relatively simple, there is no need to set local_listener parameters, www.linuxidc.com naturally does not need to modify the server-side tnsnames.ora file, the other steps are the same as dynamically registering non-1521 ports.

= [verify registration] =

Sqlplus / @ S01 as sysdba

Select distinct sid from v$mystat

Select service_name from v$session where sid=:sid

View the service name of the current session

If SYS$USERS is returned, the current session is connected through a statically registered service name

Otherwise, the dynamically registered service name is returned.

At this point, the study of "static registration and dynamic registration of Oracle DBA monitoring" 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.