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 in Patch: 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).


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值