User with Deployer Role Unable to Shrink the Connection Pool from Console (Doc ID 2158915.1)

Last updated on JUNE 07, 2023

Applies to:

Symptoms

User with 'deployer' role was able to run the cmo.shrink() from WLST, i.e., was able to shrink the connection pool.

Below are the replication steps:

1. Install WebLogic Server 10.3.6 and create a domain. No Managed Server required.
2. Configure a data source.
3. In the connection pool setting, set initial capacity and max capacity to 10.
4. Set the minimum capacity to some lower value, like 2 or 3.
5. Create a new user with deployer role or assign the user to deployer group. 
6. Log in to console with the new user and go to data source page -> control.
7. Select the data source and click on 'shrink'. 
8. You will observe error on the console, with below message.

An unexpected exception has occurred processing your request

1. Run cmo.shrink()
2. No output on the WLST shell, but when you observe from console, you can see that the shrink was performed.
3. For monitoring, you have to customize the table view and add the options 'Current Capacity' and 'Number Available'.
4. Once the above mentioned shrink() command is run, value for both goes to 2 from the initial capacity 10.

Cause

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