Odi's astoundingly incomplete notes

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.

As SYS:

ALTER SYSTEM REGISTER;

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