RE: Setup of Multiple Listeners on RAC ?

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

Other related posts: