10.1 Client Errors with ORA-3113 when using Server Side Transparent Application Failover (Doc ID 461932.1)

Last updated on DECEMBER 30, 2007

Applies to:

Oracle Net Services - Version: 10.1 to 10.1
This problem can occur on any platform.

Symptoms

10.1 client using server side Transparent Application Failover errors with ORA-3113: end-of-file on communication channel.

10.2 clients work fine

C:\>sqlplus scott/tiger@servertaf
SQL*Plus: Release 10.1.0.5.0 - Production on Wed Oct 3 10:54:32 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining
options
.
SQL> select instance_name,host_name from v$instance;
.
INSTANCE_NAME
----------------
HOST_NAME
----------------------------------------------------------------
rac2
dell02

**** Instance rac2 shutdown ***
.
SQL> /
select instance_name,host_name from v$instance
*
ERROR at line 1:
ORA-3113: end-of-file on communication channel

Oracle Net client trace shows

Windows 10.1 client

nserror: nsres: id=0, op=68, ns=12537, ns2=12560; nt[0]=507, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsrdr: error exit
nsdo: nsctxrnk=0
nsdo: error exit
nioqer: entry
nioqer:  incoming err = 12151
nioqce: entry
nioqce: exit
nioqer:  returning err = 3113

Unix 10.1 Client (HP)

ntt2err: soc 23 error - operation=5, ntresnt[0]=517, ntresnt[1]=232, ntresnt[2]=0
ntt2err: exit
nttrd: exit
nsprecv: error exit
nserror: entry
nserror: nsres: id=0, op=68, ns=12547, ns2=12560; nt[0]=517, nt[1]=232, 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: 12547
nioqper:    ns (2)  err code: 12560
nioqper:    nt main err code: 517
nioqper:    nt (2)  err code: 232
nioqper:    nt OS   err code: 0
nioqer: entry
nioqer:  incoming err = 12151
nioqce: entry
nioqce: exit
nioqer:  returning err = 3113

 

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