Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why set LOAD_BALANCE=NO in 10gR2 RAC running E-Business Suite 11i

turnerpeFeb 5 2010 — edited May 26 2010

While reviewing Oracle Note: +452056.1 - Business Continuity for Oracle Applications Release 12 on Database Release 10gR2 - Single Instance and RAC+

The note says "[RAC ONLY] *The service definition for a RAC database should include all the instances and specify the "load_balance=no"* and "failover=yes” options."

In our current production configuration load balancing is enabled (=yes in tnsnames.ora) and our sessions are well balances between each RAC database instance.

So I don't know why this note suggests we should set the LOAD_BALANCE=NO ? If we disable load balancing, then wouldn't that cause an imbalance among sessions? I just can't see any justification for this.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 23 2010

Added on Feb 5 2010

#ebs, #performance-availability, #rac, #real-application-clusters

3 comments

2,970 views