Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

All connections in the Universal Connection Pool are in use

MatthiasHoysMay 30 2012 — edited May 31 2012
Hello,

We are using the last version of the APEX listener (v1.1.3), together with APEX 4.1.1, Oracle 10.2.0.5 and GlassFish 3.1.1. There are 2 apex war files deployed on GlassFish pointing to 2 different databases instances on the same server. For both of them, Initial Pool Size is set to 3, Minimum Connections to 5 and Maximum Connections to 20.

The problem is that on several occasions, users couldn't connect any more to APEX. On the database level, the connections taken by APEX_PUBLIC_USER reached the maximum of 20. When I try to increase them using the APEX listener admin page, I receive the following error:
Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use
The only way to solve the problem and to release the connections is to restart the GlassFish instance. The problem occurs randomly. The strange thing is that this is a development server, used by only 5 people at the maximum. So I believe 20 connections should be more than enough, no?

Any idea on how to debug this? The random aspect makes it hard to simulate the problem. I now increased the maximum connections to 30, let's see if this helps...

Thanks,
Matthias Hoys
http://matthiashoys.wordpress.com

Edited by: mhoys on May 30, 2012 5:06 PM

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 28 2012
Added on May 30 2012
3 comments
13,381 views