Last updated on JANUARY 11, 2017
Applies to:Oracle Data Integrator - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
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 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
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 hundreds of Community platforms