OGG-01756 创建抽取进程有警告 文档 ID 1330577.1

环境：Windows x64 2003  数据库：10.2.0.4   OGG版本：11.1.1.1.0


添加抽取进程时报以下错误：

GGSCI (abe5d10991f24ec) 14> add extract ehighgo,tranlog,begin now2017-10-01 17:15:22  WARNING OGG-01756  Cannot register EXTRACT EHIGHGO with database because of the following SQL error: OCI Error ORA-06550: line 1, column 3128:PL/SQL: ORA-00942: table or view does not existORA-06550: line 1, column 3117:PL/SQL: SQL Statement ignored (status = 0). See Extract user privileges in the Oracle GoldenGate for Oracle Installation and Setup Guide. You can manually register this group with the REGISTER EXTRACT command.EXTRACT added.

MOS： Adding an Extract Fails with OGG-01756 Cannot Register EXTRACT (文档 ID 1330577.1)

授予goldengate以下权限后重建抽取进程

exec dbms_streams_auth.grant_admin_privilege('goldengate');grant insert on system.logmnr_restart_ckpt$ to goldengate;grant update on sys.streams$_capture_process to goldengate;grant become user to goldengate;

GGSCI (abe5d10991f24ec) 15> delete extract ehighgoDeleted EXTRACT EHIGHGO.GGSCI (abe5d10991f24ec) 16> add extract ehighgo,tranlog,begin now2017-10-01 17:27:28  INFO    OGG-01749  Successfully registered EXTRACT EHIGHGO to start managing log retention at SCN 827630.EXTRACT added.