Re: ORA-22881: dangling REF during upgrade from 9i to 11g
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Wed, 12 Aug 2009 07:39:36 -0700 (PDT)
Message-ID: <cb707af9-690a-4eba-96d1-d7f01c3f9ece_at_s31g2000yqs.googlegroups.com>
On Aug 12, 9:38 am, Thorsten Jens <thoj..._at_gmx.de> wrote:
> 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 onhttp://forums.oracle.com/forums/thread.jspa?threadID=942423, but did
> not get any new insight.
>
> Thorsten
Date: Wed, 12 Aug 2009 07:39:36 -0700 (PDT)
Message-ID: <cb707af9-690a-4eba-96d1-d7f01c3f9ece_at_s31g2000yqs.googlegroups.com>
On Aug 12, 9:38 am, Thorsten Jens <thoj..._at_gmx.de> wrote:
> 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 onhttp://forums.oracle.com/forums/thread.jspa?threadID=942423, but did
> not get any new insight.
>
> Thorsten
Did you verify that you had no INVALID objects prior to attempting the upgrade?
According to Oracle support document #49492.1 the referenced object does not exist.
This may be related to XDB with automatically installs on 11g. If you do not use XDB in your 9.2 database but some or all of the XDB objects are defined try dropping them before upgrading.
Good Luck
-- Mark D Powell --
Received on Wed Aug 12 2009 - 09:39:36 CDT