问题描述:在oracle 10.2.0.4上搭建ogg添加抓取进程时报错OGG-01756、ORA-00942,如下所示:
系统:oel 5.11 64位
ogg软件包:fbo_ggs_Linux_x64_ora10g_64bit.tar
GGSCI (leo-10g-ogg) 10> dblogin userid ogg@ORCL,password ogg
Successfully logged into database.

GGSCI (leo-10g-ogg) 11> add extract exta,tranlog,begin now

2022-12-04 21:04:44 WARNING OGG-01756 Cannot register EXTRACT EXTA 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)
解决方案:
向ogg用户授予以下权限:
exec dbms_streams_auth.grant_admin_privilege('ogg')
grant insert on system.logmnr_restart_ckpt$ to ogg;
grant update on sys.streams$_capture_process to ogg;
grant become user to ogg;
--重建抓取进程
GGSCI (leo-10g-ogg) 5> add extract exta,tranlog,begin now

2022-12-04 21:08:54 INFO OGG-01749 Successfully registered EXTRACT EXTA to start managing log retention at SCN 1050831.
EXTRACT added.

说明:如上所示,抓取进程成功添加.