搭建ogg时无法启动目标端复制进程,告警日志报错OGG-02091

时间:2022-12-01 19:57:34
问题描述:搭建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

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