GoldenGate

How to Reload Manager Parameters without Restarting

Posted on
Many services in Linux support reload action to make new parameter file take effect online without restarts. For example,[oracle@test ~]$ systemctl reload httpd.serviceIn the same concept, we can also reload GoldenGate Manager parameter online without interrupting EXTRACT, PUMP or REPLICAT working process.GGSCI (chicago) 6> refresh mgrSending REFRESH request to MANAGER …Mgr Params UpdatedThen, we should […]
GoldenGate

How to Resolve OGG-05500

Posted on
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 metadata mismatch between current trail file /u01/app/ogg/dirdat/ET000360 and the previous sequence.*DBCHARSET: [0]/[10226].Here are the steps to resolve the problem.Renew and stop the extract.GGSCI (source) 2> SEND EXTRACT ERPAPP_E LOGENDGGSCI (source) 3> STOP […]
GoldenGate

How to Resolve ./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory

Posted on
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 [oracle@ora12c1 ogg]$ ./ggsci ./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory GoldenGate put all necessary shared objects (.so files) under its […]