标签：00 enable 02091 replication 报错 OGG goldengate ogg 19c
问题描述：搭建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
结论：修改参数后，目标端复制进程成功开启.
标签：00,
enable,
02091,
replication,
报错,
OGG,
goldengate,
ogg,
19c
From： https://blog.51cto.com/u_12991611/5904071