Although you have configured your GoldenGate environment, maybe in its simplest form, with one source and one target database, but despite starting the Manager, Extract, and Replicat processes, data is not being replicated. So, what can be done?
The easiest way to determine that data replication is not working is to execute row count SQL against a given source table and compare results with its target table. Then, drill into the GoldenGate processes to obtain their status and statistics.
The following sections provide the necessary troubleshooting tips to enable a quick resolution to the most common issues.
Start your troubleshooting at the source. We need to determine that Extracts are processing data before looking at all the other components in the data stream. Once confirmed, we can move on to troubleshoot the data pump and Replicat processes.
If the Extract process will not start, the SEND
command will fail. However, GoldenGate...