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