RE: Setup of Multiple Listeners on RAC ?
- From: VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 25 Sep 2007 21:15:09 +0530
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:
