Help - Search - Members - Calendar
Full Version: Streams propagation
Oracle DBA Forums > Oracle > Oracle Forum
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?

>> 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:

Also, query the Oracle Streams views for clues:

If you don't want to write the scripts yourself, you can download them from the Oracle script collection:
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-2016 Invision Power Services, Inc.