DBMS_GOLDENGATE_ADM.ADD_AUTO_CDR...ORA-04045: errors during recompilation/revalidation of SYS.DBMS_GOLDENGATE_ADM (Doc ID 2660327.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

While trying to setup AUTO_CDR for first time user was encountering below error:

SQL> BEGIN
  DBMS_GOLDENGATE_ADM.ADD_AUTO_CDR(
  schema_name => '<SCHEMA>',
  table_name => '<TABLE>',
  record_conflicts => TRUE);
END;
/ 2 3 4 5 6 7
BEGIN
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_GOLDENGATE_ADM
ORA-04088: error during execution of trigger 'SYS.GGS_DDL_TRIGGER_BEFORE'
ORA-00604: error occurred at recursive SQL level 2
ORA-04045: errors during recompilation/revalidation of GGMON.DDLREPLICATION
ORA-04067: not executed, package body "GGMON.DDLREPLICATION" does not exist
ORA-06508: PL/SQL: could not find program unit being called:
"GGMON.DDLREPLICATION"

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.