This discussion is archived
0 Replies Latest reply: Mar 28, 2012 10:11 AM by jurrai RSS

Capture streaming does not work after upgrade of the source database.

jurrai Newbie
Currently Being Moderated
Hello,

We have a complex system with 2 X RAC databases 10.2.0.4 (source) and 2 X single databases (target) 11.2.0.2
Streaming is running only from source to target.
After upgrading RAC databases to 11.2.0.2 , streaming is working only from one RAC to one single database.
First RAC streaming is flowing to first single database only, and second RAC to second single only.

First source-target is streaming fine, second capture are aborted just after starting with following errors:

...
Streams CAPTURE CP05 for STREAMS started with pid=159, OS id=21174
Wed Mar 28 10:41:55 2012
Propagation Sender/Receiver (CCA) for Streams Capture and Apply STREAMS with pid=189, OS id=21176 started.
Wed Mar 28 10:43:05 2012
Streams APPLY AP05 for STREAMS started with pid=134, OS id=21696
Wed Mar 28 10:43:06 2012
Streams Apply Reader for STREAMS started AS0G with pid=191 OS id=21709
Wed Mar 28 10:43:06 2012
Streams Apply Server for STREAMS started AS04 with pid=192 OS id=21711
Wed Mar 28 10:43:30 2012
Streams CAPTURE CP05 for STREAMS with pid=159, OS id=21174 is in combined capture and apply mode.
Capture STREAMS is handling 1 applies.
Streams downstream capture STREAMS uses downstream_real_time_mine: TRUE
Starting persistent Logminer Session with sid = 621 for Streams Capture STREAMS
LOGMINER: Parameters summary for session# = 621
LOGMINER: Number of processes = 3, Transaction Chunk Size = 1
LOGMINER: Memory Size = 10M, Checkpoint interval = 1000M
LOGMINER: SpillScn 0, ResetLogScn 7287662065313
LOGMINER: summary for session# = 621
LOGMINER: StartScn: 12620843936763 (0x0b7a.84eb6bfb)
LOGMINER: EndScn: 0
LOGMINER: HighConsumedScn: 12620843936763 (0x0b7a.84eb6bfb)
LOGMINER: session_flag 0x1
LOGMINER: LowCkptScn: 12620843920280 (0x0b7a.84eb2b98)
LOGMINER: HighCkptScn: 12620843920281 (0x0b7a.84eb2b99)
LOGMINER: SkipScn: 12620843920280 (0x0b7a.84eb2b98)
Wed Mar 28 10:44:53 2012
LOGMINER: session#=621 (STREAMS), reader MS00 pid=198 OS id=22578 sid=1148 started
Wed Mar 28 10:44:53 2012
LOGMINER: session#=621 (STREAMS), builder MS01 pid=199 OS id=22580 sid=1338 started
Wed Mar 28 10:44:53 2012
LOGMINER: session#=621 (STREAMS), preparer MS02 pid=200 OS id=22582 sid=1519 started
LOGMINER: Begin mining logfile for session 621 thread 1 sequence 196589, /opt/app/oracle/admin/singledb/stdbyarch/singledb_1_196589_569775692.arc
Errors in file /opt/app/oracle/diag/rdbms/singledb/singledb/trace/singledb_ms00_22578.trc (incident=113693):
ORA-00600: internal error code, arguments: [krvxruts004], [11.2.0.0.0], [10.2.0.4.0], [], [], [], [], [], [], [], [], []
Incident details in: /opt/app/oracle/diag/rdbms/singledb/singledb/incident/incdir_113693/singledb_ms00_22578_i113693.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
krvxerpt: Errors detected in process 198, role reader.

...

We have 5 streaming processes running.
When we rebuilded one of them, everything works fine, but other are too big for rebuilding.

Has anybody met with such a behaviour ?
Oracle development is already working on it but we need faster solution.

Thanks
Jurrai

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points