My Oracle Support Banner

DDLCTXINFO Invalid objects (Doc ID 2659158.1)

Last updated on MAY 26, 2020

Applies to:

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

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

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
Goal
Solution
References


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