Message file sp1.msb not found错误的解决方案
来源:互联网 发布:立诺软件 编辑:程序博客网 时间:2024/05/17 09:14
.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>
- Message file sp1.msb not found错误的解决方案
- Message file sp1<lang>.msb not found
- Message file SP1<lang>.msb not found
- Message file sp1<lang>.msb not found
- oracle安装, Message file sp1<lang>.msb not found
- Docker: oracle_xe_10g 数据库 运行sqlplus 时Message file sp1<lang>.msb not found 错误解决办法_20160513_七侠镇莫尛貝
- WINDOWS下运行ORACLE SQLPLUS时报错Message file sp1<lang>.msb not found问题解决
- 计划任务里执行包含连接oracle命令的shell脚本报错:SP2-0667: Message file sp1<lang>.msb not found
- ./sqlplusSP2-0667: Message file sp1<lang>.msb not found。SP2-0750: You may need to set ORACLE_HOME t
- SP2-0667: Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Ora
- rman备份报错Message file RMAN<lang>.msb not found
- sqlplus 登录报 Message file UTILITY_MSG\spw<lang>.msb not found!
- EXP-00000: Message 0 not found; No message file for product=RDBMS, facility=EXP问题的解决方案
- EXP-00000: Message 0 not found; No message file for product=RDBMS, facility=EXP问题的解决方案
- cstdlib file not found的解决方案
- 启动sqlplus出现SP1(LANG).MSB错误
- nginx File not found 错误
- nginx File not found 错误
- 跳啊跳的,就习惯了……
- 高峰对话:软件业的人才竞争与瓶颈
- 灰度图
- oracle关于字符集的两个小工具
- 学习洪迈
- Message file sp1.msb not found错误的解决方案
- 被国人误传了数千年的七句话(转自天涯)
- 英文标点符号翻译大全
- 关于SINGLTON在C++里实现(zz)
- 电厂人员跳槽的原因
- What a beautiful spring
- 4.10
- 人工智能AI程序设计语言
- SQL SERVER的数据类型