My Oracle Support Banner

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

Last updated on MARCH 03, 2020

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 :

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

The server trace for the same connection shows:

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