OGG-10468

一、问题OGG-10468

有同事OGG抽取进程遇到这个报错，DB版本11.2.0.4，OGG19.1 ，抽取报错网上搜没啥信息，找到了MOS匹配

OGG-10468 occurred when "ADD SCEMATRANDATA" was executed. (Doc ID 2667288.1)

 

二、问题说明

Oracle GoldenGate - Version 12.1.2.1.0 and later
OGG-10468 occurs when you execute "ADD SCEMATRANDATA" :
GGSCI 1> add schematrandata <SCHEMA>
2020-03-16 15:14:12  INFO    OGG-01788  SCHEMATRANDATA has been added on schema "<SCHEMA>".
2020-03-16 15:14:12  INFO    OGG-01976  SCHEMATRANDATA for scheduling columns has been added on schema "<SCHEMA>".
2020-03-16 15:14:13  ERROR   OGG-10468  Could not find definition for <SCHEMA>.<TABLE>. Error: OCI Err.
The results for activitylogging were as follows. ORA-00942 is confirmed. :
2020-03-16 11:46:39.804 DEBUG|ocicpp.stmt                   |main|  141 ocicpp/OCIStatement.cpp  | bindint stmt - pos 1 type 96 len 15
2020-03-16 11:46:39.804 DEBUG|ocicpp.stmt                   |main|  141 ocicpp/OCIStatement.cpp  | bindint stmt - pos 2 type 96 len 20
2020-03-16 11:46:39.804 DEBUG|ocicpp.stmt                   |main|  188 ocicpp/OCIStatement.cpp  | executing stmt
2020-03-16 11:46:39.804 DEBUG|ocicpp.stmt                   |main|  260 ocicpp/OCIStatement.cpp  | stmt type 1
2020-03-16 11:46:39.854 DEBUG|ocicpp.stmt                   |main|  216 ocicpp/OCIStatement.cpp  | Failed to execute dpi stmt
2020-03-16 11:46:39.854 DEBUG|ocicpp.err                    |main|  114 ocicpp/OCIErrorHandler.c |
 DPI Error ORA - 942 - ORA-00942: table or view does not exist
2020-03-16 11:46:39.854 INFO |gglog.std.application         |main|   70 ggapp/ggPrintLn.c        | [rpt]:
                                                                                                  
2020-03-16 11:46:39  ERROR   OGG-10468  Could not find definition for <SCHEMA>.<TABLE>. Error: OCI Err.
2020-03-16 11:46:39.854 INFO |ggmsg.action                  |main|  235 gglog/msgAction.cpp      |
 OGG-10468: Could not find definition for <SCHEMA>.<TABLE>. Error: OCI Err
CAUSE
Lack of privileges required to configure GoldenGate.
SOLUTION
Grant the GoldenGate administrator user SELECT ANY DICTIONARY privileges.
SQL> grant SELECT ANY DICTIONARY to <GoldenGate Admin User>

 

扩展，OGG需要什么权限呢？  本篇文档不细致讲解，引用老外一个文章简要列举抽取进程需要的权限，与本次报错相关！

https://www.doag.org/formes/servlet/DocNavi?action=getFile&did=9558105&key=
CONFIGURE EXTRACT
SQL> create user ggate identified by ggate default tablespace ggate;
SQL> grant create session, connect, resource, alter any table, alter system to ggate;
SQL> grant select any dictionary to ggate;
SQL> exec dbms_goldengate_auth.grant_admin_privilege('ggate','capture');

permissions depend on database version and type of capture:
DBA permission was needed for classic?
‘grant select any dictionary to ggate’ prevents:
GoldenGate 12.2: ORA-00942 on startup of extract on sys.tab$
GoldenGate 12.3: "OGG-10468 Could not find definition for SCOTT.BONUS. Error: 
OCI Err" 
on add schematrandata scott
dbms_goldengate_auth.grant_admin_privilege('ggate','capture’) - integrated
more privileges needed for DDL support if 11.2.0.3 or earlier