The Connection to CM Through CMMP Occasionally Fails when One or More of the CMs in the CMMP Pool is Down (Doc ID 1614989.1)

Last updated on AUGUST 10, 2023

Applies to:

Goal

This article explains why the connection to a Connection Manager (CM) through a Connection Manager Master Process (CMMP) can fail if one or more of the CMs from the CMMP pool is down. It answers the question if - beyond its load-sharing feature - it is possible to use CMMP to implement a fail-over mechanism.

Example :

Considering a system which CMMP has two connections CM1 and CM2 in its pool; CM1 runs normally and CM2 is in a failed state. One session could run testnap which will only be connected from time to time. The load balance scheme is random :

• sometimes it properly connects to the running CM.
• sometimes it reaches the failed CM and the connection fails.

Statistically, there is a 50% chances to hit the failed CM, 50% chances that the connection properly works.

Solution

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