1, Oracle 10g is established by the NETCA mode is the dynamic registration method
2, if you want to change the method of static registration, add the following content in the Listener.ora
Sid_list_listener = (Sid_list = ( Sid_desc = (sid_name = Plsextproc) (oracle_home =/u01/app/oracle/product /10.2.0/db_1) (Program = extproc) ) (Sid_desc = (sid_name = JEFF) (oracle_home =/u01/app/oracle/ product/10.2.0/db_1)--for this paragraph (global_dbname = Jeff)) LISTENER = (description_list = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = r1) (PORT = 1521)) (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0)))
3, the difference between the two
Static registration: Listener does not know the status of the instance, only when the process through its connection to the database can 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.
Http://zhidao.baidu.com/link?url=tlXp8w4el_DXOmVnjl72FzNsfYyhyGXj3XkSijcnIqr8x-xGH85LKdFrCFCXKclGxBi_ Lt-hk-qs2lziekdwuk1hanufq4ak7sk78kd0qcc
The difference between ORACLE dynamic registration and Static registration (RPM)