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

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