环境:Windows x64 2003 数据库:10.2.0.4 OGG版本:11.1.1.1.0
添加抽取进程时报以下错误:
GGSCI (abe5d10991f24ec) 14> add extract ehighgo,tranlog,begin now
2017-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 exist
ORA-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 ehighgo
Deleted EXTRACT EHIGHGO.
GGSCI (abe5d10991f24ec) 16> add extract ehighgo,tranlog,begin now
2017-10-01 17:27:28 INFO OGG-01749 Successfully registered EXTRACT EHIGHGO to start managing log retention at SCN 827630.
EXTRACT added.