ORA-3113 Reported Using Firewalls
(Doc ID 1388804.1)
Last updated on JANUARY 01, 2020
Applies to:
Oracle Net Services - Version 10.2.0.1 to 12.1.0.2 [Release 10.2 to 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
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
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 |
Changes |
Cause |
Solution |