This discussion is archived
13 Replies Latest reply: Jan 3, 2013 6:01 AM by Fran RSS

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

CSM.DBA Journeyer
Currently Being Moderated
Hi Friends,

I have a question regarding this infamous error.

One of my customer has called us saying he's unable to connect to the Database and the error he was encountering with is TNS-12505.

When I tried connecting, It got connected immediately. I thought this is a problem with the dynamic registration etc... but the DB and the listener were running from long time and the registration technique we used is static here.

below is the log of continuous failure and success actions.

Please suggest
CSM


03-JAN-2013 02:35:46 * (CONNECT_DATA=(SID=SID123)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=4369)) * establish * SID123 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
Thu Jan 03 02:36:04 2013
Dynamic address is already listened on (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=1521)))
03-JAN-2013 02:36:04 * service_register * SID123 * 0
03-JAN-2013 02:36:12 * service_update * SID123 * 0
Thu Jan 03 02:36:15 2013
03-JAN-2013 02:36:15 * service_update * SID123 * 0
03-JAN-2013 02:36:18 * service_update * SID123 * 0
03-JAN-2013 02:36:19 * service_update * SID123 * 0
03-JAN-2013 02:36:22 * service_update * SID123 * 0
Thu Jan 03 02:36:47 2013
03-JAN-2013 02:36:47 * (CONNECT_DATA=(SID=SID123)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=4376)) * establish * SID123 * 0

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points