My Oracle Support Banner

Connections to Database terminate with ORA-3113 or ORA-3135 (Doc ID 1104673.1)

Last updated on DECEMBER 30, 2019

Applies to:

Oracle Net Services - Version 10.2.0.1 and later
Oracle Database - Standard Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Jan-2012***
Connections to database terminate with ORA-3113
Connections to database terminate with ORA-03113: end-of-file on communication channel
Connections are left idle for a time
Connections are passing via a firewall


Symptoms

Established connections to the database fail after a few minutes of inactivity, reporting the error code ORA-3113 end-of-file on communication channel.
This can also be reported as an ORA-3135 "connection lost contact" for newer Oracle versions.

Connections are passing via a firewall and can be idle for a time.
Following example trace is for SQL*plus failure, on Windows. Error stack will change for other platforms.
Oracle Net level 16 client trace of the failure shows time gap for the connection.
This example was after the connection handshake.

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
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.