Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to apply Oracle patch?

Re: How to apply Oracle patch?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 9 Jan 2003 20:06:37 -0000
Message-ID: <3e1f12d8$1_2@mk-nntp-1.news.uk.worldonline.com>


"Slava Pechenin" <slava_at_pechenin.ru> wrote in message news:1042114303.902721_at_iq...
> Hello.
>
> Preface: It happened that we bought a NT4 Oracle based product. Our vendor
> installed Oracle server software and the product. They also gave us some
CDs
> and of course left us one day with hard-to-use email based support...
>
> Now there is a task of making a stand-by backup server. I installed NT4,
> SP6a, Oracle 8.0.4
> The problem is with Oracle patch 8.0.4.4.0
>
> The instructions with the patch say that the procedure to apply it is the
> following:
> 1) stop Oracle database services
> 2) run patch\setup.exe
> 3) apply server manager sql scripts (catalog.sql, catproc.sql, catexp.sql,
> catrep.sql)
>
> Hmmm, how to do the step N 3?
> Usually SQL scripts are executed under some user account - am I to
configure
> user account before execute the scripts?
>
> Thank you
>

The other posters have answered the how-to. But if in 2003 (or 2002, 2001 come to that) your company bought a product which depends on Oracle 8.0.4. and NT4, I suspect your company was sold a lemon.

Regards,
Paul Received on Thu Jan 09 2003 - 14:06:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US