Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

STREAMS Apply errors in apply queue ORA-02291: integrity constraint

690977Nov 12 2012 — edited Apr 25 2013

Hi friend,

one of my streams replication node is not getting updated from the Soure(MATSER DB node) in streams replication and
I see lots of apply errors showing in the apply queue.

i get the below error in streams logs
when i query dba_apply view for apply_Errors.

can anyone help me how to fix this issue and catchup the replication again?
is it related to conflict handlers??

Apply Local Messages in
Process Source Transaction Error
Name Database ID Error Number Error Message Transaction
---------- ---------- ----------- ------------ -------------------------------------------------- -----------
JDDB1_APP JDDB1.WORL 7.6.1197233 2091 ORA-02291: integrity constraint (R6.FK_ACCOUNT_SVC 1
D _PACKAGE) violated - parent key not found

JDDB1_APP JDDB1.WORL 4.32.123221 2091 ORA-02291: integrity constraint (R6.FK_USR_ACCOUNT 3
D 3 ) violated - parent key not found

JDDB1_APP JDDB1.WORL 1.8.1032939 2091 ORA-02291: integrity constraint (R6.FK_ACCOUNT_SVC 1
D _PACKAGE) violated - parent key not found

Locked Post

New comments cannot be posted to this locked post.

Locked on May 23 2013

Added on Nov 12 2012

#database-key-features, #replication

1 comment

2,057 views