Re: $ORACLE_HOME

"Harry Tedjo-putranto" <noneharry_tedjo-putranto_at_compuware.com> wrote in message news:3ab27408_at_172.22.1.229...
> Hi, I am trying to install 8.1.7 on a HP-UX box. I have created a user
> called oracle to install the product. In the home\oracle area I have a
> .profile for the user oracle. Within the .profile I have the following
> information related to where I want the oracle home directory to be. This
 is
> some of what is in my .profile...

[snip]

Harry,

To keep your Oracle settings centralized in your oraenv file, I only set the minimum in my ~/.profile (and any other users' that want Oracle environment variables), and instead source the oraenv file to get the Oracle environment variables. This way, you can make changes once in your oraenv file, and any user that sources the file will automatically get the changes.

E.g.: My ~/.profile contains the following lines:   export ORACLE_SID=some_db
  ORAENV_ASK=NO
  . /usr/local/bin/oraenv
  unset ORAENV_ASK

This way, I let oraenv take care of setting all the Oracle variables. I have modified oraenv to set additional parameters, such as modifying SHLIB_PATH, and SQLPATH.

Note that oraenv file normally lives in $ORACLE_HOME/bin, where it is installed by default. I have my oraenv (that I modified) in my /usr/local/bin directory. This is so that I can upgrade Oracle without changing the path to oraenv.

Note also that I am _sourcing_ oraenv, and not simply calling it.

Hope this helps,
-Marc Received on Sat Mar 17 2001 - 01:48:59 CST