My Oracle Support Banner

Runtime Load Balancing (RTLB) not Working After Switching RAC databases (Doc ID 1371014.1)

Last updated on JULY 27, 2018

Applies to:

Universal Connection Pool - Version: 11.2.0.1.0 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms


After upgrading the RAC database, the Run Time Load Balancing (RTLB) provided by UCP is no longer working.

JDBC/thin clients both 10g and 11g both seem to not take into account the information provided to them by ONS. It was verified using UCP tracing that the clients are subscribed to the ONS service using the  setOnsConfiguration().
The connections appear to be selected from the UCP pool in a linear fashion even when one server is very busy and the other one is under utilized
The load balancing is not working, so some servers are overworked while others are almost idle.

Please note that the issue here is not about how new physical connections being acquired by the pool are distributed to the RAC nodes, but about re-use of pooled connections and choosing pooled connections to the optimal RAC nodes.

Changes

RTLB was working fine when connecting to previous RAC database.  The issue was triggered when changing to a new RAC installation.

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
  Changes
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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