Linda Webb Got breaking Oracle news?     Click here for more Oracle News Headlines

Use the “alter system register” Oracle command

Malay Maru has published an interesting note on using the “alter system register” command for causing PMON to register a server:

http://www.dba-village.com/village/dvp_tips.TipDetails?TipIdA=2367

Pmon is responsible for registration of oracle server with listener. During service registration it provides listener with the following information:

- Name of the associated instance
- Current load and maximum load on instance
- Names of DB services provided by database.
- Information about dedicated servers and dispatchers (depends on database server mode i.e dedicated/shared server mode)

PMON process wakes up at every 60 seconds and provide information to the listener. If any problem arises and your PMON process fails then it's not possible to register information to listener periodically. In this case you can do 'Manual service registration' using command:

ALTER SYSTEM REGISTER;

This command forces the registration of database information to the listener.