errors login at SQLPLUS [message #262939] |
Tue, 28 August 2007 10:01 |
jroracledba
Messages: 28 Registered: August 2007
|
Junior Member |
|
|
HI
I tried to login at sqlplus but i got following error.
Also my $ORACLE_HOME is set.
vijaya@bolivia</home/oracle/product/10.2.0/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
vijaya@bolivia</home/oracle/product/10.2.0/bin>echo $ORACLE_HOME
/home/oracle/product/10.2.0
|
|
|
|
Re: errors login at SQLPLUS [message #262946 is a reply to message #262941] |
Tue, 28 August 2007 10:16 |
jroracledba
Messages: 28 Registered: August 2007
|
Junior Member |
|
|
here is my $PATH
PATH=/usr/bin:/etc:/usr/sbin:/usr/local/bin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
and $ORACLE_HOME
/home/oracle/product/10.2.0
will you pl tell me if anything wrong with it
|
|
|
Re: errors login at SQLPLUS [message #262947 is a reply to message #262946] |
Tue, 28 August 2007 10:20 |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
|
|
something like this
ORACLE_SID=oracle
ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1
export ORACLE_SID
export ORACLE_HOME
export PATH=$ORACLE_HOME/bin:$PATH
Note: replace your SID instead of ORACLE (mysid) and oracle home path also.
Regards
Taj
[Updated on: Tue, 28 August 2007 10:20] Report message to a moderator
|
|
|
Re: errors login at SQLPLUS [message #262949 is a reply to message #262947] |
Tue, 28 August 2007 10:28 |
jroracledba
Messages: 28 Registered: August 2007
|
Junior Member |
|
|
Thats how the path is get as you said but still i am geting same error.
vijaya@bolivia</home/oracle/product/10.2.0/bin>echo $PATH
/home/oracle/product/10.2.0/bin:/usr/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin
and here is my .profile
vijaya@bolivia</home/vijaya>cat .profile
ORACLE_HOME=/home/oracle/product/10.2.0
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH
export PATH
ORACLE_SID=YFSTWFC
export ORACLE_SID
EDITOR=vi
export EDITOR
if [ -s "$MAIL" ] # This is at Shell startup. In normal
then echo "$MAILMSG" # operation, the Shell checks
fi # periodically.
set -o vi
stty erase
export PS1=`whoami`"@"`hostname`"<"'$PWD'">"
if [ -s "$MAIL" ] # This is at Shell startup. In normal
then echo "$MAILMSG" # operation, the Shell checks
fi # periodically.
so just get look on it .if you find anything wrong.
thanks
|
|
|
|