问题描述:搭建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
结论:修改参数后,目标端复制进程成功开启.