Troubleshooting tips
So you have configured your GoldenGate environment, maybe in its simplest form, having one source and one target database. But despite starting the Manager, Extract, and Replicat processes, data is not being replicated.
The easiest way to determine that data replication is not working is to execute row counts against a given source and its target table. Then drill into the GoldenGate processes to obtain their status and statistics.
The following paragraphs provide the necessary troubleshooting tips to enable a quick resolution to the most common issues.
Replication not working?
Start your troubleshooting at the source. We need to determine that the Extracts are processing data before looking at the other components in the data stream. Two methods exist to confirm throughput, which we have already discussed in Chapter 8, Managing Oracle GoldenGate and Chapter 9, Performance Tuning. These are the GGSCI SEND
and STATS
commands, demonstrated in the following examples:
GGSCI...