Oracle Fusion Middleware Datasource getting suspended frequently

Question

We are using Oracle SOA Suite 11g and the Datasource that is used by the BPEL server goes to suspended mode frequently.

As the SOA datasource goes suspended, all the managed servers that use this datasource get too busy trying to connect to the DB and cause high CPU and hence making the server unresponsive.

Anyone experienced this issue and have a solution? We have already posted this in Oracle forums and created a support ticket but any help is appreciated.

Answer 1

we've been using the modified setting for a while and we dont see the issue anymore. Looks like changing the SyncMaxTimeout from default 45 to 240 worked.

Answer 2

There are multiple scenarios that could cause this to happen. A good starting point will be to enable the JDBC debug logs to see what's causing the suspension.