GoldenGate

How to Resolve ORA-01438 in GoldenGate

Posted on
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 08:39:27 WARNING OGG-00869 OCI Error ORA-01438: value larger than specified precision allowed for this column (status = 1438), SQL <INSERT INTO “ERPAPP”.”BANK_TRANS” ( ORA-01438 with OGG-01296 in GoldenGate A similar […]
GoldenGate

How to Resolve OGG-01973 The redo record indicates data loss on object

Posted on
Found an extract abended when I checked the synchronization status of Golden Gate.[oracle@test ogg]$ ./ggsciOracle GoldenGate Command Interpreter for OracleVersion 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBOLinux, x64, 64bit (optimized), Oracle 12c on Sep 25 2013 02:33:54Operating system character set identified as UTF-8.Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.GGSCI (test) 1> info allProgram     Status  […]
GoldenGate

How to Resolve OGG-00458 Cannot find metadata property

Posted on
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.  DDL metadata [,G1=’alter table DWWORKRQ nologging …According to the knowledge base of MOS, it’s found to be a bug. Either you apply the patch, or workaround it by adding one line parameter […]
DDL

How to Resolve OGG-00519 REPLICAT DDL Errors in GoldenGate

Posted on
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: 2017-08-22 19:52:03  ERROR   OGG-00519  Fatal error executing DDL replication: error [Error code [1435], ORA-01435: user does not exist SQL ALTER SESSION SET CURRENT_SCHEMA=”PUBLIC”], no error handler present. 2017-08-23 20:18:54 […]
GoldenGate

How to Purge Old Extracts on Both Sides

Posted on
Of course, you can delete old, unused files manually and regularly. But for your convenience, you may set purge parameters in manager on both sides, it will delete history data and obsolete files every hour.On the local server.[root@local dirprm]# vi mgr.prm…userid ogg@orcl, password oggpwd…purgeoldextracts ./dirdat/*, usecheckpoints, minkeepfiles 100purgemarkerhistory minkeepdays 5, maxkeepdays 7, frequencyhours 24purgeddlhistory minkeepdays […]
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 ORA-00001, ORA-01403 in GoldenGate

Posted on
Found errors in REPLICAT and caused it stopped.GGSCI (target) 1> info allProgram     Status      Group       Lag at Chkpt  Time Since ChkptMANAGER     RUNNINGREPLICAT    ABENDED     ERPAPP_R    00:00:13      53:34:02GGSCI (target) 2> view report ERPAPP_R…2017-05-24 23:12:11  WARNING OGG-00869  OCI Error ORA-00001: unique constraint (HR.EMPLOYEES_PK) violated […]
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 […]