While using delete cascade on the database, the replicat needs below parameter set in the prm file
DBOPTIONS DEFERREFCONST
After setting this, the replicat was getting abended with the below error
2015-10-30 09:21:34 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rapi8602.prm: OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). DELETE /*+ RESTRICT_ALL_REF_CONS */ FROM "user5"."transactions" WHERE "ID" = :b0.
2015-10-30 09:21:34 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, rapi8602.prm: Aborted grouped transaction on 'user5.transactions', Database error 26945 (OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). DELETE /*+ RESTRICT_ALL_REF_CONS */ FROM "user5"."transactions" WHERE "ID" = :b0).
2015-10-30 09:21:34 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rapi8602.prm: Repositioning to rba 1679 in seqno 8.
2015-10-30 09:21:34 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rapi8602.prm: SQL error 26945 mapping user5.transactions to user5.transactions OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). DELETE /*+ RESTRICT_ALL_REF_CONS */ FROM "user5"."transactions" WHERE "ID" = :b0.
Solution :
exec dbms_goldengate_auth.grant_admin_privilege('<GGSUSER>');
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE = BOTH;
DBOPTIONS DEFERREFCONST
After setting this, the replicat was getting abended with the below error
2015-10-30 09:21:34 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rapi8602.prm: OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). DELETE /*+ RESTRICT_ALL_REF_CONS */ FROM "user5"."transactions" WHERE "ID" = :b0.
2015-10-30 09:21:34 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, rapi8602.prm: Aborted grouped transaction on 'user5.transactions', Database error 26945 (OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). DELETE /*+ RESTRICT_ALL_REF_CONS */ FROM "user5"."transactions" WHERE "ID" = :b0).
2015-10-30 09:21:34 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rapi8602.prm: Repositioning to rba 1679 in seqno 8.
2015-10-30 09:21:34 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rapi8602.prm: SQL error 26945 mapping user5.transactions to user5.transactions OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). DELETE /*+ RESTRICT_ALL_REF_CONS */ FROM "user5"."transactions" WHERE "ID" = :b0.
Solution :
exec dbms_goldengate_auth.grant_admin_privilege('<GGSUSER>');
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE = BOTH;
Thank you. This was just the fix I needed.
ReplyDelete