Home » Infrastructure » Unix » ORA-12505, TNS:listener does not currently know of SID given in connect descriptor (Oracle 10g)
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor [message #411297] Fri, 03 July 2009 00:30 Go to next message
vinod_tiwari
Messages: 4
Registered: April 2009
Location: New Delhi
Junior Member
Hi,

I am getting the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
lononl41-vip:1525:EUT01OP1

When I do tnsping to the server I get following message:
oracle@lononl41:~> tnsping EUT01OP1

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 03-JUL-2009 05:54:17

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

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = lononl41-vip)(PORT = 1525)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = EUT01OP) (INSTANCE_NAME = EUT01OP1)))

OK (0 msec)

oracle@lononl41:~> sqlplus dbsnmp@EUT01OP1

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jul 3 05:54:25 2009
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options

SQL>

Please advice how can we fix this issue.

Thanks
Vinod

[EDITED by LF: removed superfluous empty lines; applied [code] tags]

[Updated on: Fri, 03 July 2009 01:16] by Moderator

Report message to a moderator

Re: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor [message #411299 is a reply to message #411297] Fri, 03 July 2009 00:34 Go to previous messageGo to next message
Michel Cadot
Messages: 60018
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why are there so much empty lines in your post?
Use the "Preview Message" button to verify your post BEFORE submitting it.

Regards
Michel
Re: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor [message #411434 is a reply to message #411297] Fri, 03 July 2009 09:59 Go to previous message
BlackSwan
Messages: 23162
Registered: January 2009
Senior Member
What you posted does not show any error. So please clarify problem.

12505, 00000, "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.
Previous Topic: Crontab entry on runtine
Next Topic: Script to Automatically refresh the data
Goto Forum:
  


Current Time: Mon Dec 22 23:22:06 CST 2014

Total time taken to generate the page: 0.06406 seconds