Goldengate OGG-00665 文档 ID 965876.1

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.