OraFAQ Forum: Server Administration » TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

Home » RDBMS Server » Server Administration » TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS-12505: TNS:listener does not currently know of SID given in connect descriptor [message #573800]

Thu, 03 January 2013 04:49

csm.dba
Messages: 12
Registered: July 2012
Location: India

Junior Member

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

Report message to a moderator

Re: TNS-12505: TNS:listener does not currently know of SID given in connect descriptor [message #573802 is a reply to message #573800]

Thu, 03 January 2013 04:56

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a SID for an instance (usually a database instance) that either
 has not yet dynamically registered with the listener or has not been
 statically configured for the listener. This may be a temporary condition
 such as after the listener has started, but before the database instance
 has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which instances are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SID parameter in the connect descriptor specifies
    an instance known by the listener.
  - Check for an event in the listener.log file.

Check the tnsnames.ora entry of your client.

Regards
Michel

Report message to a moderator

Re: TNS-12505: TNS:listener does not currently know of SID given in connect descriptor [message #573803 is a reply to message #573802]

Thu, 03 January 2013 04:59

csm.dba
Messages: 12
Registered: July 2012
Location: India

Junior Member

Nothing has changed recently...not even since long time...

please find the details below which could help...

C:\Documents and Settings\oracle>lsnrctl services

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 03-JAN-2013 05:43
:28

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "aaku" has 1 instance(s).
Instance "aaku", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:31 refused:0 state:ready
LOCAL SERVER
The command completed successfully

===========================================================

echo %ORACLE_SID%
aaku
===========================================================
aaku =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = host-1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = aaku)
(SERVER = DEDICATED)
)
)

===========================================================
C:\Users\xxx>tnsping aaku

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 03-JAN-2
013 16:25:12

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:
C:\app\xxxx\client_11.2.0.2\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = host-1)(PORT = 1521))) (CONNECT_DATA = (SID = aaku) (SERVER = DEDICATED
)))
OK (660 msec)

Report message to a moderator

Re: TNS-12505: TNS:listener does not currently know of SID given in connect descriptor [message #573806 is a reply to message #573803]

Thu, 03 January 2013 05:06

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Not your tnsnames.ora but the costumer's one.

It seems his CONNECT_DATA part is not correct.

Regards
Michel

Report message to a moderator

Re: TNS-12505: TNS:listener does not currently know of SID given in connect descriptor [message #573825 is a reply to message #573806]

Thu, 03 January 2013 06:55

csm.dba
Messages: 12
Registered: July 2012
Location: India

Junior Member

It's the customer's tnsnames.ora only!!!

Report message to a moderator

Re: TNS-12505: TNS:listener does not currently know of SID given in connect descriptor [message #573839 is a reply to message #573825]

Thu, 03 January 2013 08:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

we suffer from data obfuscation & don't know what is real & what is fake.
>(SID = aaku)
>(CONNECT_DATA=(SID=SID123)

Oracle is too dumb to lie.
When ORA-12505 was logged it did not know about the requested SID (whatever was actually being requested)
Consider filing a Service Request for assistance with problem resolution.

Report message to a moderator