topic Re: error:run sqlplus in Operating System - HP-UX

error:run sqlplus

robaby — Fri, 29 Dec 2000 00:54:35 GMT

./sqlplus

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

how do I resolve it?

Re: error:run sqlplus

Maureen Gunkel — Fri, 29 Dec 2000 04:29:32 GMT

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

Re: error:run sqlplus

robaby — Fri, 29 Dec 2000 04:57:37 GMT

.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

Re: error:run sqlplus

Dan Hetzel — Fri, 29 Dec 2000 05:35:30 GMT

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

Re: error:run sqlplus

robaby — Fri, 29 Dec 2000 06:04:07 GMT

thanks
I resolve it