在服务器上执行 [oracle@oraclebin]$ sqlplus /nolog 报以下的错:
Error 6 initializing SQL*PLUS
Message file sp1<lang>.msb not found
[B]You may need to set ORACLE_HOME to your oracle software directory[/B]
telnet连上服务器执行sqlplus /nolog却没有这个问题
我怀疑是我的bash_profile有问题,以下是其键入的内容,请大家帮助。
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
export ORACLE_BASE=/home/oracle/database
export ORACLE_HOME=/home/oracle/database/product/10.2.0/db_1 ------->这里的路径没有错
export ORACLE_SID=test
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_OWNER=oracle
export ORACLE_TERM=xterm
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
Error 6 initializing SQL*PLUS
Message file sp1<lang>.msb not found
[B]You may need to set ORACLE_HOME to your oracle software directory[/B]
telnet连上服务器执行sqlplus /nolog却没有这个问题
我怀疑是我的bash_profile有问题,以下是其键入的内容,请大家帮助。
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
export ORACLE_BASE=/home/oracle/database
export ORACLE_HOME=/home/oracle/database/product/10.2.0/db_1 ------->这里的路径没有错
export ORACLE_SID=test
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_OWNER=oracle
export ORACLE_TERM=xterm
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LC_CTYPE=en_US.UTF-8
答:
export CLASSPATH=$ORACLE_HOME/jre
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
转自:http://www.itpub.net/forum.php?mod=viewthread&tid=636129&highlight=