"Connection timed out", ORA-03113, and "Closed Connection" on Idle Connections
(Doc ID 1060344.1)
Last updated on JANUARY 04, 2023
Applies to:JDBC - Version 10.1.0 and later
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!