Previous |
Next |
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:
In Oracle Enterprise Manager, log in to the database as the Oracle Streams administrator.
Go to the Database Home page.
Click Data Movement to open the Data Movement subpage.
Click Manage Replication in the Streams section.
The Streams page appears, showing the Overview subpage.
Click Streams to open the Streams subpage.
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.
In the Action list, select Enable to start a disabled or aborted propagation, or select Disable to stop an enabled propagation.
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.
About Change Propagation Between Databases
Oracle Streams Advanced Queuing User's Guide for more information about managing propagations and propagation schedules