Connections to Database terminate with ORA-3113 or ORA-3135
(Doc ID 1104673.1)
Last updated on JULY 05, 2023
Applies to:
Oracle Net Services - Version 10.2.0.1 and laterOracle Database - Standard Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
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 |