一、问题OGG-10468
有同事OGG抽取进程遇到这个报错,DB版本11.2.0.4,OGG19.1 ,抽取报错网上搜没啥信息,找到了MOS匹配
|
二、问题说明
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