Re: ORA-22881: dangling REF during upgrade from 9i to 11g
From: Thorsten Jens <thojens_at_gmx.de>
Date: Fri, 14 Aug 2009 01:36:01 -0700 (PDT)
Message-ID: <1d1d45b6-22e9-4346-866a-644cb8047994_at_s15g2000yqs.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?
>
> 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.
Date: Fri, 14 Aug 2009 01:36:01 -0700 (PDT)
Message-ID: <1d1d45b6-22e9-4346-866a-644cb8047994_at_s15g2000yqs.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?
>
> 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.
Well, after running ?/rdbms/admin/catnoqm.sql, the installation succeded. Thank you!
Thorsten Received on Fri Aug 14 2009 - 03:36:01 CDT