在oracle 10.2.0.4上搭建ogg添加抓取进程时报错OGG-01756、ORA-00942

问题描述：在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.

 

说明：如上所示，抓取进程成功添加.