Re: ORACLE_BASE and $ORACLE_HOME

From: obakesan <pellicleundies_at_hotmail.com>
Date: Fri, 24 Oct 2008 05:19:49 GMT
Message-ID: <VVcMk.12$Tr.1@read4.inet.fi>


Hi

In article <8df1dc7a-54e8-4319-b981-bfc66ac7f13e_at_z6g2000pre.googlegroups.com>, joel garry <joel-garry_at_home.com> wrote:
>If you search tahiti.oracle.com for the phrase:
>Optimal Flexible Architecture
>
>and then look at the 10g docs, you may notice a whole bunch of unix
>installation guide references.

you know, when I read stuff like that I wonder if the reply was a typical "knee jerk reaction" of RTFM, but I did mention:

>> In the past I recall using both $ORACLE_BASE and $ORACLE_HOME, but when
>> reading Administrator's Guide 10g Release 1 (10.1) Part No. B10739-01 I
>> find that it suggests ORACLE_BASE is only windows platform.
>>
>> the manual states:

just incase you didn't noitce that

I did search what you suggested, and had found this:

The Database Configuration Assistant provides the ability to create an Oracle OFA (Optimal Flexible Architecture) compliant instance. The OFA-like file layout provides a standardized file layout and eases management and maintenance.

If the user selects to modify a database, installed cartridges that have not previously been configured for use with the database can be configured. Also, multi-threaded server support for the database can be enabled or disabled.

Oracle 8.1.5 has improved error detection mechanisms, enhanced MTS support, and better cleanup on failure and cancellation of database creation. In addition, when a database is deleted, the entire Oracle Flexible Architecture (OFA) structure is removed for that database.

[http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76962/ch2. htm#102333]

so it seems that it was in 8i that it was released and also seems that OFA can mean

Oracle Flexible Architecture as well as
Optimal Flexible Architecture

>
>Actually, it was originally put together by Cary Millsap long ago, and
>I recall seeing a post on oracle-l where he didn't agree with the mods
>for 10g.

interesting...

>It's just a recommendation, but a fairly good one as far as I'm

oh, for sure.

>concerned. There have been various mods proposed over the years, but
>personally I've found when I go into a new place if it is close to
>"standard" it's a heck of a lot easier. There are some things
>leftover from the old jbod days which can look weird, but in the end,
>it is a DBA configuration decision.
>
>The $ORACLE_HOME/dbs default location could be considered to be a
>conflicting alternative configuration to OFA.

ok, but that still leaves me wondering about $ORACLE_BASE and $ORACLE_HOME. Which was my question (not if this is a better system or not).

See Ya
(when bandwidth gets better ;-)

Chris Eastwood
Photographer, Programmer Motorcyclist and dingbat blog: http://cjeastwd.blogspot.com/

please remove undies for reply Received on Fri Oct 24 2008 - 00:19:49 CDT

Original text of this message