Healthcheck for Multimaster Replication and Updatable Materialized View Replication
(Doc ID 751506.1)
Last updated on MAY 07, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 8.1.5.0 to 12.1.0.2 [Release 8.1.5 to 12.1] Information in this document applies to any platform.
Goal
The script published in this note is intended to gather a wide variety of information needed to troubleshoot Advanced Replication issues. It is primarily intended to collect information from Master Replication sites, but can also be used to gather information from Updatable Materialized View sites as well. The script should be run at each site in the replication environment, spooled to a file, and each output uploaded to the relevant Oracle Service Request.
Solution
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!