Saturday, 15 June 2019

replicate not started due to OGG-02091


GGSCI (target.example.com) 14> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
REPLICAT    ABENDED     REPLCAT1    00:00:00      00:11:15


Error: 

2019-06-15 07:38:24  ERROR   OGG-02091  Operation not supported because enable_goldengate_repli
cation is not set to true.

2019-06-15 07:38:24  ERROR   OGG-01668  PROCESS ABENDING.


Solution:

SQL> show parameter enable_goldengate_replication

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication        boolean     FALSE
SQL> alter system set enable_goldengate_replication=true scope=spfile;

System altered.

SQL> show parameter enable_goldengate_replication

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication        boolean     TRUE
SQL>

GSCI (target.example.com) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
REPLICAT    RUNNING     REPLCAT1    00:00:00      00:00:00


No comments:

Post a Comment

PRKO-2012 : filesystem object is not supported in Oracle Restart

  Subject :      ACFS  not supported in Oracle Restart on 19c  Error :   [oracle@asm-node01 ~]$ srvctl status filesystem -d /dev/asm/ggdisk-...