Oracle7 Server Distributed Systems Volume II: Replicated Data

CHAPTER 9. Troubleshooting

This chapter describes several common problems that you may encounter when using the symmetric replication facility, and suggested resolutions. The topics include:

using the DBA_REPCATLOG view to diagnose problems.

disabling the job queue while diagnosing problems.

diagnosing problems with job queues.

diagnosing problems with the propagation of changes between sites in a replicated environment.

diagnosing problems with snapshots.

Note: Often when diagnosing a replication problem, you will need to consult one or more data dictionary views. For the replication catalog views, always use the SYS.DBA_name views if you are authorized. Otherwise, use either the ALL_name or USER_name views. The views for deferred remote procedure calls are all owned by SYS and have no prefix.