Error:

2017-12-27 22:51:11  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, rep1.prm:  REPLICAT REP1 started.
2017-12-27 22:51:11  WARNING OGG-03504  Oracle GoldenGate Delivery for Oracle, rep1.prm:  NLS_LANG character set AL32UTF8 on the target is different from the source database character set WE8MSWIN1252. Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.
2017-12-27 22:51:11  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, rep1.prm:  OCI Error ORA-02291: integrity constraint (DA.PMSET_PMPROJECT_FK) violated - parent key not found (status = 2291). UPDATE "DA"."PMSET_TN" SET "PMSET_COMP_CODE" = :a1,"PMSET_DEFAULT_PROJ_ORASEQ" = :a2,"PMSET__IU__UPDATE_DATE" = :a3,"PMSET__IU__UPDATE_USER" = :a4,"PMSET_LAST_SESSIONINFO" = :a5 WHERE "PMSET_USER" = :b0.
2017-12-27 22:51:11  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Aborted grouped transaction on 'DA.PMSET_TN', Database error 2291 (OCI Error ORA-02291: integrity constraint (DA.PMSET_PMPROJECT_FK) violated - parent key not found (status = 2291). UPDATE "DA"."PMSET_TN" SET "PMSET_COMP_CODE" = :a1,"PMSET_DEFAULT_PROJ_ORASEQ" = :a2,"PMSET__IU__UPDATE_DATE" = :a3,"PMSET__IU__UPDATE_USER" = :a4,"PMSET_LAST_SESSIONINFO" = :a5 WHERE "PMSET_USER" = :b0).
2017-12-27 22:51:11  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Repositioning to rba 68690185 in seqno 42.
2017-12-27 22:51:11  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, rep1.prm:  SQL error 2291 mapping DA.PMSET_TN to DA.PMSET_TN OCI Error ORA-02291: integrity constraint (DA.PMSET_PMPROJECT_FK) violated - parent key not found (status = 2291). UPDATE "DA"."PMSET_TN" SET "PMSET_COMP_CODE" = :a1,"PMSET_DEFAULT_PROJ_ORASEQ" = :a2,"PMSET__IU__UPDATE_DATE" = :a3,"PMSET__IU__UPDATE_USER" = :a4,"PMSET_LAST_SESSIONINFO" = :a5 WHERE "PMSET_USER" = :b0.
2017-12-27 22:51:11  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Repositioning to rba 68690185 in seqno 42.
2017-12-27 22:51:11  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Error mapping from DA.PMSET_TN to DA.PMSET_TN.
2017-12-27 22:51:11  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rep1.prm:  PROCESS ABENDING.


Fix:

GGSCI (oracledbprod-ro) 10> alter replicat rep1 begin now
REPLICAT altered.


GGSCI (oracledbprod-ro) 11> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED
REPLICAT    STOPPED     REP1        00:00:00      00:00:02


GGSCI (oracledbprod-ro) 12> start manager

Manager started.


GGSCI (oracledbprod-ro) 13> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
REPLICAT    RUNNING     REP1        00:00:00      00:00:09

Uninstalling Oracle GoldenGate Using Oracle Universal Installer

Target Side:

Un-Installing Software:

[oracle@oracledbprod-ro deinstall]$ ./deinstall.sh

ALERT: Ensure all the processes running from the current Oracle Home are shutdown prior to running this software uninstallation script.

Proceed with removing Oracle GoldenGate home: /u01/oracle/ogghome/12.2 (yes/no)? [no]

yes

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 17694 MB    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-09-19_10-01-56PM. Please wait ...Oracle Universal Installer, Version 12.1.0.2.0 Production

Copyright (C) 1999, 2014, Oracle. All rights reserved.

Starting deinstall

Deinstall in progress (Tuesday, September 19, 2017 10:02:02 PM PDT)

............................................................... 100% Done.

Deinstall successful

End of install phases.(Tuesday, September 19, 2017 10:02:24 PM PDT)

End of deinstallations

Please check '/u01/oraInventory/logs/silentInstall2017-09-19_10-01-56PM.log' for more details.

Removing Directories:

$OGG_HOME

Dropping user and tablespaces:

SQL> drop user ggadmin;

User dropped.

SQL> DROP TABLESPACE OGG_DATA INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.

Source Side:

[oracle@oracledbtest deinstall]$ ./deinstall.sh

ALERT: Ensure all the processes running from the current Oracle Home are shutdown prior to running this software uninstallation script.

Proceed with removing Oracle GoldenGate home: /u01/oracle/ogghome/12.2 (yes/no)? [no]

yes

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 31095 MB    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-09-19_10-14-06PM. Please wait ...Oracle Universal Installer, Version 12.1.0.2.0 Production

Copyright (C) 1999, 2014, Oracle. All rights reserved.

Starting deinstall

Deinstall in progress (Tuesday, September 19, 2017 10:14:14 PM PDT)

............................................................... 100% Done.

Deinstall successful

End of install phases.(Tuesday, September 19, 2017 10:14:35 PM PDT)

End of deinstallations

Please check '/u01/oracle/oraInventory/logs/silentInstall2017-09-19_10-14-06PM.log' for more details.

[oracle@oracledbtest deinstall]$

SQL> drop trigger GGS_DDL_TRIGGER_BEFORE;

Trigger dropped.

SQL> DROP TABLESPACE OGG_DATA INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.

SQL> drop user ggadmin cascade;

User dropped.

Thank you,

Ram Nanubalu