Connections to Database terminate with ORA-3113 or ORA-3135

(Doc ID 1104673.1)

Last updated on OCTOBER 13, 2017

Applies to:

Oracle Net Services - Version 10.2.0.1 and later
Oracle Database - Standard Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
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.

[27-APR-2010 16:26:35:156] nsdo: normal exit
[27-APR-2010 16:26:35:156] nioqrc: exit
[27-APR-2010 16:31:04:712] nioqsn: entry
[27-APR-2010 16:31:04:712] nioqsn: exit

nioqsn function is the client attempting to send a packet to the server.
Packet is then shown

[27-APR-2010 16:31:04:712] nsdofls: sending NSPTDA packet
[27-APR-2010 16:31:04:712] nspsend: entry
[27-APR-2010 16:31:04:712] nspsend: plen=137, type=6

Followed by a second delay and network transport error being reported

[27-APR-2010 16:31:04:712] nttrd: entry
[27-APR-2010 16:31:26:119] ntt2err: entry
[27-APR-2010 16:31:26:119] ntt2err: soc 328 error - operation=5, ntresnt[0]=517, ntresnt[1]=54, ntresnt[2]=0
[27-APR-2010 16:31:26:119] ntt2err: exit
[27-APR-2010 16:31:26:119] nttrd: exit
[27-APR-2010 16:31:26:119] nsprecv: error exit
[27-APR-2010 16:31:26:119] nserror: entry
[27-APR-2010 16:31:26:119] nserror: nsres: id=0, op=68, ns=12547, ns2=12560; nt[0]=517, nt[1]=54, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[27-APR-2010 16:31:26:119] nsrdr: error exit
[27-APR-2010 16:31:26:119] nsdo: nsctxrnk=0
[27-APR-2010 16:31:26:119] nsdo: error exit
[27-APR-2010 16:31:26:119] nioqrc: wanted 1 got 0, type 0
[27-APR-2010 16:31:26:119] nioqper: error from nioqrc
[27-APR-2010 16:31:26:119] nioqper: ns main err code: 12547
[27-APR-2010 16:31:26:119] nioqper: ns (2) err code: 12560
[27-APR-2010 16:31:26:119] nioqper: nt main err code: 517
[27-APR-2010 16:31:26:119] nioqper: nt (2) err code: 54
[27-APR-2010 16:31:26:119] nioqper: nt OS err code: 0
[27-APR-2010 16:31:26:119] nioqer: entry
[27-APR-2010 16:31:26:119] nioqer: incoming err = 12151
[27-APR-2010 16:31:26:119] nioqce: entry
[27-APR-2010 16:31:26:119] nioqce: exit
[27-APR-2010 16:31:26:119] nioqer: returning err = 3113

Cause

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 hundreds of Community platforms