My Oracle Support Banner

In Weblogic Server Console ODI_server1 JDBC Data Source Connection Pool Status Changes to "Overloaded" Causing ODI Console to Hang in ODI 12.2.1 (Doc ID 2125454.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 to 12.2.1.1.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

When logging in with ANY user that does not have the supervisor privilege the weblogic JDBC Connection pool produces a lot of sessions which in turn produce a JDBC Overload error and then the Oracle Data Integrator (ODI) Console freezes.
There are too many sessions generated for non supervisor user as compared to supervisor user.  The number of sessions increase by 4-5 with each user login, while with a supervisor user, number of sessions increase by 1.

This can be seen from WebLogic Server console:

Weblogic Server console -> odi_domain -> Servers -> ODI_Server1 -> Monitoring -> Health

In Weblogic Server console -> odi_domain -> Servers -> ODI_Server1 -> Monitoring -> JDBC

 

By default in Weblogic Server console -> odi_domain -> Services -> Data Sources -> odiMasterRepository -> Connection Pool -> Maximum Capacity = 15

By increasing this number this issue may pass unnoticed. And by restarting the managed server odi_server1 the sessions are cleared.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.