重庆思庄Oracle、Redhat认证学习论坛

标题: oracle 12c 配置OGG启动抽取进程时提示OGG-02022 [打印本页]

作者: miss_puff 时间: 2018-1-16 17:04
标题: oracle 12c 配置OGG启动抽取进程时提示OGG-02022
GGSCI (rac01) 68> info all

Program    Status    Group    Lag at Chkpt  Time Since Chkpt

MANAGER    RUNNING
EXTRACT    STOPPED    DPEND    00:00:00    01:35:34
EXTRACT    STOPPED    EXD       00:00:00    01:40:13

查看报错信息
GGSCI (rac01) 69> view report exd
...............
...............
2018-01-16 23:56:06  ERROR OGG-02022  Logmining server does not exist on this Oracle database.

2018-01-16 23:56:06  ERROR OGG-01668  PROCESS ABENDING.

分析：
NTEGRATED模式下如果没有注册数据库，那么在启动extract的时候会报如下错误：（同时extract进程会abend）

解决办法：注册数据库

GGSCI (rac01) 4> dblogin userid c##ogg@racdb password ogg　　　　/*登陆到cdb$root*/
Successfully logged into database CDB$ROOT.
GGSCI (rac01 as c##ogg@racdb1/CDB$ROOT) 5> register extract extd database container(racdb1pdb) /*注册数据库*/

GGSCI (rac01) 14> info all

Program    Status    Group    Lag at Chkpt  Time Since Chkpt

MANAGER    RUNNING
EXTRACT    RUNNING    EXD       00:00:00    00:00:16

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)