13 Replies Latest reply: Jan 3, 2013 8:01 AM by Fran RSS

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

    CSM.DBA
      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