DBMS_GOLDENGATE_ADM.ADD_AUTO_CDR...ORA-04045: errors during recompilation/revalidation of SYS.DBMS_GOLDENGATE_ADM
(Doc ID 2660327.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 19.1.0.0.4 and laterOracle Database - Enterprise Edition - Version 19.15.0.0.0 to 19.15.0.0.0 [Release 19]
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 |