Number of Connections Keeps Growing Even Past the Number Configured for Maximum Capacity in the Datasource; Leads to ORA-00020 Errors
(Doc ID 1641032.1)
Last updated on SEPTEMBER 18, 2023
Applies to:Oracle WebCenter Content - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Even though WebCenter Content (WCC) shows very few active database connections, ORA-00020 errors are being received. When this happens, the database cannot be accessed by users, and also cannot be accessed through a tool like SQL Plus or SQL Developer.
Looking in the WebLogic Server (WLS) Admin Server console, the following is observed:
- Navigating to Services -> Data Sources -> CSDS datasource -> Connection Pool tab, the Maximum Capacity value is set to a certain number.
- Navigating to Environment -> Servers -> <UCM_Managed_Server> -> Monitoring, the Active Connections Current Count value is higher that the Maximum Capacity value from Step 1.
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