Xref: alice comp.databases.oracle.server:45031
Path: alice!news-feed.fnsi.net!news.idt.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail
From: dushyantmp@my-dejanews.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Help regarding Listener process
Date: Mon, 05 Apr 1999 04:23:34 GMT
Organization: Deja News - The Leader in Internet Discussion
Lines: 21
Message-ID: <7e9dru$ruh$1@nnrp1.dejanews.com>
References: <7e4vb1$d1u$1@nnrp1.dejanews.com>
X-Article-Creation-Date: Mon Apr 05 04:23:34 1999 GMT
X-Http-User-Agent: Mozilla/4.5 [en] (Win95; I)
X-Http-Proxy: 1.0 Diamond@wipinfo.soft.net:8080 (Squid/2.2.PRE2), 1.0 x3.dejanews.com:80 (Squid/1.1.22) for client 192.168.20.42, 164.164.6.31

In article <7e4vb1$d1u$1@nnrp1.dejanews.com>,
  rajasekharr@triconinfotech.com wrote:
> I have two databases in Oracle 7.3 on WindowsNT.
> Two listener process were created for the two databases.
> Now when i connect to the second database it is showing the
> following error message:
>
> ERROR: ORA-12505: TNS:listener could not resolve SID given in connect
> descriptor
>

Make sure that tnsnames.ora($ORACLE_HOME/network/admin) has entries
corresponding to the SIDs you created.
The command "lsnrctl services <listener name>" will give
the SIDs which the listener can resolve.

regards
dushyant

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own