Hello,
First post
I have ORDS 3.0.6 deployed on WebLogic Server 12.2.1 and am getting the dreaded "Exception while getting connection: oracle.ucp.UniversalConnectionPoolException: All connections in the universal Connection Pool are in use "
My current JDBC settings (that deviate from the default) in the defaults.xml are :
jdbc.InitialLimit=50
jdbc.MaxLimit=150
jdbc.MinLimit=50
I can increase it again but the DBA says there no more than 30 active sessions on the DB side.
I am having trouble finding how to capture diagnostic info for ORDS related to the JDBC settings mentioned above. If the settings were 'standard' JDBC data sources, I could monitor them from the WebLogic Console or WLST and could see how the number of connections grow (and possibly not being released and give me a pointer to the cause).
However since the JDBC connection info is stored in a flat file on the filesystem and accessed by ORDS, I am a bit stuck on how to monitor/debug this. I've also set the <entry key="debug.debugger">true</entry> but that doesn't appear to show anything that is useful.
So I would like some help in how to monitor the JDBC connections from ORDS within WebLogic to the Oracle DB ? Has anyone done this before - is there a JMX/WLST way perhaps interrogating an MBean ?
Thanks in advance