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.