Re: Setup of SQL*Net related Services - listener.ora etc for ASM-RAC Database?
- From: "arun chakrapani rao" <arunchakrapanirao@xxxxxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx
- Date: Sat, 25 Aug 2007 19:41:58 -0400
In order to connect using sqlnet u will have to add the sid in the
listener.ora.
The asm does not work with service names when u connect from outside.
in the listener.ora hard core the sid with the oracle home
then make the connection
On 8/25/07, VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx> 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***
>
--
thanks
Arun
Other related posts:
