Cry about...
Oracle Troubleshooting
ORA-12505: TNS: listener could not resolve SID given in connection description.
Symptom:
When trying to connect to Oracle the following error is generated:
ORA-12224: TNS: listener could not resolve SID given in connection description.
Cause:
The SID specified in the connection was not found in the listener’s tables. This error will be returned if the database instance has not registered with the listener.
Possible Remedy:
- Check to make sure that the SID is correct. The SIDs that are currently
registered with the listener can be obtained by typing:
LSNRCTL SERVICES <listener-name>These SIDs correspond to
SID_NAMEs inTNSNAMES.ORAorDB_NAMEin the initialisation file.
This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.
About the author: Brian Cryer is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.