Aijaz,

Keep it simple is my advice. The listener will by default try to load
balance by CPU load. This frequently does not work too well and loads up one
node (as you see). For most apps where the connection is made at startup
time, a simple round robin approach works the best. Set this parameter in
the listener.ora for all RAC nodes:

prefer_least_loaded_node_<listener_name>=off

Make sure that each instance has the database parameter LOCAL_LISTENER set
for the listener on the node it runs on to enable listener registration:

alter system set local_listener=
'(ADDRESS = (PROTOCOL = TCP)(HOST = <VIP_address_of_node>) (PORT = nnnn))'
scope=both sid='<SID_NAME';

Use a tnsnames entry similar to:

<ALIAS>.WORLD =
(DESCRIPTION =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = <VIP_ADD_NODE_1>)(PORT = nnnn))
(ADDRESS = (PROTOCOL = TCP)(HOST = <VIP_ADD_NODE_2>)(PORT = nnnn))
(CONNECT_DATA =
(SERVICE_NAME = <Service_name>)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 20)
(DELAY = 3)
)
)
)

And it should work pretty well.

HTH
John.

-----Original Message-----
From: Mir Aijaz A
[mailto:oracledba-ezmlmshield-x57123600.[Email address protected]
Sent: 31 July 2007 12:52
To: LazyDBA Discussion
Subject: RAC 10G load balancing

hi all,

we have RAC of 2 nodes and rac1 and rac2 are the instances and machine
name is lotus and cactus respct. the majority of connections goes to
lotus and i want to load blance this as equally ... tell me i need to do
anything with listener paramters ....some times the cactus is having
less connections but it refuses the new connections and redirects to
lotus ... the lotus is havily loaded ... Please tell the suggestions
what i need to do

regards
Aijaz



DISCLAIMER:
Notice : This e-mail and any attachments may contain information which is
confidential to the addressee and may also be privileged. If you are not the
intended recipient of this e-mail, you may not copy, forward, disclose or
otherwise use it in any way whatsoever. If you have received this e-mail by
mistake, please e-mail the sender by replying to this message, and deleting
the original and any printout thereof.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.

Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.

SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.

Oracle LazyDBA home page