oracle安装, Message file sp1<lang>.msb not found
来源:互联网 发布:海关大数据数据挖掘 编辑:程序博客网 时间:2024/06/05 13:34
在启动oracle的时候,出现如下报错:
[oracle@oracle10g bin]$ ./sqlplus / as sysdba
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOMEto your Oracle software directory
原因:
1)系统会在$ORACLE_HOME/sqlplus/mesg路径下寻找sp1<lang>.msb文件,如果不正确指定ORACLE_HOME和NLS_LANG就无法找到消息文件,从而导致sqlplus运行失败。检查$ORACLE_HOME/sqlplus/mesg目录是否可以正常访问,如不能正常访问,需要修改相应权限
[root@oracle10g db_1]# ls -l/home/oracle/oracle/product/10.2.0/db_1/sqlplus |grep mesg
drwxr-x--- 2 oracle oinstall 4096 11月 7 17:41 mesg
2)检查环境变量$ORACLE_HOME设置是否正确
[oracle@oracle10g bin]$ echo $ORACLE_HOME
看一下/home/oracle/.bash_profile文件里面$ORACLE_HOME的正确设置
export ORACLE_BASE=/home/oracle/oracle
exportORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
从上面文件中可以得出:
ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1
然后重新导出变量
[oracle@oracle10g bin]$ exportORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1
[oracle@oracle10g bin]$ echo $ORACLE_HOME
/home/oracle/oracle/product/10.2.0/db_1
而不能这么导变量
[oracle@oracle10g bin]$ exportORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
当你查看变量的时候就是这样的了:
[oracle@oracle10g bin]$ echo $ORACLE_HOME
/product/10.2.0/db_1
重新导出变量以后就可以进入oracle了
[oracle@oracle10g bin]$ ./sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Productionon Mon Nov 14 17:31:34 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
- oracle安装, Message file sp1<lang>.msb not found
- Message file sp1<lang>.msb not found
- Message file SP1<lang>.msb not found
- Message file sp1<lang>.msb not found
- WINDOWS下运行ORACLE SQLPLUS时报错Message file sp1<lang>.msb not found问题解决
- Message file sp1.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
- Docker: oracle_xe_10g 数据库 运行sqlplus 时Message file sp1<lang>.msb not found 错误解决办法_20160513_七侠镇莫尛貝
- rman备份报错Message file RMAN<lang>.msb not found
- sqlplus 登录报 Message file UTILITY_MSG\spw<lang>.msb not found!
- 启动sqlplus出现SP1(LANG).MSB错误
- oracle数据泵impdp命令导入报错UDI-00013: Message 13 not found; No message file for product=RDBMS, facility=UDI
- Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No mes
- 安装Jpype jni.h' file not found
- elasticsearch class file for java.lang.AutoCloseable not found
- TNS-01106: Message 1106 not found; No message file for product=network, facility=TNS
- NSString的使用
- 写个答辩经验贴
- C和指针读书笔记——基本概念
- Linux安装Oracle报Checking operating system version must be redhat-3, SuSE-9, redhat-4, UnitedLin
- Drupal 7如何配置用户注册信息?
- oracle安装, Message file sp1<lang>.msb not found
- java日期处理类总结:Date/Calendar/GregorianCalendar/DateFormat/SimpleDateFormat类
- 杂:GMT时间 DMStoDD
- arcsde service(esri_sde)服务启动后又停止
- python struct模块
- socket基础
- WAN监控:是否应该外包?
- java视频---集合类
- c 字符串提取Mystrstr