Home » RDBMS Server » Server Administration » TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor [message #573800] Thu, 03 January 2013 04:49 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous messageGo to next message
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)
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not your tnsnames.ora but the costumer's one.

It seems his CONNECT_DATA part is not correct.

Regards
Michel
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 Go to previous messageGo to next message
csm.dba
Messages: 12
Registered: July 2012
Location: India
Junior Member
It's the customer's tnsnames.ora only!!!
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 Go to previous messageGo to next message
BlackSwan
Messages: 22726
Registered: January 2009
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.
Re: TNS-12505: TNS:listener does not currently know of SID given in connect descriptor [message #573841 is a reply to message #573839] Thu, 03 January 2013 08:43 Go to previous messageGo to next message
csm.dba
Messages: 12
Registered: July 2012
Location: India
Junior Member
That's my mistake!!!
I tried replacing the original instance name to something and has replaced incorrectly.
Re: TNS-12505: TNS:listener does not currently know of SID given in connect descriptor [message #573842 is a reply to message #573841] Thu, 03 January 2013 08:49 Go to previous messageGo to next message
BlackSwan
Messages: 22726
Registered: January 2009
Senior Member
Ignore the error (since it no longer exists) or submit Service Request
Re: TNS-12505: TNS:listener does not currently know of SID given in connect descriptor [message #573845 is a reply to message #573842] Thu, 03 January 2013 08:59 Go to previous message
csm.dba
Messages: 12
Registered: July 2012
Location: India
Junior Member
Thanks for your kind reply!!!
Previous Topic: Oracle Upgrade to 11G issue
Next Topic: ORA-01115:ORA-27070:
Goto Forum:
  


Current Time: Tue Sep 02 09:11:46 CDT 2014

Total time taken to generate the page: 0.16974 seconds