ORA-12505: TNS:listener

From: Shanmugam, Dhandapani <dhandapani.shanmugam_at_eds.com>
Date: Wed, 11 Jun 2008 00:32:41 +0530
Message-ID: <AC455BF47A745941B9FB331A43662638020E78FB@inpnm231.apac.corp.eds.com>


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_at_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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 10 2008 - 14:02:41 CDT

Original text of this message