Recently we had an issue with jdbc adapter. As per connection management settings, pool(session) size is 350.
when the issue occured all seesions(350) are used by application. we though first it was occurred because of load.
But, as per DB team all 350 sessions are went to inactive state after task has been performed and didn’t terminated from application end. So, we got following error continuously in server log.
2015-12-28 14:32:33 GMT [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.OracleDataSource”.
ORA-00604: error occurred at recursive SQL level 1
ORA-00018: maximum number of sessions exceeded
In order to resolve the issue we have restarted DB. Please check below connection parameters
Enable Connection Pooling true
Minimum Pool Size 0
Maximum Pool Size 350
Pool Increment Size 20
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10
and adpater vesrion is 6.5
JCA Spec Version 1.0
Could you please advise us why the issue occurred, As per functionality application need to arrest all inactive session when it reached expire time out but it didn’t happen. I’ve checked error logs and apart from above error(after issue started) I didn’t find any other error messages.