11.1.0.6.0->11.2.0.1.0 UPGRADE FAILS WITH ORA-22371 REFERENCING XDB.XDB$PROPERTY_T, VERSION 1 (Doc ID 1070951.1)

Last updated on FEBRUARY 21, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Feb-2013***

Symptoms

While upgrading from 11.1.0.6.0 to 11.1.0.7 or 11.2.0.1.0 both via the Database Upgrade Assistant (DBUA) and manually, there are a lot of ORA- errors including:

...

CREATE OR REPLACE PACKAGE BODY xdb.DBMS_ResConfig wrapped
2 a000000
3 1
4 abcd
5 abcd
...
38 py0xLfDpvpwtsZF3zYgQScgPMfYXsA1MOgnE4OKM6af2eDFR6j7YnEVADjzf3T5xRlAH7zIo
39 lhi57nj2HJeQauJh7lBBOJjqfJojYXg76JjUM2DJp+C+A7G5gRAi1XOemr9hlkD4pNX4DqXt
40 4n3G1+Mmth/3KM/SsRemrCGs
41
42 /

Warning: Package Body created with compilation errors.

show errors;
Errors for PACKAGE BODY XDB.DBMS_RESCONFIG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
67/8 PL/SQL: SQL Statement ignored
69/26 PL/SQL: ORA-22371: Table contains data of type
XDB.XDB$PROPERTY_T, version 1, which does not exist

179/8 PL/SQL: SQL Statement ignored
181/26 PL/SQL: ORA-22371: Table contains data of type
XDB.XDB$PROPERTY_T, version 1, which does not exist

...


and in the end, the Oracle Multimedia component is INVALID.

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