How to Check if GoldenGate is in Syncby Ed ChenFebruary 14, 2022May 26, 2022Is 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
How to Make Manager Parameter Take Effect Onlineby Ed ChenOctober 10, 2020September 16, 2020When 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 Restartingby Ed ChenJuly 1, 2017June 27, 2022Many 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 fileby Ed ChenMay 14, 2017November 14, 2021OGG-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 directoryby Ed ChenApril 9, 2017August 10, 202110 CommentsMissing 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