Failed to enable DBOPTIONS SUPPRESSTRIGGERS.

GG version:  12.2

Oracle DB:  12.1.0.2.0

GGSCI (targetserver) 3> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

REPLICAT    STOPPED     RDEV      00:00:00      00:32:14

GGSCI (targetserver) 4> start RDEV

Sending START request to MANAGER ...

REPLICAT RDEV starting

Error:

2017-02-09 13:29:36  ERROR   OGG-06472  Oracle GoldenGate Delivery for Oracle, RDEV.prm:  Failed to enable DBOPTIONS SUPPRESSTRIGGERS.

2017-02-09 13:29:36  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, RDEV.prm:  PROCESS ABENDING.

SOLUTION:

SQL> sho parameter spfile;

NAME                                 TYPE                             VALUE

------------------------------------ -------------------------------- ------------------------------

spfile                               string                      /opt/oracle/product/12.1.0.2.64/dbs/spfileTDEV.ora

                                                                     

SQL>  sho parameter ENABLE_GOLDENGATE_REPLICATION

NAME                                 TYPE                             VALUE

------------------------------------ -------------------------------- ------------------------------

enable_goldengate_replication        boolean                          FALSE

SQL> alter system set ENABLE_GOLDENGATE_REPLICATION = TRUE scope = both;

System altered.

SQL> sho parameter ENABLE_GOLDENGATE_REPLICATION

NAME                                 TYPE                             VALUE

------------------------------------ -------------------------------- ------------------------------

enable_goldengate_replication        boolean                          TRUE

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

targetserver:TDEV:/opt/oracle/product/12.1.0.2.64/dbs $ cd /opt/oracle/product/goldengate

targetserver:TDEV:/opt/oracle/product/goldengate $ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO

Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48

Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

GGSCI (targetserver) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

REPLICAT    STOPPED     RDEV      00:00:00      00:40:07

GGSCI (targetserver) 2> start RDEV

Sending START request to MANAGER ...

REPLICAT RDEV starting

GGSCI (targetserver as ggadmin@TDEV) 8> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

REPLICAT    RUNNING     RDEV      00:00:00      00:41:34

Refer:

GoldenGate Replicat Abends: ERROR OGG-6472 Failed to Enable DBOPTIONS SUPPRESSTRIGGERS (Doc ID 1614302.1)