Message file sp1.msb not found错误的解决方案

31 篇文章 0 订阅

.bash_profile第一次设置如下:

[oracle@localhost oracle]$ cat .bash_profile
# .bash_profile
 
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi
 
# User specific environment and startup programs
 
export ORACLE_BASE=/home/oracle/oracle
export ORACLE_HOME=/home/oracle/oracle/product/10.2.0
export ORACLE_SID=orcl
export NLS_LANG='american_america.ZHS16GBK'
export LD_LIBRARY_PATH=$ORACLE_HOME/db_3/lib:$LD_LIBRARY_PATH
export PATH=$PATH:$ORACLE_HOME/db_3/bin:$HOME/bin
unset USERNAME

在输入sqlplus命令是出现如下错误:

[oracle@localhost oracle]$ 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
通过查询google并尝试修改了参数为如下:

[oracle@localhost oracle]$ cat .bash_profile
# .bash_profile
 
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi
 
# User specific environment and startup programs
 
export ORACLE_BASE=/home/oracle/oracle
export ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_3
export ORACLE_SID=orcl
export NLS_LANG='american_america.ZHS16GBK'
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin
unset USERNAME
进行了如上修改后再次允许sqlplus后正常:

[oracle@localhost oracle]$ sqlplus "/as sysdba"
 
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Apr 19 22:32:26 2008
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 10g Release 10.2.0.1.0 - Production
 
SQL> select * from dual;
 
D
-
X
 
SQL>

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值