Goldengate OGG-00665 文档 ID 965876.1

最新推荐文章于 2022-01-27 23:28:25 发布

最新推荐文章于 2022-01-27 23:28:25 发布 · 686 阅读

OGG 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了解决GoldenGate Extract进程因权限不足导致失败的问题。通过授予特定权限给OGG用户，如CONNECT、RESOURCE等，可以恢复正常的数据抽取流程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Goldengate Extract Is Failing With Error "OGG-00665 OCI Error executing fetch for TABLE (status = 1031-ORA-01031: insufficient privileges)" (文档 ID 2304057.1)

Oracle GoldenGate - Version 11.2.0.0.0 and later
Information in this document applies to any platform.

Goldengate Extract abends with below error:

Source Context :
SourceModule : [ggdb.ora.sess]
SourceID : [/scratch/aime1/adestore/views/aime1_staoi06/oggcore/OpenSys/src/gglib/ggdbora/ocisess.c]
SourceFunction : [oci_try]
SourceLine : [643]

2017-08-14 17:05:04 ERROR OGG-00665 OCI Error executing fetch for TBAADM.LA_ACCT_MAST_TABLE (status = 1031-ORA-01031: insufficient privileges), SQL<SELECT x."ACID",
x."BANK_ID" FROM "TBAADM"."LA_ACCT_MAST_TABLE" AS OF SCN :scn x WHERE ROWID = :rid>.

原因：

OGG的用户缺少一些权限。

请登录数据库并授予OGG用户以下权限：

GRANT CONNECT,RESOURCE,DBA TO ogguser;
ALTER USER ogguser QUOTA UNLIMITED ON <Tablespace_name>;
exec dbms_streams_auth.grant_admin_privilege('ogguser');
EXEC dbms_goldengate_auth.grant_admin_privilege('ogguser');
grant execute on utl_file to ogguser;
grant select any transaction to ogguser;
grant flashback any table to ogguser;

Then try to restart the extract.