标签：10.2 01756 00942 SQL OGG EXTRACT ogg ORA
问题描述：在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.
说明：如上所示，抓取进程成功添加.
标签：10.2,
01756,
00942,
SQL,
OGG,
EXTRACT,
ogg,
ORA
From： https://blog.51cto.com/u_12991611/5927810