Long running queries are forced to rollback or release a connection when Inactive Connection Timeout is reached. (Doc ID 2087333.1)

Last updated on AUGUST 04, 2023

Applies to:

Symptoms

InactiveConnectionTimeoutSeconds (Inactive Connection Timeout) is defined as the number of inactive seconds on a reserved connection before WebLogic Server reclaims the connection and releases it back into the connection pool.

Link : https://docs.oracle.com/cd/E24329_01/web.1211/e24367/ds_tuning.htm#JDBCA194

When you have a long running SQL query (say this query takes 90 seconds to complete) which exceeds the Inactive Connection Timeout value (say 20 seconds) specified in the JDBC Data source, the inactive timeout cleanup thread forcibly closes this connection after the Inactive Connection Timeout is reached with a BEA-001153 error code. (even before the application calls a commit).

Below is the code snippet from application :

Changes

Cause

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