Re: ORA-12505: TNS:listener

Hi,

If your listener is up but database is down or not registered with the listener running on 1243 port and automatic instance registration is used i.e. no static SID_LIST in listener.ora file, that is exactly what you get. You are running listener on non-standard port, so you need to verify local_listener parameter is set in the CDER database. If you provide the following output it'll be much easier to pinpoint the problem

• lsnrctl status <listener_name>
• show parameter local_listener from CDER database

--romas

On 6/10/08, 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
>
>
>

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