ORA-03113 TNS-12535 and TNS-12609 Errors Using TAF W Send/Recv Timeout Parameters (Doc ID 782914.1)

Last updated on MAY 20, 2015

Applies to:

Oracle Net Services - Version 10.2.0.5 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Symptoms

Environment Tested:

Server: Oracle10g R2 (10.2.0.4.0) on RAC Sun Solaris SPARC (64-bit) 10

Client: Oracle10g R2 (10.2.0.4.0) on Linux 2.4.21-4.EL #1

Receive ORA-3113 when testing TAF on client connection. Problem occurs when SQLNET.SEND_TIMEOUT and/or SQLNET.RECV_TIMEOUT are set in client side sqlnet.ora and are used in combination with TAF and FAILOVER (TYPE=SELECT) and (METHOD=BASIC) the ORA-3113 and/or ORA-12609 errors are reported when a physical disconnect occurs, and the session fails over to the surviving RAC server. (Select statement does not re-execute.)

Client sqlnet.ora parameters are used:

SQLNET.SEND_TIMEOUT = <numeric value is seconds>

SQLNET.RECV_TIMEOUT = <numeric value is seconds>

-------

SUPPORT level Oracle Net Client trace shows the following error stack when the disconnect is detected:

-------
nsprecv: reading from transport...
nttrd: entry
ntt2err: entry
ntt2err: exit
nttrd: exit
nsprecv: error exit
nserror: entry
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
nsrdr: error exit
nsdo: nsctxrnk=0
nsdo: error exit
nioqrc: wanted 1 got 0, type 0
nioqper: error from nioqrc
nioqper: ns main err code: 12535
nioqper: ns (2) err code: 12609
nioqper: nt main err code: 0
nioqper: nt (2) err code: 0
nioqper: nt OS err code: 0
nioqer: entry
nioqer: incoming err = 12151

-------


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