ORA-3113 Reported Using Firewalls
(Doc ID 1388804.1)
Last updated on JANUARY 17, 2025
Applies to:
Oracle Net Services - Version 10.2.0.1 to 12.1.0.2 [Release 10.2 to 12.1]Oracle Database - Enterprise Edition - Version 19.7.1.0.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
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 |