ORA-3113 Reported Using Firewalls (Doc ID 1388804.1)

Last updated on MARCH 07, 2017

Applies to:

Oracle Net Services - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Oracle Net Services - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Client reported ORA-3113, while processing a query after a couple of minutes of idle time.
Level 16 client trace shows the following stack:

2011-12-16 07:11:54.598189 : nsprecv:reading from transport...
2011-12-16 07:11:54.598213 : nttrd:entry
2011-12-16 07:12:13.470991 : ntt2err:entry
2011-12-16 07:12:13.471091 : ntt2err:soc 828 error - operation=5, ntresnt[0]=530, ntresnt[1]=53, ntresnt[2]=0
2011-12-16 07:12:13.471120 : ntt2err:exit
2011-12-16 07:12:13.471144 : nttrd:exit
2011-12-16 07:12:13.471185 : nsprecv:error exit
2011-12-16 07:12:13.471214 : nserror:entry
2011-12-16 07:12:13.471243 : nserror:nsres: id=0, op=68, ns=12570, ns2=12560; nt[0]=530, nt[1]=53, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
2011-12-16 07:12:13.471271 : nsrdr:error exit
2011-12-16 07:12:13.471298 : nsfull_pkt_rcv:nsctxrnk=0
2011-12-16 07:12:13.471323 : nsfull_pkt_rcv:error exit
2011-12-16 07:12:13.471350 : nioqrc:recv: packet reader error -> translated to IFCR_EOF
2011-12-16 07:12:13.471377 : nioqer:entry
2011-12-16 07:12:13.471403 : nioqer: incoming err = 12151
2011-12-16 07:12:13.471427 : nioqce:entry
2011-12-16 07:12:13.471452 : nioqce:exit
2011-12-16 07:12:13.471476 : nioqer: returning err = 3113
2011-12-16 07:12:13.471501 : nioqer:exit
2011-12-16 07:12:13.471525 : nioqrc:exit
2011-12-16 07:12:13.471560 : nioqds:entry


Error 53, lowest in stack is in this case for windows, is WSAECONNABORTED 53 10053
Network dropped connection on reset.

Changes

Customer implemented the SEIM NitroSecurity firewall

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