My Oracle Support Banner

All Connections In The Universal Connection Pool Are In Use (Doc ID 1592840.1)

Last updated on MARCH 30, 2020

Applies to:

Oracle REST Data Services - Version 3.0 and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Using Oracle REST Data Services - ORDS (aka Apex Listener) when attempting to connect to APEX applications the following error occurs:

ERROR
-----------------------
HTTP-500 error

In ords.log the following message appears:

Feb 06, 2019 9:43:46 AM
SEVERE: *** Error: Could not obtain a database connection because all connections in the pool: |apex|| were in use. Borrowed Connections: nn Available Connections: 0 Maximum Connections: nn***
Feb 06, 2019 9:43:46 AM
SEVERE: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use
ServiceUnavailableException [statusCode=503, reasons=[]]

The ORDS configuration shows:

<entry key="jdbc.MaxConnectionReuseCount">1000</entry>
<entry key="jdbc.MaxLimit">10</entry>
<entry key="jdbc.MaxStatementsLimit">10</entry>


The issue can be reproduced at will with the following steps:
1. Configure ORDS  to access APEX
2. Call the the APEX URL in a browser


Changes

 

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
Changes
Cause
Solution


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