Dblogin Failed With Error ORA-04045: errors during recompilation/revalidation of SYS.DBMS_LOGREP_UTIL (Doc ID 2938531.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Got below error in Goldengate

GGSCI> dblogin userid <Goldengate username>.....

WARNING OGG-25108  Failed to set the Oracle session tag: ORA-04045: errors during recompilation/revalidation of SYS.DBMS_LOGREP_UTIL

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 GGADMIN.DDLREPLICATION  <===

ORA-04067: not executed, package body "GGADMIN.DDLREPLICATION" does not exist

ORA-06508: PL/SQL: could not find program unit being called: "GGADMIN.DDLREPLICATION"

ORA-06512: at line 1336

----------------------------- 

Checked  and found that package body "GGADMIN.DDLREPLICATION" is invalid
- Tried to compile package body "GGADMIN.DDLREPLICATION" but it didn't work
- Tried to restore  an Existing DDL Environment to a Clean State but ddl_setup script gave errors
---> 2810/40    PLS-00201: identifier 'DBMS_SQL' must be declared

Cause

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