您的当前位置:首页正文

oracle 12c 配置OGG启动抽取进程时

来源:图艺博知识网

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.

分析:

解决办法:注册数据库

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

Top