Re: ORA-22881: dangling REF during upgrade from 9i to 11g
From: Thorsten Jens <thojens_at_gmx.de>
Date: Thu, 13 Aug 2009 00:12:05 -0700 (PDT)
Message-ID: <136b0527-11e5-47b6-8fb2-8e789b48462e_at_32g2000yqj.googlegroups.com>
On Aug 12, 4:39 pm, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> 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?
Date: Thu, 13 Aug 2009 00:12:05 -0700 (PDT)
Message-ID: <136b0527-11e5-47b6-8fb2-8e789b48462e_at_32g2000yqj.googlegroups.com>
On Aug 12, 4:39 pm, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> 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?
There were some invalid objects. One in SYSTEM (UTL_RECOMP, don't know how that ended up in there, the "real" one in SYS was valid), all of the others in application schemas. They've been invalid for some time, though, never caused a problem. All of the objects in the XDB schema are valid.
> 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.
Do you know if there's there a script for that? Or can I drop the entire XDB user?
Thorsten Received on Thu Aug 13 2009 - 02:12:05 CDT