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

Looks like you don't have a service defined for ASMR on your crs_stat output. You need to run dbca and define a service for ASMR before the listener will begin handling requests for it.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA
Sent: Saturday, August 25, 2007 1:43 AM
To: oracle-l_at_freelists.org
Subject: Setup of SQL*Net related Services - listener.ora etc for ASM-RAC Database?

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=asm10gr
2))))

  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***

No virus found in this incoming message. Checked by AVG Free Edition.
Version: 7.5.484 / Virus Database: 269.12.4/969 - Release Date: 8/23/2007 4:04 PM

No virus found in this outgoing message. Checked by AVG Free Edition.
Version: 7.5.484 / Virus Database: 269.12.4/969 - Release Date: 8/23/2007 4:04 PM  

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