That is, static registration, listener do not know the status of the instance, only when the process through its connection to the database to know, if you want to use the remote management database to use static monitoring
Dynamic registration: Listener real-time knowledge of the status of the instance, the database is closed dynamically from the listener, so the remote management database start and stop is not.
4, how to determine whether it is static registration or dynamic registration
(1) Can be determined by the configuration file
Dynamic registration
Sid_list_listener =
(Sid_list =
(Sid_desc =
(program = Extproc)
(Sid_name = Plsextproc)
(Oracle_home = D:\ORADATA\ORCL)
)
)
Static registration
Sid_list_listener =
(sid_list =
(Sid_desc =
(program = Extproc)
(sid_name = plsextproc)
(oracle_home = D:\ORADATA\ORCL)
)
(Sid_desc =
(global_dbname = ORCL)
(oracle_home = D:\ORADATA\ORCL)
(sid_name = ORCL)
)
(Sid_desc =
(global_dbname = ORCL1)
(oracle_home = D:\ORADATA\ORCL)
(sid_name = ORCL)
)
)
Although it can be seen from a glance, this approach does not work well with explicit realities of the actual database at runtime
(2) LSNRCLT status
----static Registration It's all unknow.
Services Summary ...
Service "Plsextproc" has 1 instance (s).
Instance "Plsextproc", status UNKNOWN, have 1 handler (s) for the This service ...
Service "Jeff" has 1 instance (s).
Instance "JEFF", status UNKNOWN, have 1 handler (s) for the This service ...
The command completed successfully
-----Dynamic registration is the case
Services Summary ...
Service "JEFF" has 1 instance (s).
Instance "JEFF", status ready, have 1 handler (s) for the This service ...
Service "Jeffxdb" has 1 instance (s).
Instance "JEFF", status ready, have 1 handler (s) for the This service ...
Service "JEFF_XPT" has 1 instance (s).
Instance "JEFF", status ready, have 1 handler (s) for the This service ...
Service "Plsextproc" has 1 instance (s).
Instance "Plsextproc", status UNKNOWN, have 1 handler (s) for the This service ...
The command completed successfully
3, sometimes encounter even if listener up can not connect to the database situation. Will report a ORA-12514,
Running LSNRCTLS status is like this, stating no service is not registered in
Listening Endpoints Summary ...
(Description= (address= (protocol=tcp) (HOST=R1) (port=1521)))
(Description= (address= (PROTOCOL=IPC) (KEY=EXTPROC0)))
Services Summary ...
Service "Plsextproc" has 1 instance (s).
Instance "Plsextproc", status UNKNOWN, have 1 handler (s) for the This service ...
The command completed successfully
Workaround:
alter system register; ---to manually register the service in listener
This article is from the "KINGDBA" blog, make sure to keep this source http://kingdba.blog.51cto.com/801693/1435180