"Connection timed out", ORA-03113, and "Closed Connection" on Idle Connections
(Doc ID 1060344.1)
Last updated on JUNE 03, 2024
Applies to:
JDBC - Version 10.1.0 and laterInformation in this document applies to any platform.
Symptoms
In a production environment, an application runs on a application server and connects to a Oracle database via JDBC 10g or higher (using either JDBC/Thin or JDBC/OCI). The application uses connection pools.
When the application is inactive for a while (typically overnight, but sometimes for shorter periods that are thought to be more than one hour), the following exceptions appear in the application server log:
java.sql.SQLException: Io exception: Connection timed out
java.sql.SQLException: ORA-03113: end-of-file on communication channel
java.sql.SQLException: Closed Connection
Attempts to get a new connection hang.
The issue does not occur in the User Acceptance Test (UAT) and Quality Assurance (QA) environments.
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! |