Number of Connections Keeps Growing Even Past the Number Configured for Maximum Capacity in the Datasource; Leads to ORA-00020 Errors
Last updated on DECEMBER 15, 2017
Applies to:Oracle WebCenter Content - Version 18.104.22.168.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms