DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
         :content-type:references;
        b=Yp/5dknI1VyY0pBpFFNkfmAyveW8LCUwZG5tvKxK0tdROxJgMvKYA0sNR8qIIkNzhq
         7fM2PNTgfjti5HSGLdEDm98qxk6zxLaN0GkwlYlxhj8feKGHG8ov/FCVnr2lMkYe28ZF
         qtxg+2kzihxsDbJxtYIGLgWLMUnF6SS1bRLxo=
Message-ID: <55f303590806101234p412c1cd0x4c6b4500cadd4c62@mail.gmail.com>
Date: Tue, 10 Jun 2008 15:34:26 -0400
From: "Roman Podshivalov" <roman.podshivalov@gmail.com>
To: dhandapani.shanmugam@eds.com
Subject: Re: ORA-12505: TNS:listener
Cc: oracle-l@freelists.org
In-Reply-To: <AC455BF47A745941B9FB331A43662638020E78FB@inpnm231.apac.corp.eds.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_7430_26793930.1213126466185"
References: <AC455BF47A745941B9FB331A43662638020E78FB@inpnm231.apac.corp.eds.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: roman.podshivalov@gmail.com
------=_Part_7430_26793930.1213126466185
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_7430_26793930.1213126466185
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hi,</div>
<div>&nbsp;</div>
<div>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,&nbsp;that is exactly what you get.&nbsp;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&#39;ll be much easier to pinpoint the problem</div>

<div>&nbsp;</div>
<div>- lsnrctl status &lt;listener_name&gt;</div>
<div>-&nbsp;show parameter local_listener from CDER database<br><br>--romas</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div><span class="gmail_quote">On 6/10/08, <b class="gmail_sendername">Shanmugam, Dhandapani</b> &lt;<a href="mailto:dhandapani.shanmugam@eds.com">dhandapani.shanmugam@eds.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi,<br><br>Could some one help on the below error<br><br>F:\&gt;tnsping CDER<br><br>TNS Ping Utility for 32-bit Windows: Version 9.2.0.8.0 - Production on<br>
10-JUN-20<br>08 14:00:10<br><br>Copyright (c) 1997, 2006, Oracle Corporation.&nbsp;&nbsp;All rights reserved.<br><br>Used parameter files:<br>c:\Oracle\network\admin\sqlnet.ora<br><br>Used LDAP adapter to resolve the alias<br>Attempting to contact<br>
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<a href="http://cder.guru.sree.com">cder.guru.sree.com</a>)(PORT=1243)<br>)(CONNECT_DATA=(SID=CDER)))<br>OK (60 msec)<br><br>F:\&gt;sqlplus test@CDER<br><br>SQL*Plus: Release 9.2.0.8.0 - Production on Tue Jun 10 14:00:25 2008<br>
<br>Copyright (c) 1982, 2002, Oracle Corporation.&nbsp;&nbsp;All rights reserved.<br><br>Enter password:<br>ERROR:<br>ORA-12505: TNS:listener could not resolve SID given in connect<br>descriptor<br><br>--<br><a href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org/webpage/oracle-l</a><br>
<br><br></blockquote></div><br>

------=_Part_7430_26793930.1213126466185--
--
http://www.freelists.org/webpage/oracle-l