./sqlplusSP2-0667: Message file sp1<lang>.msb not found。SP2-0750: You may need to set ORACLE_HOME t
来源:互联网 发布:手机版抢购软件神器 编辑:程序博客网 时间:2024/05/21 11:03
http://wcx337.blog.sohu.com/129739601.html
Linux下安装好Oracle 10g后运行sqlplus出现故障如下:
[oracle@localhost oracle]$ ./sqlplusError 6 initializing SQL*PlusMessage file sp1<lang>.msb not foundSP2-0750: You may need to set ORACLE_HOME to your Oracle software directory解决方法:第一,用oracle用户名登录linux系统。而不是root登录后su oracle。第二,用oracle用户名登录linux系统后,vi .bash_profile,其中,文件.bash_profile在/home/oracle目录下,它是隐藏文件,可以ls -a 显示所有文件(包含隐藏文件)。第三,编辑.bash_profile文件,内容如下:——————————————————————————————————————————————————————————————————# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then . ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$ORACLE_HOME/binunset USERNAMEexport ORACLE_SID=orclexport ORACLE_BASE=/home/oracle/oracleexport ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1export PATH~——————————————————————————————————————————————————————————————————————————
重新启动系统,用oracle用户名登录。
[oracle@localhost ~]$ cd $ORACLE_HOME
[oracle@localhost db_1]$ pwd
/home/oracle/oracle/product/10.2.0/db_1
[oracle@localhost db_1]$ cd bin
[oracle@localhost bin]$ pwd
/home/oracle/oracle/product/10.2.0/db_1/bin
[oracle@localhost bin]$
然后
[oracle@localhost bin]$ ./sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 17 10:43:41 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
——————————————————————————————————————————
问题解决!!
我们发现Connected to an idle instance.
只要
SQL>startup
就ok
- ./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
- Message file sp1<lang>.msb not found
- Message file SP1<lang>.msb not found
- Message file sp1<lang>.msb not found
- SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
- SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
- oracle安装, Message file sp1<lang>.msb not found
- ubuntu 9.10 下安装ORACLE 出错SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
- 计划任务里执行包含连接oracle命令的shell脚本报错:SP2-0667: Message file sp1<lang>.msb not found
- sp2-0750:you may need oracle_home to you oracle software directory
- WINDOWS下运行ORACLE SQLPLUS时报错Message file sp1<lang>.msb not found问题解决
- Message file sp1.msb not found错误的解决方案
- 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!
- SP2-0667: Message file sp1<lan
- 进去到oracle的bin目录下,运行./sqlplus报错,You may need to set ORACLE_HOME to your Oracle software directory
- Android中android:visibility的3中属性的剖析
- Wcf 安全性 之 None
- How to cast enums which are using QFlags and QList?
- centos 6.1 samba文件共享服务器 子目录不可见 共享问题
- WinCE中将调试信息写入文件的方法[转载]
- ./sqlplusSP2-0667: Message file sp1<lang>.msb not found。SP2-0750: You may need to set ORACLE_HOME t
- IE6 下图片不能显示的问题解决
- flv格式视频播放
- android 之view与viewgroup
- 什么是REST架构
- java中的监听者模式
- js“弹出对话框”和“弹出窗口”详解
- priority_queue(优先队列)用法总结
- NOPCOMMERCE1.* 版本演变及每个版本更新说明 【上】