RE: Setup of Multiple Listeners on RAC ?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Tue, 25 Sep 2007 21:15:09 +0530
Message-ID: <69E1360E54B50C4A828A136C158E474202A365790D@BLRKECMBX02.ad.infosys.com>

Folks

For an upcoming Multi-Node RAC Benchmark having 10,000 Dedicated Server Database Connections Each, need to setup 20 Listener processes per Node.

Need to Simulate the listener Setup on a 2-Node TEST RAC Environment already Existing here. Qs 1 - What Additions to the following listener.ora , tnsnames.ora are needed ? Qs 2 - What Additional Commands are needed so that ALL the 20 Listener processes (per Node) also get automatically Started on issue of the Command "# ORACLE_CRS_HOME/bin/crsctl start crs" & also appear in the Output of "crs_stat -t" Command (shown below) ? Qs 3 - Will the Same Changes also work if using "Shared Server" Setup for RAC in place of Dedicated Server connections ?

NOTE - In the TEST Setup here, "netca" Tool was used to setup a Single Listener process which also automatically created the listener.ora & tnsnames.ora files

Cheers & Thanks

Vivek

$ crs_stat -t
Name Type Target State Host

---

. . .
ora....-2.lsnr application    ONLINE    ONLINE    spesuns4p-2 <listener process on Node 1>
. . .
ora....-4.lsnr application    ONLINE    ONLINE    spesuns4p-4 <listener process on Node 2>
. . .

listener.ora of Node 1:-

LISTENER_ASMDBR_SPESUNS4P-2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = spesuns4p-2-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.197.181)(PORT = 1521)(IP = FIRST))
    )
  )
SID_LIST_LISTENER_ASMDBR_SPESUNS4P-2 =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /ora/asm10gr2/product)
(PROGRAM = extproc)

    )
  )

tnsnames.ora :-

ASMDBR =
  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = spesuns4p-2-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = spesuns4p-4-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =


      (SERVER = DEDICATED)

      (SERVICE_NAME = ASMDBR.ad.infosys.com)

    )
  )

Configuration - Oracle 10gR2

• 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 Tue Sep 25 2007 - 10:45:09 CDT