How to Check if GoldenGate is in Sync
Is Data in Sync? After building OGG data synchronization, we'd like to make sure all EXTRACT log are applied to the REPLICAT database in Oracle… Read More »How to Check if GoldenGate is in Sync
GGSCI
How to Make Manager Parameter Take Effect Online
When I temporarily change the retention hour of extract tail to only 1 hour, I want it to take effect immediately. [oracle@test dirprm]$ vi mgr.prm… Read More »How to Make Manager Parameter Take Effect Online
How to Reload Manager Parameters without Restarting
Many services in Linux support reload action to make new parameter file take effect online without restarts. For example, [oracle@test ~]$ systemctl reload httpd.service In… Read More »How to Reload Manager Parameters without Restarting
How to Resolve OGG-05500 Detected database metadata mismatch between current trail file
OGG-05500 Saw an error after trying to resume a pump extract that was stopped a few weeks ago. 2017-05-10 14:34:34 ERROR OGG-05500 Detected database… Read More »How to Resolve OGG-05500 Detected database metadata mismatch between current trail file
How to Resolve ./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory
Missing Shared Libraries libnnz12.so Saw an error when I tried to get into Oracle GoldenGate Software Command Interface (GGSCI) after installation. [oracle@ora12c1 ~]$ cd $OGG_HOME… Read More »How to Resolve ./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory