ORA-22881: dangling REF during upgrade from 9i to 11g

From: Thorsten Jens <thojens_at_gmx.de>
Date: Wed, 12 Aug 2009 06:38:55 -0700 (PDT)
Message-ID: <1c8d9836-e1a2-402c-929f-78093331bce4_at_a26g2000yqn.googlegroups.com>

Hi,

I tried upgrading my 9i database to 11g using DBUA. I did read the manual, even attended the "new features" class. I ran utlu111i.sql before the upgrade.
DBUA stops after 75%, at

desc xdb.xdb$acl;

Name                                      Null?    Type
----------------------------------------- --------
----------------------------

TABLE of XMLTYPE(XMLSchema "http://xmlns.oracle.com/xdb/acl.xsd" Element "acl") STORAGE Object-relational TYPE "XDB$ACL_T"

• Delete dav schema as it depends on ACL schema declare 2 delete_option number := xdb.dbms_xmlschema.delete_cascade_force + 3 xdb.dbms_xmlschema.delete_migrate; 4 davurl varchar2(100) := 'http://xmlns.oracle.com/xdb/dav.xsd'; 5 begin 6 delete_schema_if_exists(davurl, delete_option); 7 end; 8 / declare * ERROR at line 1: ORA-22881: dangling REF ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 106 ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 102 ORA-06512: at "SYS.DELETE_SCHEMA_IF_EXISTS", line 11 ORA-06512: at line 6

I chose to "Ignore" this error, but it only leads to more dangling REFs, finally some "table does not exist"s, and the upgrade stops. I ran into one error before, but that was a "such column list already indexed" in a different part of the update, much earlier on, so I think there's no connection.

Any ideas? I couldn't find anything on Metalink. I would open an SR, but our support status is a little fragile at the moment due to errors in accounting :-/

Solaris 10 SPARC, 64 bit, 9.2.0.8 EE, tried upgrading to both 11.1.0.6 and 11.1.0.7, same error. I asked the same question on http://forums.oracle.com/forums/thread.jspa?threadID=942423 , but did not get any new insight.

Thorsten Received on Wed Aug 12 2009 - 08:38:55 CDT