Home » SQL & PL/SQL » Client Tools » errors login at SQLPLUS
errors login at SQLPLUS [message #262939] Tue, 28 August 2007 10:01 Go to next message
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 #262941 is a reply to message #262939] Tue, 28 August 2007 10:02 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
set PATH variable 
set ORACLE_HOME variable

Re: errors login at SQLPLUS [message #262946 is a reply to message #262941] Tue, 28 August 2007 10:16 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: errors login at SQLPLUS [message #262950 is a reply to message #262947] Tue, 28 August 2007 10:29 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
http://www.oracle.com/technology/support/tech/sql_plus/htdocs/faq101.html
Previous Topic: Newbie for Oracle 9i
Next Topic: & sign in where clause
Goto Forum:
  


Current Time: Sat Dec 03 18:08:58 CST 2016

Total time taken to generate the page: 0.14926 seconds