Erman Arslan's Oracle Forum - Re: WARNING OGG-02544 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 237, RBA 266900102 in Integrated mode. REPLICAT will retry in Direct mode.

Re: WARNING OGG-02544 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 237, RBA 266900102 in Integrated mode. REPLICAT will retry in Direct mode.

Posted by ErmanArslansOracleBlog on Sep 27, 2019; 8:21am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/WARNING-OGG-02544-Oracle-GoldenGate-Delivery-for-Oracle-reploggt-prm-Unhandled-error-ORA-01031-insuf-tp7707p7710.html

*Ensure the permissions as I already mention. There ar permissions required for capture also.

exec dbms_goldengate_auth.grant_admin_privilege('OGG_USER'); --> for both
exec dbms_goldengate_auth.grant_admin_privilege('OGG_USER','capture');
exec dbms_goldengate_auth.grant_admin_privilege('OGG_USER','apply');

*You should also ensure that OS-level permissions are properly set for the directory that trail files, checkpoint and report-related files reside.

*Also ensure that there is nothing like DB vault-type blocker present in the environment.