Anyone know how to monitor/debug/log the diagnostic data related to the settings in defaults.xml for ORDS 3.0.6 deployed within WebLogic - in particular the JDBC connections ?
Please change your user handle from "User12629916-Oracle" to something meaningful. Refer : Video tutorial how to change nickname available
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 :
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
For enabling logging you have specify log location for ORDS or you can print the debug to screen:
The second entry enables printing debug to screen.
For monitoring JDBC Connections in Oracle WebLogic you can refer following:
Regarding the Connection Pooling error for ORDS you can refer:
- oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use
- Connection Pool issue in ORDS
Hope this helps!
Thanks for the reply.
I had seen most of those docs and have already acted upon them but with no luck - things like the debug.debugger and printDebugToScreen set to true but I don't see anything in the weblogic managed server logs.
The WebLogic JDBC connection pools don't seem to apply to this case as there are no data sources created - the only source of config is the defaults.xml file with the jdbc parameters but that doesn't map to a datasource that I can monitor through WLST or the WebLogic Admin Console. The puzzling thing is that the error message implies that there is a UCP connection pool in use somewhere (and perhaps by inference a datasource) but its not visible and doesn't want to come out and play:)
I'm sure other people would have come across this request. I'd like to see/monitor the jdbc connections growing and/or shrinking as requests to ORDS come in through WebLogic but so far have hit a brick wall. The ORDS app feels like a black box that I can't inspect. I'm beginning to wonder whether I'm approaching this the wrong way - should I be looking at it from the DB side rather than WebLogic
I'd like to ask - have you managed to do this yourself or know of anyone who has? If so, I'd be very interested.