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 Reply

Your email address will not be published. Required fields are marked *