How to apply Oracle patch?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 9 Jan 2003 13:35:12 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70323FBE8@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 - 07:35:12 CST