Oracle Connection Manager Load Balancing Problems (Doc ID 2632799.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Clients got timeout error or cannot connect although there are other available gateways on the node where the first gateway has "state:blocked".

After few number of days of a CMAN reboot the clients timed out or could not connect to CMAN. And we have to reboot CMAN again
At server level we detected a "state: blocked" when entering "show services" by cmctl

CMCTL:CMAN_XXXXXX> show services
Services Summary...
Proxy service "cmgw" has 1 instance(s).
Instance "cman", status READY, has 4 handler(s) for this service...
Handler(s):
"cmgw001" established:13152 refused:0 current:768 max:768 state:blocked  <<<<<<<<<<<<<<< First gateway reached the max connection limit and showing state as blocked 
<machine: localhost, pid: 6580>
(ADDRESS=(PROTOCOL=ipc)(KEY=#6580.1)(KEYPATH=/var/tmp/.oracle_5432100))       
"cmgw000" established:181403 refused:0 current:653 max:768 state:ready                    
<machine: localhost, pid: 6578>
(ADDRESS=(PROTOCOL=ipc)(KEY=#6578.1)(KEYPATH=/var/tmp/.oracle_5432100))
"cmgw003" established:38 refused:0 current:38 max:768 state:ready
<machine: localhost, pid: 14175>
(ADDRESS=(PROTOCOL=ipc)(KEY=#14175.1)(KEYPATH=/var/tmp/.oracle_5432100))
"cmgw002" established:39 refused:0 current:39 max:768 state:ready
<machine: localhost, pid: 14173>
(ADDRESS=(PROTOCOL=ipc)(KEY=#14173.1)(KEYPATH=/var/tmp/.oracle_5432100))

Cause

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