My Oracle Support Banner

UCP Connection Pool Getting Reset During Database Shard Switchover (Doc ID 2814465.1)

Last updated on AUGUST 30, 2023

Applies to:

Universal Connection Pool - Version 19.7 and later
Information in this document applies to any platform.

Symptoms


UCP 19c connection pool to a sharded setup with 2 shards is getting reset during database switchover .
During load test, PMON of shard1 is killed. It is noticed at that time that connections to running shard 2 are also getting reset (DR for shard 1 resides on shard2) even if  shard 2 is never restarted.
That is, connections in shard 2 became 0 and got reestablished.  On shard1 the total number of connections doubled. This results in transaction failures .

 Below are the connection pool properties setting:

 

 




Changes

 

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


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