My Oracle Support Banner

"Connection timed out", ORA-03113, and "Closed Connection" on Idle Connections (Doc ID 1060344.1)

Last updated on NOVEMBER 22, 2017

Applies to:

JDBC - Version 10.1.0 and later
Information 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!


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