ResourcePoolException

[Former Member]

Hi all,

I am getting bellow error note at the receiver JDBC Channel

<quote>

Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@-------: SQLException: ORA-00020: maximum number of processes (150) exceeded

</quote>

Please suggest. should I have to contact DBA regarding this

Thank you

Regards

Dali

[Former Member · Accepted solution]

Hi Dalia,

The data base to which you are posting is having maximum no.of connections as 150, when ever it exceeds this counts you wiii face this "ResourcePoolException". To overcome this issue contact your DB Admin

Regards

Harsha Paruchuri

[aashish_sinha]

Hi,

You tried to execute a statement that requested a resource. Since the maximum number of processes have been reached, Oracle will not process any new requests.

The options to resolve this Oracle error are:

You can wait a few minutes and try to re-execute the statement(s).

You can shut down Oracle, increase the PROCESSES parameter in the initialization parameter file, and restart Oracle.

This is a DBA activity so take help of him.

Regards

Aashish Sinha

[Former Member]

every database have maximum no. of pooled resources (connection) in your case it is exceeded,

so please free some resources at database by cancle the old connections or hanged connection ,

this is a DBA activity,