This content has been marked as final. Show 6 replies
Is it realy the database deregistering itself?
Have you found anything in the alert.log or the listener.log?
how to invoke the database to register it sefl back to the listener?SYS@db102 SQL> alter system register;
Is it realy the database deregistering itself?I do not know for sure
Have you found anything in the alert.log or the listener.log?no, Am I suppose to find something in them??
Do you know what could be the cause?
Deregistering from the listener didn't sound like a 'normal' behavior. So i would expect to find something in the alert.log or the listener.log. Also PMON should be able to detect that the connection is gone and reregistering the database and this should create an entry in the alert.log too.
Anyway, you should try to figure out who disconnects. Is the action taken by the database instance or by the listener.
Example: If you rely on automatic registration and bounce the listener it will take several seconds until the database is reregistering itself back to listener and for somebody who don't know that the listener was bounced it looks like the database has deregistered itself...
SQL> ALTER SYSTEM REGISTER
the perfect solution to register the database with the configured listener.