Re: $ORACLE_HOME

When you run oraenv without databases having been created, it resets environment variables back to defaults as defined in the oraenv script. For ORACLE_HOME, this is the home directory for user oracle. I have experienced that when doing new installs, I never use the oraenv script and set everything in .profile. I use the script only on machines with multiple databases, to reset the environment, or for other (than oracle) users to set their paths.

Jeroen van Veldhuizen

Harry Tedjo-putranto wrote:

> ORACLE_HOME Configuration
>
> 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...
> ##############################################
> # needed to run Ora client stuff
> # ORACLE defs
> ORACLE_BASE=/usr01/u01/oracle
> ORACLE_HOME=$ORACLE_BASE/product/816
> ORACLE_SID=O816
>
> export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
>
> PATH=$PATH:$ORACLE_HOME/bin
>
> # END OF needed to run Ora client stuff
> ##############################################
>
> I think that I have executed this profile correctly (executed ./oraenv), but
> when logged in as oracle if I do a CD $ORACLE_HOME
> It will change the directory to home\oracle, when it should be
> /usr01/u01/oracle/product/816
> based on what I have in my .profile
> What am I doing wrong? How should I execute my .profile so it will take
> effect? Thanks in advance
Received on Sun Mar 18 2001 - 13:23:23 CET