DDLCTXINFO Invalid objects (Doc ID 2659158.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

We have the Golden Gate software on the server but it is currently stopped now. We don't intend to run Golden Gate soon.
However, we have an invalid object in the sys schema that is causing as a result of Golden Gate configuration.

Can you please advise how to resolve this problem.

1* select owner, object_type, object_name from dba_objects where owner = 'SYS' and status <> 'VALID'
XXXX> /

OWNER OBJECT_TYPE OBJECT_NAME
------------------------------ ----------------------- --------------------------------------
SYS PACKAGE BODY DDLCTXINFO

rprm03db> alter package sys.DDLCTXINFO compile body;

Warning: Package Body altered with compilation errors.

XXXX> show errors
Errors for PACKAGE BODY SYS.DDLCTXINFO:

LINE/COL ERROR
-------- -----------------------------------------------------------------
6/9 PL/SQL: Statement ignored
6/9 PLS-00201: identifier 'OGGADMIN.DDLREPLICATION' must be declared
 

Solution

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