Re: Oracle environment ORACLE_HOME setting problem

Eric;

The best place to set the environments for each SID is in /usr/local/bin/oraenv file..
which is dropped in the $ORACLE_HOME ..

But you should execute the following first in your .profile..

. /usr/local/bin/oraprofile
Then
. /usr/local/bin/oraenv

And the get rid of any Oracle related "export" statements in your .profile. It may take ya a little bit to get this right the first time but you will thank me later
as you bring up multiple Instances on your machine ..:-) .. Also do not forget the following ...

export PATH=$PATH:. ==> it's a DOT !!

HTH zongk Tu

Eric wrote:

> I set the parameter ORACLE_HOME=/export/home/oracle/product/8.1.5 and
> export it in the .profile, but when I use the command echo $ORACLE_HOME, it
> always displays
> ORACLE_HOME=/export/home/oracle. Can anyone know how to solve this problem?
> I use Bourne shell in Solaris7 X86 and Oracle 8.1.5
>
> Eric
Received on Fri Feb 08 2002 - 00:42:38 CST