Oracle-L: 9.2.0.4 patch on linux

From: <Jared.Still_at_radisys.com>
Date: Mon, 06 Oct 2003 12:39:25 -0800
Message-ID: <F001.005D22F3.20031006123925@fatcity.com>

List,

I ran into some difficulties today while applying the 9.2.0.4 patch to a 9.2.0.1 db on RH 8.0, and was curious if anyone else had seen similar problems.

After installing the 9.2.0.4 sw ( after installing the 2.2.0.18 OUI of course ) , I
started the database via 'startup migrate' and then ran catpatch.sql.

An ORA-3113 would consistently occur when the following statement was reached in the catmetx.sql script:

create or replace force view sys.ku$_xmlschema_view of sys.ku$_xmlschema_t with object identifier (owner_name, url) as select '1','0',

        u.user#, u.name, extractvalue(VALUE(s), '/schema/@schemaURL'),
        s.sys_nc_oid$,
           case when under_path(value(r), '/sys/schemas/PUBLIC') = 1
                then 0 else 1 end,
   s.getclobval(),                    -- unstripped
   xdb.dbms_xdbutil_int.XMLSchemaStripUsername(XMLTYPE(s.getClobVal()),
                                                    u.name)         --

stripped

from sys.user$ u, xdb.xdb$schema s, xdb.xdb$resource r where extractvalue(VALUE(r), '/Resource/XMLRef') = ref(s) and u.user# =
sys_op_rawtonum(extractvalue(VALUE(r),'/Resource/OwnerID'))

        AND (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (u.user#, 0) OR
                EXISTS ( SELECT * FROM session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

Running this statement from the command line netted the same results.

Querying the dba_registry view didn't reveal anything unusual: XML stuff was in
the 'LOADED' or 'LOADING' state.

Poking around MetaLink a bit revealed the others had at times had different trouble
with XDB, and had resolved them by recreating the XDB schema.

After running catnoqm.sql ( drops the XDB user ), catpatch.sql was again ran, and
everything finished to completion. ( catpatch calls catproc, which eventually calls
catqm.sql, which recreates XDB if needed )

Have any of you experienced similar problems with XDB while patching or upgrading?

Jared

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Oct 06 2003 - 15:39:25 CDT