My Oracle Support Banner

Inactive and Sniped Sessions In Exadata Database When Using JDBC Connection Pool (Doc ID 2711212.1)

Last updated on JUNE 05, 2023

Applies to:

JDBC - Version 11.2.0.4.0 and later
Information in this document applies to any platform.

Symptoms


After migrating an 11.2.0.4 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..

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.