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!

Capture process failure

438381Aug 20 2007 — edited Aug 27 2007

Hello:

I have CDC setup with a 2-node Oracle 9i RAC database as source and an Oracle 10g system as the destination. I was able to get changes made to specified tables at the source propagate over to the destination. However, for the last set of update I see the capture process failing at the 9i source. Restarting the capture process doesnt help. Here's what I see in the trace file produced by the failed capture process.

Help !

--

*** SESSION ID:(134.4634) 2007-08-17 13:37:40.500
*** 2007-08-17 13:37:40.500
WARNING: received KRVX_OPER_CANNOT_SUPPORT
KDOG Missing from redo
knlldmm: gdbnm=EBRAV.WORLD
knlldmm: objn=516
knlldmm: objv=0
knlldmm: scn=24478026284
.......
......
......
End knlcDumpCapCtx:*********************************************
*** 2007-08-17 17:07:56.230
error 604 in STREAMS process
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYSTEM.SYS_C001163) violated
ORA-06512: at line 1
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYSTEM.SYS_C001163) violated
ORA-06512: at line 1

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2007

Added on Aug 20 2007

#performance-availability, #streams

5 comments

2,376 views