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

Document created by Terese_Baker Employee on Jul 11, 2014
Version 1Show Document
  • View in full screen mode
Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor.
This error is passed along from the Oracle database. Please make sure that the SID is correct.

The SIDs that are currently registered with the listener can be obtained by typing the following on the server:
LSNRCTL SERVICES

These SIDs correspond to SID_NAMEs in TNSNAMES.ORA or DB_NAME in the initialization file.

Since AtomSphere uses JDBC connectivity as a means to access database applications, you can use a SQL client such as SquirrelSQL to simulate the same way an Atom connects before you try to connect to the DB using your process. You should use the same setting in SquirrelSQL as currently being used in your Dell Boomi process.

http://squirrel-sql.sourceforge.net/

Attachments

    Outcomes