RE: ORA-12505: TNS:listener
- From: "Shanmugam, Dhandapani" <dhandapani.shanmugam@xxxxxxx>
- To: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 11 Jun 2008 15:39:51 +0530
Hi Tom,
Thanks for the update. I will check on it
Regards,
-----Original Message-----
From: Mercadante, Thomas F (LABOR)
[mailto:Thomas.Mercadante@xxxxxxxxxxxxxxxxx]
Sent: Wednesday, June 11, 2008 1:11 AM
To: Shanmugam, Dhandapani; oracle-l@xxxxxxxxxxxxx
Subject: RE: ORA-12505: TNS:listener
Dhandapani,
Remember, tnsping only checks to see if it can reach the listener on the
machine. So your tnsping says that a listener is running. Tnsping does
*not* look and see if there ius any such database that you CDER entry is
pointing to.
Try this - make another entry in your ldap directory for a database does
not exist on the same server and tnsping that entry. You will get the
same result.
Your sqlplus connection actually tried to make a database connection.
But the listener responded saying that there is no database with the
connect information you provided.
So the listener knows nothing about your database. That is where you
need to look to fix this problem.
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Shanmugam,
Dhandapani
Sent: Tuesday, June 10, 2008 3:03 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: ORA-12505: TNS:listener
Hi,
Could some one help on the below error
F:\>tnsping CDER
TNS Ping Utility for 32-bit Windows: Version 9.2.0.8.0 - Production on
10-JUN-20
08 14:00:10
Copyright (c) 1997, 2006, Oracle Corporation. All rights reserved.
Used parameter files:
c:\Oracle\network\admin\sqlnet.ora
Used LDAP adapter to resolve the alias
Attempting to contact
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cder.guru.sree.com)(PORT=1243)
)(CONNECT_DATA=(SID=CDER)))
OK (60 msec)
F:\>sqlplus test@CDER
SQL*Plus: Release 9.2.0.8.0 - Production on Tue Jun 10 14:00:25 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-12505: TNS:listener could not resolve SID given in connect
descriptor
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
