Registering with the listener
database
ID: 20150620
ACCESSING DATA...
SYSTEM: ARCHIVE
FILE: REGISTERING WITH THE LISTENER
STATUS: ACTIVE
When restarting a database, if you can’t acess it from outside, you may have to associate the newly restarted database with the listener. The Pmon process that is started with the instance is responsible for registration of oracle server with listener.
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 running on the server.
Written on June 20th, 2015 by Samy Gejzenblozen