Re: How to apply Oracle patch?

Paul Brewer wrote:

> "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

And a mouldy one at that.

Dan Morgan Received on Fri Jan 10 2003 - 16:09:05 CST