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

work on autovacuum postgreSQL parameter

 In This blog, we are discussing the auto vacuum parameter on a small scale. we will understand the below parameters and will see how to mod...