Zero Downtime Installation Guide for Oracle

10.5 HotFix 3

Back Next

Replication is not working

If the deploy_zdt call does not complete, the ZDT replication might not work between the source and target databases.

Check that all the Oracle GoldenGate processes are running. Restart any processes that are not in the RUNNING state.

In this example, ENVA contains the source database and ENVB contains the target database.

EXTRACT RUNNING E_ENVA
REPLICAT ABENDED R_ENVB 
REPLICAT RUNNING R_ENVBU

In this example, the R_ENVB process is in the ABENDED state. Try restarting the process.

Insert an event directly into the C_REPOS_ZDT_EVENT_QUEUE table in the source database. Open the same table in the target database. If the event appears in the target database table, replication is working in this direction. Repeat the verification process from the target database to ensure that the replication works in the other direction as well.

For example, the following code adds an event to the table on ENVA:

insert into C_REPOS_ZDT_EVENT_QUEUE ( 'enva', -1, 'test', '', 'envb', 'test', CURRENT_TIMESTAMP, 'EVENT_TOKEN' );

If the Oracle GoldenGate processes are running without errors, but the message queue replication is not working, you need to troubleshoot your environment. Navigate to the Oracle GoldenGate directory

dirrpt

and check the .rpt files for information about potential problems.

For more information about replication issues, see the following Oracle articles on Metalink:

Main Note - Oracle GoldenGate - Troubleshooting (Doc ID 1306476.1)

Master Note - Oracle GoldenGate: Initial Load Techniques and References (Doc ID 1311707.1)

DB Transactions Missing from Oracle GoldenGate Trail Files (Doc ID 1364852.1)

POC for golden gate

Troubleshooting

Download Guide

Watch

Comments

Communities