I have connection pooling turned off and I am getting ORA-00020 maximum number of processes (400) exceeded.
Is there issue with DB connection not released after calling BSFNs?
We are having an issue with the E1 adapter, when ever a business
function call fails, it keeps that connection open and after 500 trails
(which is our maximum), nobody can get to the Oracle and we have to
restart the server (which will clear the connections) and after that we
will be fine. Is there any fix for this issue? See log below.
2006-02-28 16:20:02 CST [ART.0114.1007E] Adapter Runtime: Error Logged.
See Error log for details. Error: [ADA.1.204] Cannotconnect to the
database with DataSource class
“oracle.jdbc.pool.OracleConnectionPoolDataSource”.
ORA-00020: maximum number of processes (500) exceeded
2006-02-28 16:20:02 CST [ART.0118.5053E] Adapter Runtime (Connection):
Unable to get a connection to resource
Ipps3.DbConnections:Ipps3SourceDBConnection.
2006-02-28 16:20:02 CST [ART.0114.1007E] Adapter Runtime: Error Logged.
See Error log for details. Error: [ADA.1.204] Cannot connect to the
database with DataSource class
“oracle.jdbc.pool.OracleConnectionPoolDataSource”.
ORA-00020: maximum number of processes (500) exceeded
2006-02-28 16:20:02 CST [ART.0118.5053E] Adapter Runtime (Connection):
Unable to get a connection to resource
JDBCConnection.NotificationConnection:JDENotificationConn.
please suggest me on this regarding. I want this reply very soon…
I’m not sure about your connection pooling turned off… that may present it’s own problems. It does seem you’re using the pool class, I think there is a different class for a oracle non-pool connection.
To debug this you need to run the netstat -a | grep
during your runtime to see what the connection profile is. Is it connecting a lot, is it reusing connections (assume no since you’re not pooling), etc.
I’d bet that if you’re not pooling, you’re establishing a brand new connection for each request… very inefficient.
Talk to your DBA. There are two values that they set. Max # of connections and Max # of processes. 1 connection = 1 process, but there are other processes required other than connections, so you’ll for 500 max connections, you may need 600 processes.