How to apply Oracle patch?

From: Slava Pechenin <slava_at_pechenin.ru>
Date: Thu, 9 Jan 2003 14:11:39 +0200
Message-ID: <1042114303.902721@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 Received on Thu Jan 09 2003 - 06:11:39 CST