Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help regarding Listener process

Re: Help regarding Listener process

From: Alexander Romanov <sashar_at_comita.spb.ru>
Date: Mon, 5 Apr 1999 14:48:20 +0400
Message-ID: <7ea4ev$coi$1@dragon.infopro.spb.su>

dushyantmp_at_my-dejanews.com пишет в сообщении <7e9dru$ruh$1_at_nnrp1.dejanews.com> ...
>In article <7e4vb1$d1u$1_at_nnrp1.dejanews.com>,
> rajasekharr_at_triconinfotech.com wrote:

[skip]
>> 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.

Step-To-Step
Server side

1. Add to Listerner.ora reverences to new SID
2. restart lsnrctl (stop and start)
3. Start new servis NT
4. Start instans

Client side
Add to TNSNames.ora references to new Instans

TNSNames.ora uses ONLY Client's Software

Best regards
Всех Благ
---
Origin ... Просто надо очень верить этим синим маякам... Romanov Alexander
Alex_Romanov_at_mail.ru
ICQ 6220754 Received on Mon Apr 05 1999 - 05:48:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US