问题描述：搭建ogg时无法启动目标端复制进程，告警日志报错OGG-02091，如下所示：

环境：源端oracle 11.2.0.4 目标端：oracle 19.16

ogg软件：191004_fbo_ggs_Linux_x64_shiphome.zip

1、问题重现

GGSCI (leo-19c-ogg as ogg@simdb) 6> start repa

 

Sending START request to MANAGER ...

REPLICAT REPA starting

 

 

GGSCI (leo-19c-ogg as ogg@simdb) 7> info all

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

 

MANAGER     RUNNING                                          

REPLICAT    STOPPED     REPA        00:00:00      00:02:40   

 

2022-12-01 15:13:28  ERROR   OGG-02091  Operation not supported because enable_goldengate_replication is not set to true.

 

2022-12-01 15:13:28  ERROR   OGG-01668  PROCESS ABENDING.

2、异常原因

根据提示可知，enable_goldengate_replication参数未设置成true.

3、处理过程

[oracle@leo-19c-ogg dirrpt]$ sqlplus / as sysdba

 

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 1 15:17:59 2022

Version 19.16.0.0.0

 

Copyright (c) 1982, 2022, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.16.0.0.0

 

SQL> show parameter enable_goldengate

 

NAME                                 TYPE        VALUE

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

enable_goldengate_replication        boolean     FALSE

SQL> alter system set enable_goldengate_replication=true;

 

System altered.

 

SQL> show parameter enable_goldengate_replication

 

NAME                                 TYPE        VALUE

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

enable_goldengate_replication        boolean     TRUE

 

4、验证

GGSCI (leo-19c-ogg as ogg@simdb) 8> start repa

 

Sending START request to MANAGER ...

REPLICAT REPA starting

 

 

GGSCI (leo-19c-ogg as ogg@simdb) 9> info all

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

 

MANAGER     RUNNING                                          

REPLICAT    RUNNING     REPA        00:00:00      00:00:00   

 

结论：修改参数后，目标端复制进程成功开启.