Issue :
The extract of the goldengate failed with the error : Error “OGG-00665 OCI Error executing fetch for TABLE (status = 1031-ORA-01031: insufficient privileges)”
Observation :
Goldengate Extract abends with below error:
ERROR OGG-00665 OCI Error executing fetch for schemaname.tablename (status = 1031-ORA-01031: insufficient privilege)
Reason :
The extract process is throwing this error because the OGG user lacks some privileges.
Fix :
The below privileges need to be granted to the OGG user ID:
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;
After the execution of the above commands, the extract process has to be restarted.
