Odi's astoundingly incomplete notes

New entries | Code

When Oracle does not register with the listener

If your Oracle database does not register with the listener, you get ORA-12505. Normally the DB registeres automatically after a while. But you can force it to do that.

However, if it did not register automatically, chances are that this does not help either.

Check the listener status:
lsnrctl status
Check the listener's log file (filename is in the status output).

Check which listener the DB wants to register with:
select name, value from v$parameter where name in ('local_listener', 'remote_listener');
This gives you a TNS name. Check that this TNS name is defined in $ORACLE_HOME/network/admin/tnsnames.ora Such an entry looks like:
LISTENER_SID = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle.example.com)(PORT = 1521))

posted on 2018-09-12 15:09 UTC in Code | 0 comments | permalink