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
GoldenGate
How to Resolve OGG-01233 Send TCP params error: TCP/IP error 104 (Connection reset by peer), endpoint
OGG-01233 Most abended pump process are caused by network related problems, OGG-01233 is not exceptional. GGSCI (dbs2) 2> info all Program Status … Read More »How to Resolve OGG-01233 Send TCP params error: TCP/IP error 104 (Connection reset by peer), endpoint
How to Reload Manager Parameter
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 Reload Manager Parameter
How to Patch Oracle GoldenGate 12c
Use the Latest OPatch First of all, we have to download the latest OPatch utility for GoldenGate. In this case, we downloaded OPatch 11.2.0.3.25 for… Read More »How to Patch Oracle GoldenGate 12c
How to Resolve ORA-01438 in GoldenGate
ORA-01438 with OGG-00869 in GoldenGate REPLICAT was found as ABENDED in the daily check on GoldenGate. ORA-01438 with OGG-00869 is found in REPLICAT report: 2018-06-21… Read More »How to Resolve ORA-01438 in GoldenGate
How to Resolve OGG-01973 Error Message
OGG-01973 The redo record indicates data loss on object Found an extract abended when I checked the synchronization status of Golden Gate. [oracle@test ogg]$ ./ggsci… Read More »How to Resolve OGG-01973 Error Message
OGG-15163 Force Stop Extract or Replicat
OGG-15163 When we tried to stop a GoldenGate service process, we may see OGG-15163 to alert us that the process is unstoppable. Let's see what… Read More »OGG-15163 Force Stop Extract or Replicat
How to Resolve OGG-00458 Cannot find metadata property
OGG-00458 One EXTRACT of GoldenGate was found abended on the production server by the following error: 2017-09-23 20:05:18 ERROR OGG-00458 Cannot find metadata property DDL_MD_COL_PREC. … Read More »How to Resolve OGG-00458 Cannot find metadata property
How to Resolve OGG-01168 Encountered an update for target table XXX
OGG-01168 The REPLICAT stopped due to the following error. 2017-09-14 19:52:01 ERROR OGG-01168 Encountered an update for target table HR.MAIN_TEAMS_RECRUIT, which has no unique… Read More »How to Resolve OGG-01168 Encountered an update for target table XXX
How to Resolve OGG-00519 Error Message
OGG-00519 In the remote database, you may not create all objects to resolve dependency problems. Here are some OGG-00519 DDL errors in REPLICAT report below:… Read More »How to Resolve OGG-00519 Error Message