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.

No comments:

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles