Inactive and Sniped Sessions In Exadata Database When Using JDBC Connection Pool
(Doc ID 2711212.1)
Last updated on SEPTEMBER 17, 2020
Applies to:JDBC - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
After migrating an 184.108.40.206 database on Solaris to Exadata (same database version), iWay Service Manager using JDBC Connection Pool connects successfully to the database, but sometimes reports "SQLAgent cannot get a connection from the datasource jdbc/<NAME>" (iWay error).
A large number of sniped sessions are noticed in the database, and sys.AUD$ returncode is 2391 is reported..
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document