Re: ORA-12505: TNS:listener
- From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- To: dhandapani.shanmugam@xxxxxxx
- Date: Tue, 10 Jun 2008 15:34:26 -0400
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@xxxxxxx> 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@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
>
>
>
Other related posts:
