How to PurgeOldExtracts on Both Sides
PurgeOldExtracts Of course, you can delete old, unused files manually and regularly. But for your convenience, you may set purge parameters in manager on both… Read More »How to PurgeOldExtracts on Both Sides
GoldenGate
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 reperror (1403, discard)
reperror (1403, discard) Found errors in REPLICAT and caused it stopped. GGSCI (target) 1> info all Program Status Group … Read More »How to Resolve OGG reperror (1403, discard)
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 OGG-00519 with ORA-00942
Recently, I initialized a set of EXTRACT / PUMP / REPLICAT for one schema, but some days after, the REPLICAT abended with this error: 2017-05-10… Read More »How to Resolve OGG-00519 with ORA-00942
Golden Gate Installation and Configuration
Suppose that you have two Oracle database 12c installed on the servers. One is for the source database (ora12c1), the other is the target database… Read More »Golden Gate Installation and Configuration
How to Resolve OGG-01154 Error Message
Updated some data but saw errors in REPLICAT logGGSCI (ora12c2.example.com) 28> view report ERPAPP_R...2017-04-30 19:09:47 WARNING OGG-01004 Aborted grouped transaction on 'HR.EMPLOYEES', Database error 1403… Read More »How to Resolve OGG-01154 Error Message
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
How to Resolve OGG-01091 Error Message
OGG-01091 Unable to open file on Target Server Saw an error OGG-01091 in REPLICAT report 2017-03-23 10:12:53 ERROR OGG-01091 Unable to open file "./dirdat/PT0000364"… Read More »How to Resolve OGG-01091 Error Message