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

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