问题描述：ogg在源端insert数据后，抽取进程出现OGG-00664、OGG-02078、OGG-02171异常，如下所示：
架构说明：此为oracle pdb到mysql的ogg同步.
1、异常重现
--进程原状态
GGSCI (leo-oracle-19c) 16> info all 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXTORCL     00:00:00      00:00:01    
EXTRACT     RUNNING     PUMYSQL     00:00:00      00:00:08    

--源端insert数据
sys@ORCLCDB> conn test_ogg/test_ogg@orclpdb
Connected.

test_ogg@ORCLPDB> insert into info_tab values (1,'alina');

1 row created.

test_ogg@ORCLPDB> commit;

Commit complete.

--确认进程状态
GGSCI (leo-oracle-19c) 17> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     ABENDED     EXTORCL     00:00:00      00:00:44    
EXTRACT     RUNNING     PUMYSQL     00:00:00      00:00:01  

--告警日志
2024-07-17 08:43:57  ERROR   OGG-00664  OCI Error ORA (status = 1031-ORA-01031: insufficient privileges
).

Source Context :
  SourceModule            : [er.redo.oraxo]
  SourceID                : [er/redo/oracle/redooraix.c]
  SourceMethod            : [xoutReadLCR]
  SourceLine              : [16295]
  
  
2024-07-17 08:43:57  ERROR   OGG-02078  Extract encountered a fatal error in a processing thread and is abending.

Source Context :
  SourceModule            : [er.extract.processloop]
  SourceID                : [er/extract/processloop.cpp]
  SourceMethod            : [processExtractLoop]
  SourceLine              : [468]
  

2024-07-17 08:43:57  ERROR   OGG-02171  Error reading LCR from data source. Status 510, data source type TranLogDataSource.

2、异常定位
根据Mos[Doc ID 2899818.1]文档可知ogg用户的权限不足导致.

3、解决方案
--授予ogg用户权限
sys@ORCLCDB> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB                        READ WRITE NO
sys@ORCLCDB> grant set container to c##ogg container=all;

Grant succeeded.

4、验证
--源端再次开启抽取进程
GGSCI (leo-oracle-19c) 21> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     ABENDED     EXTORCL     00:00:00      01:29:01    
EXTRACT     RUNNING     PUMYSQL     00:00:00      00:00:05    


GGSCI (leo-oracle-19c) 22> start extorcl

Sending START request to Manager ...
Extract group EXTORCL starting.


GGSCI (leo-oracle-19c) 23> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXTORCL     00:00:00      01:29:10    
EXTRACT     RUNNING     PUMYSQL     00:00:00      00:00:04    

--源端insert数据
sys@ORCLCDB> conn test_ogg/test_ogg@orclpdb
Connected.
test_ogg@ORCLPDB> delete from info_tab;

1 row deleted.

test_ogg@ORCLPDB> commit;

Commit complete.

test_ogg@ORCLPDB> insert into info_tab values (1,'alina');

1 row created.

test_ogg@ORCLPDB> commit;

Commit complete.

--源端再次确认抽取进程状态
GGSCI (leo-oracle-19c) 34> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXTORCL     00:00:00      00:00:04    
EXTRACT     RUNNING     PUMYSQL     00:00:00      00:00:09    


GGSCI (leo-oracle-19c) 35> stats pumysql

Sending STATS request to Extract group PUMYSQL ...

Start of statistics at 2024-07-17 10:29:09.

DDL replication statistics (for all trails):

*** Total statistics since extract started     ***
        Operations                                         1.00

Output to /opt/ogg/target_endpoint/dirdat/rt:

Extracting from ORCLPDB.TEST_OGG.INFO_TAB to ORCLPDB.TEST_OGG.INFO_TAB:

*** Total statistics since 2024-07-17 10:13:09 ***
    Total inserts                              5.00
    Total updates                              0.00
    Total deletes                              4.00
    Total upserts                              0.00
    Total discards                             0.00
    Total operations                           9.00

*** Daily statistics since 2024-07-17 10:13:09 ***
    Total inserts                              5.00
    Total updates                              0.00
    Total deletes                              4.00
    Total upserts                              0.00
    Total discards                             0.00
    Total operations                           9.00

*** Hourly statistics since 2024-07-17 10:13:09 ***
    Total inserts                              5.00
    Total updates                              0.00
    Total deletes                              4.00
    Total upserts                              0.00
    Total discards                             0.00
    Total operations                           9.00

*** Latest statistics since 2024-07-17 10:13:09 ***
    Total inserts                              5.00
    Total updates                              0.00
    Total deletes                              4.00
    Total upserts                              0.00
    Total discards                             0.00
    Total operations                           9.00

End of statistics.

说明：如上所示源端执行insert后，抽取进程不在发生异常.

5、源端抽取进程配置文件
GGSCI (leo-oracle-19c) 45> view param extorcl

extract extorcl
 
DDL INCLUDE ALL
 
SETENV (ORACLE_HOME=/u01/app/oracle/product/19.3.0/db)
SETENV (ORACLE_SID=orclcdb)
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
userid c##ogg@orclcdb, password ogg123
exttrail /opt/ogg/source_endpoint/dirdat/to
table ORCLPDB.test_ogg.*;