cancel
Showing results for 
Search instead for 
Did you mean: 

error:run sqlplus

SOLVED
Go to solution
robaby
Occasional Advisor

error:run sqlplus

./sqlplus

error:
Message file sp1.msb not found
Error 6 initializing SQL*Plus

how do I resolve it?
4 REPLIES
Maureen Gunkel
Trusted Contributor

Re: error:run sqlplus

Hi,
You need to add the path where that file is found to your path environment setting, in your .profile (or equivalent) file.
HTH
Mo
No matter where you go, there you are.
robaby
Occasional Advisor

Re: error:run sqlplus

.profile already set ,but it still error.

# Set up the oracle variables:
umask 022
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/8.1.5.
ORACLE_SID=test
PATH=$PATH:$ORACLE_HOME/bin
SHLIB_PATH=$ORACLE_HOME/lib
CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip:$ORACLE_HOME/myclass
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_BASE ORACLE_HOME LD_LIBRARY_PATH ORACLE_SID PATH SHLIB_PATH CLASSPATH
export NLS_LANG="simplified chinese"_china.zhs16cgb231280
chinese"_china.zhs16gbk
export LANG=zh_CN.hp15CN
Dan Hetzel
Honored Contributor
Solution

Re: error:run sqlplus

Hi Robaby,

This file is for localized messages.
As you appear to be using "simplified chinese", double check the values of LANG and NLS_LANG. Especially NLS_LANG as it appears to be very complex.

I don't have any chinese on my HP boxes, so I can't really check it for you ;-)

Best regards,

Dan
Everybody knows at least one thing worth sharing -- mailto:dan.hetzel@wildcroft.com
robaby
Occasional Advisor

Re: error:run sqlplus

thanks
I resolve it