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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Connect Thru Listener for NEWLY Converted RAC DB Failing ......Basic Qs

Re: Connect Thru Listener for NEWLY Converted RAC DB Failing ......Basic Qs

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Thu, 21 Dec 2006 09:07:03 -0800
Message-ID: <3b0f44a10612210907y7008b150s548fb1bf89b86df@mail.gmail.com>


Vivek,

It is a simple tnsnames.issue. Show us your tnsnames.ora file.

On 12/21/06, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
>
> Folks
>
>
>
> Manually converted a Database from NON-RAC to RAC (2 instances) & Changed
> the "tnsnames.ora" file suitably.
>
> Yet connect VIA the Listener to this Database is failing.
>
> ERROR:
>
> ORA-12521: TNS:listener does not currently know of instance requested in
>
> connect descriptor
>
>
>
> NOTE – Connect to another Sample Database (TSTRAC) Created thru the "*DBCA
> *" Tool on the Same RAC Nodes is successful.
>
>
>
> *Qs Is registering of this RAC database and its instance-to-node mapping
> using SRVCTL needed? If so, How?*
>
> *Qs Is Manually Change to some Other files also needed (Other than
> tnsnames.ora)?*
>
>
>
> Thanks indeed
>
>
>
>
>
> FAILING Database PNBRAC related services *versus* TSTRAC (Working
> Database) related services are shown below:-
>
>
>
> $ lsnrctl stat
>
> Service "PNBRAC.ad.infosys.com <http://pnbrac.ad.infosys.com/>" has *1
> instance(s)*.
>
> Instance "PNBRAC", status READY, has 1 handler(s) for this service...
>
> Service "PNBRACXDB.ad.infosys.com <http://pnbracxdb.ad.infosys.com/>" has
> *1 instance(s).*
>
> Instance "PNBRAC", status READY, has 1 handler(s) for this service...
>
> Service "PNBRAC_XPT.ad.infosys.com" has *1 instance(s).*
>
> Instance "PNBRAC", status READY, has 1 handler(s) for this service...
>
>
>
> Service "TSTRAC.ad.infosys.com <http://tstrac.ad.infosys.com/>" has *2
> instance(s)*.
>
> Instance "TSTRAC1", status READY, has 2 handler(s) for this service...
>
> Instance "TSTRAC2", status READY, has 1 handler(s) for this service...
>
> Service "TSTRACXDB.ad.infosys.com <http://tstracxdb.ad.infosys.com/>" has
> *2 instance(s)*.
>
> Instance "TSTRAC1", status READY, has 1 handler(s) for this service...
>
> Instance "TSTRAC2", status READY, has 1 handler(s) for this service...
>
> Service "TSTRAC_XPT.ad.infosys.com" has *2 instance(s).*
>
> Instance "TSTRAC1", status READY, has 2 handler(s) for this service...
>
> Instance "TSTRAC2", status READY, has 1 handler(s) for this service...
>
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this e-mail
> or its contents to any other person and any such actions are unlawful. This
> e-mail may contain viruses. Infosys has taken every reasonable precaution to
> minimize this risk, but is not liable for any damage you may sustain as a
> result of any virus in this e-mail. You should carry out your own virus
> checks before opening the e-mail or attachment. Infosys reserves the right
> to monitor and review the content of all messages sent to or from this
> e-mail address. Messages sent to or from this e-mail address may be stored
> on the Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>

-- 
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 21 2006 - 11:07:03 CST

Original text of this message

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