Re: Help regarding Listener process

From: <dushyantmp_at_my-dejanews.com>
Date: Mon, 05 Apr 1999 04:23:34 GMT
Message-ID: <7e9dru$ruh$1@nnrp1.dejanews.com>

In article <7e4vb1$d1u$1_at_nnrp1.dejanews.com>, rajasekharr_at_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 Received on Sun Apr 04 1999 - 23:23:34 CDT