Your browser does not support JavaScript. This help page requires JavaScript to render correctly.
Skip Headers
Previous
Previous
 
Next
Next

Enabling and Disabling a Propagation

This topic contains instructions for enabling or disabling a propagation in Enterprise Manager.

You might need to disable a propagation if the database to which the propagation sends messages goes down or if a network problem prevents the propagation from sending messages. In these situations, you can disable the propagation and enable it when the problem is corrected.

Also, a propagation is aborted automatically after it fails to send messages in 16 consecutive attempts. When this happens, the error is displayed on the Propagation subpage of the Streams page in Enterprise Manager. In this case, you should correct the error and enable the propagation.

To enable or disable a propagation: 

  1. In Oracle Enterprise Manager, log in to the database as the Oracle Streams administrator.

  2. Go to the Database Home page.

  3. Click Data Movement to open the Data Movement subpage.

  4. Click Manage Replication in the Streams section.

    The Streams page appears, showing the Overview subpage.

  5. Click callbackStreams to open the Streams subpage.

  6. Select the propagation that you want to enable or disable in the list of components. If necessary, use the search tool to find the propagation, and then select it.

  7. In the Action list, select Enable to start a disabled or aborted propagation, or select Disable to stop an enabled propagation.

  8. Click Go.

Note: You can also use the START_PROPAGATION procedure and STOP_PROPAGATION procedure in the DBMS_PROPAGATION_ADM package to start and stop a propagation.

Related Topics

About Change Propagation Between Databases

Monitoring Propagations

Oracle Streams Advanced Queuing User's Guide for more information about managing propagations and propagation schedules