Home » Server Options » Streams & AQ » Oracle CDC - WAITING FOR REDO (Oracle 10g Source 2 NODE RAC STAGE Standalone)
Oracle CDC - WAITING FOR REDO [message #515764] Wed, 13 July 2011 03:51
Messages: 96
Registered: November 2008
Location: London

Hi guys,

I am facing troubles with setting up Oracle CDC in my environment. I have source as 2 Node Oracle RAC ( and stage as standalone server ( with OWB installed on this. I have implement archive logging on source and it is successfully transporting archive logs on the stage server. Also all the logs are getting registered with the capture process (in dba_registered_archived_log view). Strangely only first file got 'YES' value in the DICTIONARY_BEGIN column but rest has 'NO' value.
When I query v$streams_capture view it says 'WAITING FOR REDO'.

I have set up java_pool, streams_pool, remote_login_passwordfile as SHARED on both source and staging, and global_names = TRUE on source .

Could you please share your insights what can be potentially wrong with the environment. Please advice.

Previous Topic: Unable to Access Destination Que in IBM MQ
Next Topic: Oracle Streams
Goto Forum:

Current Time: Wed Oct 22 20:34:18 CDT 2014

Total time taken to generate the page: 0.24251 seconds