Home » RDBMS Server » Server Administration » PMON register (oracle9i)
PMON register [message #343681] Wed, 27 August 2008 16:41 Go to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
I read the below info from oracle help. I have one question here. Why PMON has to register the DB info every 60 seconds to Listener? Is it not enough if it is registered only first time?


Specify REGISTER to instruct the PMON background process to register the instance with the listeners immediately. If you do not specify this clause, then registration of the instance does not occur until the next time PMON executes the discovery routine. As a result, clients may not be able to access the services for as long as 60 seconds after the listener is started


Re: PMON register [message #343686 is a reply to message #343681] Wed, 27 August 2008 16:46 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

What happens when the listener restarts after the DB has already registered itself with the listener?

Using your suggested 1st time only when DB starts,
manual intervention would be required after a listener restart.
Re: PMON register [message #343756 is a reply to message #343681] Thu, 28 August 2008 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Why PMON has to register the DB info every 60 seconds to Listener? Is it not enough if it is registered only first time?

Because a listener can shutdown and restart.

Regards
Michel
Re: PMON register [message #343972 is a reply to message #343756] Thu, 28 August 2008 09:16 Go to previous messageGo to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
Thanks Michel.

Thanks anacedent. I am sorry for exceeding more then 80 characters in the line. I will take care this next time. thanks again.
Re: PMON register [message #344016 is a reply to message #343972] Thu, 28 August 2008 10:41 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The 80 characters limit is just when you use code tags as these lines are not automatically fold. You can use the length you want otherwise.

Regards
Michel
Previous Topic: Transporting Database template
Next Topic: Upgrade oracle8i to oracle 9i
Goto Forum:
  


Current Time: Wed Dec 04 19:20:38 CST 2024