Force the Oracle Listener To See An Oracle Instance Immediately

By default the Oracle SQLNet Listener is updated once a minute with newly started instances, PMON does this.
If you don’t want to wait the one minute, do this:
Logged into the instance as sysdba “sqlplus / as sysdba” issue this alter system command:
SQL> alter system register;
system altered
Your instance will be immediately registered with the listener.
To verify:
lsnrctl status
or
lsnrctl status LISTENER_NAME — if different than default name – LISTENER
 

Leave a Comment

Scroll to Top