My Oracle Support Banner

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

Last updated on MAY 26, 2020

Applies to:

Oracle GoldenGate - Version 19.1.0.0.4 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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