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
Oracle GoldenGate (OGG)
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 Check GoldenGate Version
GoldenGate Versions Currently, there're several GoldenGate versions in Oracle: Oracle GoldenGate 21.3 Oracle GoldenGate 21.1 Oracle GoldenGate 19.1 Oracle GoldenGate 18.1 Oracle GoldenGate 12.3.0.1 Oracle… Read More »How to Check GoldenGate Version
How to Build Asymmetric Standby Database for Data Guard
Asymmetric Data Guard Usually we build data guard environments with the symmetric architecture design on primary and standby servers, that is, single-instance to single-instance or… Read More »How to Build Asymmetric Standby Database for Data Guard
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