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

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Sat, 25 Aug 2007 12:13:03 +0530
Message-ID: <69E1360E54B50C4A828A136C158E474201D78C6652@BLRKECMBX02.ad.infosys.com>

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

Received on Sat Aug 25 2007 - 01:43:03 CDT