ESB Connection Pool Exhaustion
Last updated on SEPTEMBER 01, 2016
Applies to:Oracle ESB - Version 10.1.3.5 and later
Information in this document applies to any platform.
There is a database connection exhaustion issue.
Observed that the OTB PIP had created over 2000 connections to it's dehydration store database, this caused the database to run out of resources, and then subsequently bounced the OTB PIP. At that time there was no max connection limit on the ESB Pool connection setting in the data-sources.xml file.
For connection pool parameters to limit the maximum number of connections for the ESB, had set it to 300 connection. Discovered that in less than 15 hours, the ESB connection pool has hit the limit on this connection number, this caused the OTB PIP to be unresponsive. A subsequent restart clear the issue.
However, this raises an important issue, we need to determine what is ramping up the connection count (and not releasing or re-using connections) to the dehydration store.
We see this type of errors in our soasuite logs.
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