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

Hi guys,

I am facing troubles with setting up Oracle CDC in my environment. I have source as 2 Node Oracle RAC (10.2.0.3) and stage as standalone server (10.2.0.3) 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.

Regards
Nukesh
Previous Topic: Unable to Access Destination Que in IBM MQ
Next Topic: NEW ORACLE STRAMS CONFIG
Goto Forum:
  


Current Time: Thu Mar 28 10:28:44 CDT 2024