Aug 3 2008, 11:42 PM
I have a 4-way streams replication environment. DB is 10.2 and platforms are Win Server 2003.
I noticed recently that updates to one DB was not going through, but ok to 2.
I attempted to stop and then start the propogation from the source DB with:
but this procedure hangs.
Does anyone have any idea why this is?
Aug 4 2008, 07:54 AM
>> Does anyone have any idea why this is?
It could be many things, you need to troubleshoot it! I would use the diagnostic checklists from the Oracle Streams book:http://www.rampant-books.com/book_2004_2_streams.htm
Also, query the Oracle Streams views for clues:http://www.dba-oracle.com/t_streams_monito...reams_views.htm
If you don't want to write the scripts yourself, you can download them from the Oracle script collection:http://www.oracle-script.com/