Re: ORACLE_HOME for upgrade

On Thu, 9 May 2002 00:18:59 +0200, "Anton Buijs" <aammbuijs_at_xs4all.nl> wrote:

>I'am a little bit confused here. Suppose you are talking about Oracle on a
>Unix machine (although next applies for Windows NT/2K too).

Sorry... should have stated HP-UX 11.0

>Never never never install a release in the same home as another release
>(release = defined as a version that Oracle releases as a complete set of
>CD's). Only install bugfixes or patches (like V8.1.7 patch 3) in the
>appropriate home (like /oracle/product/8.1.7).

So what do I do with the space?

>A value "/oracle/SID" for ORACLE_HOME is one I would never choose. And
>should SID be replaced with a real value for a SID? Or is it really the
>string "SID"?

The SID is just a representation of the system. We have SID=TRN, QAS, etc depending on the system So, for example, home on our QAS system is /oracle/QAS

>Also V8.0.6 is about 400 - 500 Mb on my HP-UX or Sun Solaris boxes. Are the
>databases files in that directory structure too?

They are on different mount points off of that mount point (ie /oracle/QAS is the ORACLE_HOME... the data is in /oracle/QAS/sapdata1... /oracle/QAS/sapdata2... etc)

>My policy is to never add files of myself under the ORACLE_HOME (except mayby for the trivial ones like
>init.ora and Net8 configuration but even for those there are other locations possible).

Nice if you were the one setting up the original system. This is an inheritated (sp?) system and configuration.

>V8.1.7 indead requires about 1.5 Gb disk space, depending on the options you install and if it is standard or enterprise edition.
>Can not imagine that the upgrade doc for 8.1.7 proposes /oracle/SID/817_64 as the new home.

Page 9 of "Migrating/Upgrading to Oracle Version 8.1.7: UNIX says to set the following variable ORACLE_HOME to /oracle/<SAPSID>/817_32 or 817_64".

>All Oracle Installation Guides for Unix platforms describe the socalled OFA
>standard (Optimal Flexible Architecture) and I suggest you examine that to
>structure your installation properly.

SAP != Oracle

Thanks for the feedback though. Still doesn't answer my orignal question.

Vince Received on Thu May 09 2002 - 09:06:29 CDT