Monday, April 21, 2008

ORA-12505 TNS:listener could not resolve SID given in connect description

Recently we changed the port of the DB from default 1521 to 1532. After this change it was noticed that clients could not connect although tnsping was working.

Metalink note 111911.1 points to registration of the instance name with the listener. Did the steps in the note and clients could connect to the instance.
Reason is prior to Oracle 8i, a listener was statically configured (listener.ora) to service a given set of SIDs. From 8i, PMON dynamically registers a database service with the listener.