Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 24 2007
Added on Aug 20 2007
#performance-availability, #streams
5 comments
2,325 views