Originally posted by dba_dada
I’m sure about Linux. But on Unix you have to set the environment variable…


ORACLE_SID=xxxxxx
ORACLE_HOME=/u01/home/oracle/product/8.0.5
export ORACLE_SID ORACLE_HOME


Hope that help!
Of course or have them in your .profile

Cheers

Angel