From: obakesan <>
Date: Thu, 23 Oct 2008 12:53:58 GMT
Message-ID: <Gt_Lk.99$>


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:

This release complies with Optimal
Flexible Architecture (OFA) guidelines.
All subdirectories are not under a top
level ORACLE_HOME directory. There is a
top level directory called ORACLE_BASE
that by default is C:\oracle. If you
install the latest Oracle Database release on a computer with no other Oracle
software installed, then the default setting for the first Oracle home directory is
C:\oracle\orann, where nn is the
latest release number

For example a table on p48 Ch2:

Platform | Default Name | Default Location UNIX | spfiledbname.ora | $ORACLE_HOME/dbs or the same location as the datafiles
Windows | spfileSID.ora | ORACLE_BASE\ORACLE_HOME\database         

Yet I recall using scripts on Linux which referenced ORACLE_BASE Eg:


has $ORACLE_BASE been part of the [U|L]inux installation in the past? If so, was this something 'cleaned up' with the introduction of OFA?

See Ya
(when bandwidth gets better ;-)

Chris Eastwood
Photographer, Programmer Motorcyclist and dingbat blog:

please remove undies for reply Received on Thu Oct 23 2008 - 07:53:58 CDT

Original text of this message