Re: ORA-12505: TNS:listener

The listner is unaware of a database with the SID of CDER.

lsnrctl status will tell you what services the listener *is *aware of. Most likely it will know about services these days.

Niall

On Tue, Jun 10, 2008 at 8:02 PM, Shanmugam, Dhandapani < dhandapani.shanmugam_at_eds.com> wrote:

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

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l