Duplicate Objects After Upgrade (Doc ID 418442.1)

Last updated on AUGUST 05, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.3 [Release 10.1 to 10.2]
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

User performed a DBUA assisted upgrade two times(reason is not relevant for the issue), and in the second one, received many 'alter type' errors like the following:

alter type dbms_xplan_type modify attribute (plan_table_output varchar2(300)) cascade;
alter type dbms_xplan_type modify attribute (plan_table_output varchar2(300)) cascade
*
ERROR at line 1:
ORA-22324: altered type has compilation errors
ORA-22328: object "SYS"."DBMS_XPLAN_TYPE" has errors.
PLS-00719: only widening of attribute 'PLAN_TABLE_OUTPUT' constraints is allowed
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated

User then tried to find more info about the types and found that there were several 'duplicate' type entries. Here is the list:

OWN OBJECT_NAME OBJ_TYPE STATUS OBJECT_ID SUBOBJECT_NAME
--- ---------------------- ---------- ------ --------- --------------
SYS AQ$_DESCRIPTOR TYPE VALID 188189
SYS AQ$_DESCRIPTOR TYPE VALID 188181 $VSN_2
SYS AQ$_DESCRIPTOR TYPE VALID 3718 $VSN_1

SYS AQ$_EVENT_MESSAGE TYPE VALID 188186
SYS AQ$_EVENT_MESSAGE TYPE VALID 3723 $VSN_1

SYS AQ$_REG_INFO TYPE VALID 188184
SYS AQ$_REG_INFO TYPE VALID 188051 $VSN_2
SYS AQ$_REG_INFO TYPE VALID 3719 $VSN_1
SYS AQ$_REG_INFO TYPE BODY VALID 189157

SYS AQ$_SRVNTFN_MESSAGE TYPE VALID 188187
SYS AQ$_SRVNTFN_MESSAGE TYPE VALID 188182 $VSN_3
SYS AQ$_SRVNTFN_MESSAGE TYPE VALID 188053 $VSN_2
SYS AQ$_SRVNTFN_MESSAGE TYPE VALID 3724 $VSN_1

SYS DBMS_XPLAN_TYPE TYPE VALID 188200
SYS DBMS_XPLAN_TYPE TYPE VALID 151319 $VSN_1

SYS LCR$_DDL_RECORD TYPE VALID 5865
SYS LCR$_DDL_RECORD TYPE BODY VALID 5902

SYS LCR$_ROW_RECORD TYPE VALID 5863
SYS LCR$_ROW_RECORD TYPE BODY VALID 5901

SYS LCR$_ROW_UNIT TYPE VALID 188085
SYS LCR$_ROW_UNIT TYPE VALID 5861 $VSN_1
SYS LCR$_ROW_UNIT TYPE BODY VALID 190930

SYS MSG_PROP_T TYPE VALID 188180
SYS MSG_PROP_T TYPE VALID 3717 $VSN_1

SYS WRI$_ADV_ABSTRACT_T TYPE VALID 188742
SYS WRI$_ADV_ABSTRACT_T TYPE BODY VALID 191308

SYS WRI$_ADV_SQLACCESS_ADV TYPE VALID 188814
SYS WRI$_ADV_SQLACCESS_ADV TYPE BODY VALID 191303

SYS WRI$_ADV_TUNEMVIEW_ADV TYPE VALID 188815
SYS WRI$_ADV_TUNEMVIEW_ADV TYPE BODY VALID 191304

SYS XMLGENFORMATTYPE TYPE VALID 188083
SYS XMLGENFORMATTYPE TYPE VALID 4483 $VSN_1
SYS XMLGENFORMATTYPE TYPE BODY VALID 4494


User is worried about this duplicate entries.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms