Re: How to apply Oracle patch?

Since server manager is referred, it is implied that these scripts should be ran as INTERNAL. Something like this would do:

os> svrmgrl
SVRMGR> connect internal
Connected.
SVRMGR> @?/rdbms/admin/catalog.sql
...
SVRMGR> @?/rdbms/admin/catproc.sql
...
SVRMGR> @?/rdbms/admin/catexp.sql
...
SVRMGR> @?/rdbms/admin/catrep.sql
...

catrep.sql is only needed if you are using replication, otherwise you can safely skip it. And I believe patch set installation instructions have all patch application steps outlined in detail - which tools to use, which commands to issue, etc... These instructions are usually bundled with the patch set in form of README.html or README.txt file. At least I didn't yet see an Oracle server patch set without one...

hth.

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"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

> 

> 

> 

> 

> 

> 

>