My Oracle Support Banner

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

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.