ORACLE_HOME

[systemsfsu]

I tried installing Oracle 10g on a unix box. My installtion was sucessful but when I try to run sqlplus I get the following error.

________________________

[sai@ma-1 bin]$ ./sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
____________________________

I searched online and found that I had to set my $ORACLE_HOMe properly. Now even after doing that I get the same error.
My .bash_profile has the follwing contents:
-----------------------------------

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
export ORACLE_HOME=$/home/sai/oracle/product/10.2.0/db_1
export ORACLE_SID=hcsdatabase
export PATH=$PATH:$ORACLE_HOME/bin
export PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
--------------------------------------

Please let me know if am making a mistake.

Thanks
-Sai

 

[SantaMufasa]

Sai,

What is the result of your issuing the commands:

echo $ORACLE_SID
echo $ORACLE_HOME

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[systemsfsu]

Dave,

They also seem to be right!

[sai@ma-1 ~]$ echo $ORACLE_HOME
$/home/sai/oracle/product/10.2.0/db_1

[sai@ma-1 ~]$ echo $ORACLE_SID
hcsdatabase

-Sai

 

[hoinz]

Sai,

I have never seen a $ sign in a place like this:

export ORACLE_HOME=$/home/sai/oracle/product/10.2.0/db_1

Are you sure you shouldn't leave it away?

 

[hoinz]

Sai,

I have never seen a $ sign in a place like this:

export ORACLE_HOME=$/home/sai/oracle/product/10.2.0/db_1

I think you should leave it away.

 

[hoinz]

Sorry for the double posting

Tek-tips' reaction is a bit slow this morning ....

 

[KenCunningham]

I think you're correct about the $, Hoinz. You're also correct about responsiveness this morning!

I want to be good, is that not enough?