ORA-04043 object DROP_AW_ELIST_ALL does not exist

ORA-02303 & ORA-00955 Errors on SYSTEM.LOGMNR$ Types During PSU Updates (Doc ID 2008146.1)

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Oracle GoldenGate - Version 11.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

ORA-02303 "cannot drop or replace a type with type or table dependents" and ORA-00955 "name is already used by an existing object" errors can be seen on the following statements when upgrading an Oracle RDBMS to 11.2.0.4, e.g.

ORA-02303 "cannot drop or replace a type with type or table dependents"
create or replace type SYSTEM.LOGMNR$TAB_GG_REC wrapped
create or replace type SYSTEM.LOGMNR$COL_GG_REC wrapped
create or replace type SYSTEM.LOGMNR$SEQ_GG_REC wrapped
create or replace type SYSTEM.LOGMNR$KEY_GG_REC wrapped

ORA-00955 "name is already used by an existing object"
CREATE TYPE SYSTEM.LOGMNR$TAB_GG_RECS AS TABLE OF SYSTEM.LOGMNR$TAB_GG_REC;
CREATE TYPE SYSTEM.LOGMNR$COL_GG_RECS AS TABLE OF SYSTEM.LOGMNR$COL_GG_REC;
CREATE TYPE SYSTEM.LOGMNR$SEQ_GG_RECS AS TABLE OF SYSTEM.LOGMNR$SEQ_GG_REC;
CREATE TYPE SYSTEM.LOGMNR$KEY_GG_RECS AS TABLE OF SYSTEM.LOGMNR$KEY_GG_REC;

Changes

Database is being upgraded or a bundle patch is being applied.
The same could also manifest if you are for instance upgrading to 11.2.0.4 using dbua with a home that has a PSU applied.

Cause

This is due to unpublished Bug 17030189 fixed in 12.2.
 

Solution

The errors are safe to ignore as the problem types are specific to the use of Oracle Goldengate (OGG),and so do not impact the normal use of LogMiner. If OGG is being used, then the fix for this issue is included inPatch: 22457613 and Patch:22576728 (for newer patches see Document 1557031.1). A generic one-off patch is currently available for 11.2.0.4.0 with no OGG bundle patch, and a merge patch has been requested with the OGG bundle patch #3 (which will be available via Patch:21131412 when complete).