Help - Search - Members - Calendar
Full Version: Streams propagation
Oracle DBA Forums > Oracle > Oracle Forum
mark.nz
Hi there,
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:

exec dbms_propagation_adm.stop_propagaion(propagation_name=>'SRCDB_TO_DESTDB');

but this procedure hangs.

Does anyone have any idea why this is?

Thanks.
burleson
>> 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/
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.