My Oracle Support Banner

RAC Connection Load Balancing Skewed / Incorrect (Doc ID 557061.1)

Last updated on SEPTEMBER 17, 2020

Applies to:

Oracle Net Services - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
All connections to RAC cluster are not evenly distributed
Affects only 10.2.x



Symptoms

Connections to RAC cluster are not balanced between nodes.
Often a restart of the RDBMS or TNS Listener allows connections to be balanced for short while.

PMON trace show large time gaps between updates:


Level 16 Oracle Net Listener trace also shows lbscore increasing on some node, but not all.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.