ORA-12505: TNS: listener could not resolve SID given in connection description.
When trying to connect to Oracle the following error is generated:
ORA-12224: TNS: listener could not resolve SID given in connection description.
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.
- 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
DB_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.