My Oracle Support Banner

ORA-3113 And Timeout With SSL/TCPS Connections. (Doc ID 1298611.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Advanced Networking Option - Version to [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Feb-2013***


SSL connections time out intermittently. This is especially true when LOBs are transported across the network using SSL/TCPS connections.
The client session terminates with the error ORA-3113 : end-of-file on communication channel
The same operations will complete successfully when performed over TCP connections.
The issue is encountered with 10g Release 2 database version and 10g client. When using 11g client, the issue does not occur and the same operations complete successfully across SSL /TCPS connections.

The errors captured in client trace file look like this :

[28-OCT-2010 16:33:02:254] ntt2err: entry
[28-OCT-2010 16:33:02:254] ntt2err: exit
[28-OCT-2010 16:33:02:254] nttrd: socket 1808 had bytes read=0
[28-OCT-2010 16:33:02:254] nttrd: exit
[28-OCT-2010 16:33:02:254] ntznzosread: encountered "wouldblock" error
[28-OCT-2010 16:33:02:254] ntctst: size of NTTEST list is 1 - not calling poll
[28-OCT-2010 16:33:02:254] sntseltst: Testing for DATA on socket 1808
[28-OCT-2010 16:33:02:254] sntseltst: Testing for WRITE on socket 1808
[28-OCT-2010 16:33:02:285] sntseltst: FOUND: write request on socket 1808
[28-OCT-2010 16:33:02:285] ntznzosread: exit
[28-OCT-2010 16:33:02:285] nsprecv: error exit
[28-OCT-2010 16:33:02:285] nserror: entry
[28-OCT-2010 16:33:02:285] nserror: nsres: id=0, op=68, ns=12535, ns2=12609; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[28-OCT-2010 16:33:02:285] nsrdr: error exit
[28-OCT-2010 16:33:02:285] nsdo: nsctxrnk=0
[28-OCT-2010 16:33:02:285] nsdo: error exit
[28-OCT-2010 16:33:02:285] nioqrc: wanted 1 got 0, type 0
[28-OCT-2010 16:33:02:285] nioqper: error from nioqrc
[28-OCT-2010 16:33:02:285] nioqper: ns main err code: 12535
[28-OCT-2010 16:33:02:285] nioqper: ns (2) err code: 12609
[28-OCT-2010 16:33:02:285] nioqper: nt main err code: 0
[28-OCT-2010 16:33:02:285] nioqper: nt (2) err code: 0
[28-OCT-2010 16:33:02:285] nioqper: nt OS err code: 0
[28-OCT-2010 16:33:02:285] nioqer: entry
[28-OCT-2010 16:33:02:285] nioqer: incoming err = 12151
[28-OCT-2010 16:33:02:285] nttaddr2bnd: entry
[28-OCT-2010 16:33:02:285] snlinGetNameInfo: entry
[28-OCT-2010 16:33:02:285] snlinGetNameInfo: Using numeric form of host's address
[28-OCT-2010 16:33:02:285] snlinGetNameInfo: exit
[28-OCT-2010 16:33:02:285] nttaddr2bnd: Resolved to
[28-OCT-2010 16:33:02:285] nttaddr2bnd: exit
[28-OCT-2010 16:33:04:535] nioqce: entry
[28-OCT-2010 16:33:04:535] nioqce: exit
[28-OCT-2010 16:33:04:535] nioqer: returning err = 3113
[28-OCT-2010 16:33:04:535] nioqer: exit
[28-OCT-2010 16:33:04:535] nioqrc: exit
[28-OCT-2010 16:33:04:535] nioqds: entry
[28-OCT-2010 16:33:04:535] nioqds: disconnecting...
[28-OCT-2010 16:33:04:550] nsclose: entry

The server trace for the same connection shows:

[28-OCT-2010 16:33:02:697] ntznzosread: encountered "wouldblock" error
[28-OCT-2010 16:33:02:697] sntpoltsts: fd 21 need 41 readiness event, wait time -1
[28-OCT-2010 16:33:04:824] sntpoltsts: fd 21 has 2 readiness ev
[28-OCT-2010 16:33:04:824] sntpoltsts: exit
[28-OCT-2010 16:33:04:824] nttrd: entry
[28-OCT-2010 16:33:04:824] nttrd: socket 21 had bytes read=5
[28-OCT-2010 16:33:04:824] nttrd: exit
[28-OCT-2010 16:33:04:824] nttrd: entry
[28-OCT-2010 16:33:04:824] nttrd: socket 21 had bytes read=32
[28-OCT-2010 16:33:04:824] nttrd: exit
[28-OCT-2010 16:33:04:824] nttrd: entry
[28-OCT-2010 16:33:04:824] ntt2err: entry
[28-OCT-2010 16:33:04:824] ntt2err: exit
[28-OCT-2010 16:33:04:824] nttrd: socket 21 had bytes read=0
[28-OCT-2010 16:33:04:824] nttrd: exit
[28-OCT-2010 16:33:04:824] ntznzosread: read in 10 bytes
[28-OCT-2010 16:33:04:824] ntznzosread: no data remaining to be read from SSL buffer.
[28-OCT-2010 16:33:04:824] ntznzosread: exit
[28-OCT-2010 16:33:04:824] nsprecv: 10 bytes from transport
[28-OCT-2010 16:33:04:824] nsprecv: tlen=10, plen=10, type=6
[28-OCT-2010 16:33:04:824] nsprecv: packet dump
[28-OCT-2010 16:33:04:824] nsprecv: 00 0A 00 00 06 00 00 00 |........|
[28-OCT-2010 16:33:04:824] nsprecv: 00 40 |.@ |
[28-OCT-2010 16:33:04:824] nsprecv: normal exit
[28-OCT-2010 16:33:04:824] nsrdr: got NSPTDA packet
[28-OCT-2010 16:33:04:824] nsrdr: NSPTDA flags: 0x40
[28-OCT-2010 16:33:04:824] nsrdr: normal exit
[28-OCT-2010 16:33:04:824] nsdo: entry
[28-OCT-2010 16:33:04:824] nsdo: cid=0, opcode=85, *bl=2001, *what=0, uflgs=0x0, cflgs=0x1
[28-OCT-2010 16:33:04:824] nsdo: nsctx: state=6, flg=0x600c, mvd=0
[28-OCT-2010 16:33:04:824] nsdo: gtn=169, gtc=169, ptn=10, ptc=2011
[28-OCT-2010 16:33:04:824] nserror: entry
[28-OCT-2010 16:33:04:824] nsdo: error exit
[28-OCT-2010 16:33:04:824] nsdo: nsctxrnk=0
[28-OCT-2010 16:33:04:824] nsdo: error exit
[28-OCT-2010 16:33:04:824] nioqer: entry
[28-OCT-2010 16:33:04:824] nioqer: incoming err = 12151
[28-OCT-2010 16:33:04:824] nioqce: entry
[28-OCT-2010 16:33:04:824] nioqce: exit
[28-OCT-2010 16:33:04:824] nioqer: returning err = 3113
[28-OCT-2010 16:33:04:824] nioqer: exit
[28-OCT-2010 16:33:04:825] nioqrc: exit
[28-OCT-2010 16:33:04:825] nioqds: entry
[28-OCT-2010 16:33:04:825] nioqds: disconnecting...


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.