setting Oracle Home

DILEEP410 · December 14, 2006, 6:34am

Hi,

if i set Oracle home in the command line as 
export ORACLE_HOME=/usr/oracle/product/9.2.0; and then checking it by
typing echo $ORACLE_HOME,its getting the correct result.But if i try setting the ORACLE_HOME from a shell script by just including the same line as above,it was not working.Could anybody give me a tip regarding this?

With Regards
Dileep

aju_kup · December 14, 2006, 6:37am

try

ORACLE_HOME=/usr/oracle/product/9.2.0

export ORACLE_HOME

vino · December 14, 2006, 6:38am

If you want to set the env variable from a shell script, then you need to source that file i.e.

source myscript.sh

DILEEP410 · December 14, 2006, 7:15am

fine.This seems to be working.Thanks for your comment.