My Oracle Support Banner

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 DECEMBER 15, 2017

Applies to:

Oracle WebCenter Content - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

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:

  1. Navigating to Services -> Data Sources -> CSDS datasource -> Connection Pool tab, the Maximum Capacity value is set to a certain number.
  2. Navigating to Environment -> Servers -> <UCM_Managed_Server> -> Monitoring, the Active Connections Current Count value is higher that the Maximum Capacity value from Step 1.

 

Cause

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
Symptoms
Cause
Solution
References


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