问题描述:搭建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
结论:修改参数后,目标端复制进程成功开启.
搭建ogg时无法启动目标端复制进程,告警日志报错OGG-02091
原创
©著作权归作者所有:来自51CTO博客作者Liujun_Deng的原创作品,请联系作者获取转载授权,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
ogg之创建隔离多通道复制
ogg篇
oracle SQL Group -
Oracle11g之OGG单instance单向复制
ogg
oracle 初始化 ide -
OGG搭建完成后,源端insert数据导致目标端复制进程报错OGG-00768、OGG-00769
OGG搭建完成后,源端insert数据导致目标端复制进程报错OGG-00768、OGG-00769
mysql OGG-00768 OGG-00769 -
OGG复制进程报错OGG-01172
OGG复制进程报错OGG-01172
OGG-01172 -
ogg源端投递进程告警OGG-01496、OGG-01668
ogg源端投递进程告警OGG-01496、OGG-01668
OGG-01496 OGG-01668 -
ogg在启动应用进程时报错OGG-00412
ogg在启动应用进程时报错OGG-00412
Group bc 数据库oracle -
ogg目标库应用进程异常,告警OGG-00519、ORA-02443
ogg目标库应用进程异常,告警OGG-00519、ORA-02443
应用进程 OGG-00519 ORA-02443 -
ogg复制进程出现异常报警OGG-03533
ogg复制进程出现异常报警OGG-03533
oracle OGG-03533 -
开启ogg投递进程时报错OGG-01224
开启ogg投递进程时报错OGG-01224
mysql OGG-01224 ogg -
OGG复制进程延迟不断增长
1.注意通过进程查找sql_id时,进程号要查询两次 2
javascript oracle 杀进程 参考资料 主键 -
python word筛选字体大小
11.5 jQuery引入方式: 方式一:本地引入 <script src="jquery-3.3.1.min.js"></script> <script> //注意,一定在引入jQuery之后,再使用jQuery提供的各种操作 code... </script> 方式二:直接使用CDN <script src="ht
python word筛选字体大小 javascript 前端 python ViewUI