My Oracle Support Banner

Oracle DB 11g : Apply Process Getting Aborted. (Doc ID 1913869.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Streams Apply Process Getting Aborted.

When enabling apply trace with  dbms_apply_adm.set_parameter('<apply_name>','trace_level','127');

 

Trace file /db/oracle/diag/rdbms/drdb/drdb/trace/drdb_ora_6097.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /db/oracle/product/11.2.0/dbhome_1
System name:    SunOS
Node name:      XXXXX
Release:        5.10
Version:        Generic_147440-12
Machine:        XXXXX
Instance name: XXXXX

[...]

value =              
segcol = 266, intcol = 266, usrcol = 266, flags 0, flags3 0 knglcolx: null
allocsz=1 dtytyp=2 csetform=0 ptr=5fb254f08, flags=0x0
           (dty, kncdty, acl, csf, csi, ind)=(2,0,1,0,0,0)
value = 0
knanrdis: propagation receiver is exiting due to ORA-26804.    <==================================  failure with ORA-26804

*** 2014-07-23 09:53:11.375
knlz_UsrrolDes()
knanrterm anrctx=0x7df76288 flags_knanr=0x3
knluOGGFCClear
knluOGGFCClear done
knclpterm:scalar_buf_knclpctx ds=78f23b58
knlsoUnsubscribeSO: pcount=1
knlsoUnsubscribeSO: ref count 0, heap=6032f8218, flags=14
knlsoCleanVPSO: releasing heap_knlvpso 0x32f8218
kadso = 0 0
knldso: releasing so 0x89c43c08
knstdso: releasing so 0xb1c4a530 for session 323, type 11

 

or

 

 

Goldengate Integrated Replicat abends because of the error ORA-26804, when the command 
'send replicat rep1, integratedparams(...)' is used. 

Generated trace file:


 knanrdis (opcode=2) 
knlcsrlcr: end-of-stream flag received 
knanrdis: propagation receiver is exiting due to ORA-26804.  <==================================  failure with ORA-26804
dbms_apply_adm.stop_apply()+ 
apply_name=OGG$REP1 
dbms_logrep_util_invok.check_2level_privilege()+ 
knlStopProc()+ 
knaliStopApplyInternal() 
knluSetStatus()+{ 

*** 2012-10-17 01:31:06.205 
knalpchg()+ 
knalpUpdate()+ 
finished knluSetStatus()+ } 
knalGetApplyNum()+ 
knalGetApplyProcess()+ 

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.