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 a 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.
Edited by: thodi on Aug 12, 2009 6:27 AM