Oracle DB 11g : Apply Process Getting Aborted.
(Doc ID 1913869.1)
Last updated on FEBRUARY 08, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterInformation 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 <TRACE FILE NAME>
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 =<ORACLE_HOME>
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 <REPLICAT_NAME>, 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$<REPLICAT_NAME>
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 |