Re: Setup of SQL*Net related Services - listener.ora etc for ASM-RAC Database?

Hi Vivek

Could you please show us the output of lsnrctl status, just so that we can understand
your listener environment slightly better ?

To give you a perspective, for our 10gR2 + ASM + RAC(two node) environment, the
output is pasted below :

Also, off which ORACLE_HOME is your listener running ? Plus, what do lyour listener
and tnsnames entries look like ?

-Rajeev

Service "+ASM" has 1 instance(s).

Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service... Service "+ASM_XPT" has 1 instance(s).

Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service... Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Instance "prod2", status READY, has 1 handler(s) for this service...

Instance "prod2", status READY, has 1 handler(s) for this service... Service "prod.yyyy.com" has 2 instance(s).

Instance "prod1", status READY, has 2 handler(s) for this service...

Instance "prod2", status READY, has 1 handler(s) for this service... Service "prodXDB.yyyy.com" has 2 instance(s).

Instance "prod1", status READY, has 1 handler(s) for this service...

Instance "prod2", status READY, has 1 handler(s) for this service... Service "prod_XPT.yyyy.com" has 2 instance(s).

Instance "prod1", status READY, has 2 handler(s) for this service...

Instance "prod2", status READY, has 1 handler(s) for this service... The command completed successfully
On 8/25/07, LS Cheng <exriscer_at_gmail.com> wrote:
>
> why you dont run lsnrctl services and see what services is being
> delivered?
>
> surely ASMR doesnt....
>
> Thanks
>
> --
> LSC
>
>
>
> On 8/25/07, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
> >
> > Folks
> >
> >
> >
> > $ sqlplus <user>/passwd@<Connect String> is *Failing *with Error:-
> >
> > ERROR:
> >
> > ORA-12514: TNS:listener does not currently know of service requested in
> > connect Descriptor
> >
> >
> >
> > *sqlnet.log:-*
> >
> >
> >
> > ***********************************************************************
> >
> > Fatal NI connect error 12514, connecting to:
> >
> >
> > (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=spesuns4p-4-vip)(PORT=1525))(LOAD_BALANCE=yes)(C
> >
> >
> > ONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ASMR)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)
> >
> >
> > (RETRIES=180)(DELAY=5))(CID=(PROGRAM=sqlplus)(HOST=spesuns4p-2)(USER=asm10gr2))))
> >
> > VERSION INFORMATION:
> >
> > TNS for Solaris: Version 10.2.0.3.0 - Production
> >
> > …
> >
> > Tns error struct:
> >
> > ns main err code: 12564
> >
> > TNS-12564: TNS:connection refused
> >
> >
> >
> > *Qs. What additional Setup, Commands ("srvctl" etc) need to be issued?*
> >
> > NOTE – Thru "netca" -> "Add Listener Configuration" has already been
> > invoked successfully which results in creation of listener.ora file &
> > (seemingly partial) tnsnames.ora
> >
> >
> >
> > I will Provide any info needed.
> >
> >
> >
> > $ crs_stat -t
> >
> > Name Type Target State Host
> >
> > ------------------------------------------------------------
> >
> > ora....R1.inst application ONLINE ONLINE spesuns4p-2
> >
> > ora....R2.inst application ONLINE ONLINE spesuns4p-4
> >
> > ora.ASMDBR.db application ONLINE ONLINE spesuns4p-2
> >
> > ora....SM1.asm application ONLINE ONLINE spesuns4p-2
> >
> > ora....-2.lsnr application ONLINE ONLINE spesuns4p-2
> >
> > ora....p-2.gsd application ONLINE ONLINE spesuns4p-2
> >
> > ora....p-2.ons application ONLINE ONLINE spesuns4p-2
> >
> > ora....p-2.vip application ONLINE ONLINE spesuns4p-2
> >
> > ora....SM2.asm application ONLINE ONLINE spesuns4p-4
> >
> > ora....-4.lsnr application ONLINE ONLINE spesuns4p-4
> >
> > ora....p-4.gsd application ONLINE ONLINE spesuns4p-4
> >
> > ora....p-4.ons application ONLINE ONLINE spesuns4p-4
> >
> > ora....p-4.vip application ONLINE ONLINE spesuns4p-4
> >
> >
> >
> > *CONFIG:-*
> >
> > Oracle ver *10.2.0.3*
> >
> > Solaris 10
> >
> >
> >
> > Cheers & Thanks
> >
> >
> >
> > Vivek
> >
> >
> >
> >
> > **************** 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***
> >
>
>

--
http://www.freelists.org/webpage/oracle-l