Zero Downtime Installation Guide for Oracle

10.3 HotFix 2

Back Next

Message queue replication is not working

If the cmxzdt.configure_ggs_replicate script does not complete, the ZDT message queue replication might not work between the source database and the target database.

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 EQENVA 
EXTRACT RUNNING E_ENVA
EXTRACT RUNNING PQENVA 
EXTRACT RUNNING P_ENVA 
REPLICAT RUNNING RQENVA

EXTRACT RUNNING EQENVB
EXTRACT RUNNING PQENVB 
REPLICAT RUNNING RQENVB
REPLICAT ABENDED R_ENVB 
REPLICAT RUNNING R_ENVBU

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

Verify that the message queue replication is working in both directions.

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' );

The following code adds an event to the table on ENVB:

insert into C_REPOS_ZDT_EVENT_QUEUE ( 'envb', -1, 'test', '', 'enva', '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