ORA-22881: dangling REF during upgrade from 9i to 11g
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