This metric detects when a Streams Apply process configured on this database aborts. This metric indicates a critical error.
The DBA_APPLY view STATUS column indicates "ABORTED" if the apply process has aborted.
Obtain the exact error message in dba_apply, take the appropriate action for this error, then restart the apply process using dbms_apply_adm.start_apply.
Using the DBA_APPLY_ERROR view, identify the specific change record which encountered an error(MESSAGE_NUMBER) within a failed transaction and the complete error message (ERROR_MESSAGE). Detailed information about the transaction can be found using Enterprise Manager or by using the scripts described in the documentation Displaying Detailed Information about Apply Errors.
If DBA_APPLY error message is ORA-26714, then consider setting the 'DISABLE_ON_ERROR' apply parameter to 'N' to avoid aborting on future user errors.
Related Topics
About Alerts
About the Metric Detail Page
Editing Thresholds
Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.