Re: How to apply Oracle patch?

Hi Norman,

Only a small correction. The "catexp.sql" script is included in "catalog.sql", don't know since when, but my 7.3.4 catalog.sql contains the catexp line.
No harm is done of course, "catalog.sql" can be run as often as you want, but every key that doesn't have to be hit reduces my chances of making mistakes ;-)

Peter

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> schreef in bericht news:E2F6A70FE45242488C865C3BC1245DA70323FBE8_at_lnewton.leeds.lfs.co.uk...
> Afternoon,
>
> to run the patches you will need to be logged in as either 'internal',
> 'system' or 'sys' - the instructions should mention somewhere which one.
>
> To run the patches, login using sqlplus to the appropriate user, and
> then simply (?)
>
> @?\rdbms\admin\catalog.sql
> @?\rdbms\admin\catproc.sql
> @?\rdbms\admin\catexp.sql
>
> The '?' in the above is correct (at least on Unix) and is an Oracle
> shorthand for 'Oracle Home' which is usually set up as an environment
> variable in both Windows and Unix. I'm assuming it works correctly on
> Windows as well, but if not, simply replace the commands with the full
> path to the Oracle home directory, as in :
>
> @c:\orant\rdbms\admin\catalog.sql
> etc
>
> There will/may be errors when you run the scripts, along the lines of
> 'cannot drop object' etc, but these can be ignored.
>
> Have fun !
>
> I presume you are aware that Oracle 8.0.4 is out of date and is
> unsupported by Oracle any more? The only Oracle 8 version still in
> support is 8.1.7.
>
> I presume that your supplier will be able to tell you if their
> application will run on 8.1.7 won't they :o)
>
> Regards,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
>
>
> -----Original Message-----
> From: Slava Pechenin [mailto:slava_at_pechenin.ru]
> Posted At: Thursday, January 09, 2003 12:12 PM
> Posted To: server
> Conversation: How to apply Oracle patch?
> Subject: How to apply Oracle patch?
>
>
> 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...
>
> <SNIP>
>
>
Received on Thu Jan 09 2003 - 08:21:29 CST