Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h97M6GR02178 for ; Tue, 7 Oct 2003 17:06:16 -0500 X-ClientAddr: 66.27.56.213 Received: from www2.fatcity.com (rrcs-west-66-27-56-213.biz.rr.com [66.27.56.213]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h97M6Fc02173 for ; Tue, 7 Oct 2003 17:06:15 -0500 Received: (from root@localhost) by www2.fatcity.com (8.11.6/8.11.6) id h97JNhZ15645 for oracle-l@orafaq.net; Tue, 7 Oct 2003 12:23:43 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D24B3; Tue, 07 Oct 2003 12:19:24 -0800 Message-ID: Date: Tue, 07 Oct 2003 12:19:24 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Jared.Still@radisys.com Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Jared.Still@radisys.com Subject: Re: AW: 9.2.0.4 patch on linux Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=_alternative 006A0D9788256DB8_=" --=_alternative 006A0D9788256DB8_= Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Now that you mention it, I may have forgotten to drop XMLCONCAT first. The pool sizes were fine. I'll try the next upgrade (that I can spend extra time on) without=20 dropping xmlconcat and see what happens. Thanks, Jared Stefan Jahnke Sent by: ml-errors@fatcity.com 10/07/2003 01:59 AM Please respond to ORACLE-L =20 To: Multiple recipients of list ORACLE-L cc:=20 Subject: AW: 9.2.0.4 patch on linux Hi Jared =20 Did you extend your pool sizes ? =20 Users who have JVM (Java enabled) or JVM and XDB installed on their=20 Oracle9i release 2 databases should ensure the init.ora parameters SHARED= =5FPOOL=5FSIZE and JAVA=5FPOOL=5FSIZE are each 150 MB or more before runnin= g the catpatch.sql upgrade script.=20 =20 Did you drop XMLCONCAT before patching ? =20 Drop the xmlconcat function by running the following commands:=20 C:\> sqlplus / NOLOG SQL> connect / AS SYSDBA SQL> drop public synonym XMLCONCAT; SQL> drop function XMLCONCAT; Regards, Stefan -----Urspr=FCngliche Nachricht----- Von: Jared.Still@radisys.com [mailto:Jared.Still@radisys.com] Gesendet: Montag, 6. Oktober 2003 22:39 An: Multiple recipients of list ORACLE-L Betreff: 9.2.0.4 patch on linux List,=20 I ran into some difficulties today while applying the 9.2.0.4 patch to a=20 9.2.0.1 db on RH 8.0, and was curious if anyone else had seen=20 similar problems.=20 After installing the 9.2.0.4 sw ( after installing the 2.2.0.18 OUI of=20 course ) , I=20 started the database via 'startup migrate' and then ran catpatch.sql.=20 An ORA-3113 would consistently occur when the following statement was=20 reached in the catmetx.sql script:=20 create or replace force view sys.ku$=5Fxmlschema=5Fview of sys.ku$=5Fxmlsch= ema=5Ft=20 with object identifier (owner=5Fname, url) as=20 select '1','0',=20 u.user#, u.name, extractvalue(VALUE(s), '/schema/@schemaURL'),=20 s.sys=5Fnc=5Foid$,=20 case when under=5Fpath(value(r), '/sys/schemas/PUBLIC') =3D 1=20 then 0 else 1 end,=20 s.getclobval(), -- unstripped=20 xdb.dbms=5Fxdbutil=5Fint.XMLSchemaStripUsername(XMLTYPE(s.getClobVal()),= =20 u.name) --=20 stripped=20 from sys.user$ u, xdb.xdb$schema s, xdb.xdb$resource r=20 where extractvalue(VALUE(r), '/Resource/XMLRef') =3D ref(s)=20 and u.user# =3D=20 sys=5Fop=5Frawtonum(extractvalue(VALUE(r),'/Resource/OwnerID'))=20 AND (SYS=5FCONTEXT('USERENV','CURRENT=5FUSERID') IN (u.user#, 0) OR= =20 EXISTS ( SELECT * FROM session=5Froles=20 WHERE role=3D'SELECT=5FCATALOG=5FROLE' ))=20 Running this statement from the command line netted the same results.=20 Querying the dba=5Fregistry view didn't reveal anything unusual: XML stuff= =20 was in=20 the 'LOADED' or 'LOADING' state.=20 Poking around MetaLink a bit revealed the others had at times had=20 different trouble=20 with XDB, and had resolved them by recreating the XDB schema.=20 After running catnoqm.sql ( drops the XDB user ), catpatch.sql was again=20 ran, and=20 everything finished to completion. ( catpatch calls catproc, which=20 eventually calls=20 catqm.sql, which recreates XDB if needed )=20 Have any of you experienced similar problems with XDB while patching or=20 upgrading?=20 Jared=20 --=_alternative 006A0D9788256DB8_= Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Now that you mention it, I may have = forgotten to drop XMLCONCAT first.

The pool sizes were fine.

I'll try the next upgrade (that I ca= n spend extra time on) without dropping xmlconcat
and see what happens.

Thanks,

Jared



Stefan Jahnke <Stefan.Jahnke@b= ov.de>
Sent by: ml-errors@fatcity.com

 10/07/2003 01:59 AM
 Please respond to ORACLE-L

       
        To: &nbs= p;      Multiple recipients of list ORACLE-L <ORACLE-L@fa= tcity.com>
        cc: &nbs= p;      
        Subject:=        AW: 9.2.0.4 patch on linux



Hi Jared
 
Did you extend your pool siz= es ?
 
Users who have JVM (Java enable= d) or JVM and XDB installed on their Oracle9i release 2 databases sh= ould ensure the init.ora<= font size=3D3 face=3D"Times New Roman"> parameters SHARED=5FPOOL=5FSIZE and JAVA=5FPOOL=5FSI= ZE are each 150 MB or more b= efore running the catpatch.sql upgrade script.
 
Did you drop XMLCONCAT befor= e patching ?
 

Drop the xmlconcat function by running the following commands:

C:\> sqlplus / NOLOG

SQL> connect / AS SYSDBA

SQL> drop public synonym XMLCONCA= T;

SQL> drop function XMLCONCAT;

Regards, Stefan

-----Urspr=FCngliche Nachricht-----
Von: Jared.Still@radisys.com [mailto:Jared.Still@radisys.com]
Gesendet: Montag, 6. Oktober 2003 22:39
An: Multiple recipients of list ORACLE-L
Betreff: 9.2.0.4 patch on linux

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 cour= se ) , 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$=5Fxmlschema=5Fview of sys.ku$=5Fxmlsch= ema=5Ft
 with object identifier (owner=5Fname, url) as
 select '1','0',
       u.user#, u.name, extractvalue(VALUE(s), '/schem= a/@schemaURL'),
       s.sys=5Fnc=5Foid$,
          case when under=5Fpath(value(r), '/sys/= schemas/PUBLIC') =3D 1
               then 0 else 1 end,<= /font>
  s.getclobval(),               &n= bsp;    -- unstripped
  xdb.dbms=5Fxdbutil=5Fint.XMLSchemaStripUsername(XMLTYPE(s.getClobVa= l()),
          &= nbsp;                    =                     u.na= me)         -- stripped
   from sys.user$ u, xdb.xdb$schema s, xdb.xdb$resource r=
   where extractvalue(VALUE(r), '/Resource/XMLRef') =3D ref(s)
   and u.user# =3D sys=5Fop=5Frawtonum(extractvalue(VALUE(r),'/R= esource/OwnerID'))
       AND (SYS=5FCONTEXT('USERENV','CURRENT=5FUSERID'= ) IN (u.user#, 0) OR =
               EXISTS ( SELECT * F= ROM session=5Froles <= font size=3D2 face=3D"sans-serif">
                    &nbs= p;  WHERE role=3D'SELECT=5FCATALOG=5FROLE' ))


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

Querying the dba=5Fregistry 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 ra= n, and
everything finished to completion.  ( catpatch calls catproc, which ev= entually calls
catqm.sql, which recreates XDB if needed )

Have any of you experienced similar problems with XDB while patching or upg= rading?

Jared



--=_alternative 006A0D9788256DB8_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Jared.Still@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@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).