RE: ORA-12505: TNS:listener
Date: Wed, 11 Jun 2008 15:39:51 +0530
Thanks for the update. I will check on it
From: Mercadante, Thomas F (LABOR)
Sent: Wednesday, June 11, 2008 1:11 AM
To: Shanmugam, Dhandapani; oracle-l_at_freelists.org Subject: RE: ORA-12505: TNS:listener
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.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Shanmugam,
Sent: Tuesday, June 10, 2008 3:03 PM
Subject: ORA-12505: TNS:listener
Could some one help on the below error
TNS Ping Utility for 32-bit Windows: Version 18.104.22.168.0 - Production on
Copyright (c) 1997, 2006, Oracle Corporation. All rights reserved.
Used parameter files:
Used LDAP adapter to resolve the alias
Attempting to contact
OK (60 msec)
SQL*Plus: Release 22.214.171.124.0 - Production on Tue Jun 10 14:00:25 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ORA-12505: TNS:listener could not resolve SID given in connect descriptor