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!

Connection Pool Problem

915154May 16 2012 — edited Oct 1 2012
I'm running APEX Listenerversion 1.1.3.243.11.40 on WebLogic 11g. The database is Oracle 11.2.0.3

I've got two managed instances in a cluster and the listener is deployed to the cluster. I've individually configured both APEX listeners (by going directly to each managed instance) to point to the same database.

I've configured the connection Pool to as follows on both managed instances:

<entry key="apex.jdbc.DriverType">thin</entry>
<entry key="apex.jdbc.InitialLimit">10</entry>
<entry key="apex.jdbc.MinLimit">10</entry>
<entry key="apex.jdbc.MaxLimit">20</entry>

When the server starts up I see the initial 10 connection no problems. After a while I see the following error message multiple times.

--- 5/15/12 11:44 PM ( 8 Hours 26 Minutes 44 Seconds Ago ) --- Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource

netstat shows connections dropped below the min limit, sometimes to zero connections.

Has anybody seen this before? Also, is there a way to turn on detailed debugging or trace for the listener.I've turned on Show debug messages on console from listenerAdmin but that is really not detailed enough to see what is ultimately causing the Connection Pool problem.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2012
Added on May 16 2012
11 comments
6,243 views