Monday, May 12, 2008

ORA-12505:TNS:listener does not currently know of SID given in connect descriptor

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

ORA-12505:TNS:listener does not currently know of SID given in connect descriptor

For an explanation of this error message, refer to the article on ORA-12514.
The main difference lies in the fact that the client is using a SID instead of a service name, hence the returned error message is slightly different.
I've seen this error frequently when trying to connect to a freshly started db using SQL Developer, prior that the instance registered itself with the listener.
Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was: 192.168.1.30:1521:orcl11

Vendor code 0
See message translations for ORA-12505 and search additional resources.
at

No comments:

Post a Comment

I appreciate your comment however bear in mind that I might not have the time to reply soon.
Normally I do not reply to all comments but I am glad if you found something useful or if you learned something new, in that case I strongly encourage you to promote the article with the +1 google button.
Flavio