Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help regarding Listener process
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