(摘)SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
Linux下安装好Oracle 10g后运行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
解决方法:
第一,用oracle用户名登录linux系统。而不是root登录后su oracle。
第二,用oracle用户名登录linux系统后,vi .bash_profile,其中,文件.bash_profile
在/home/oracle目录下,它是隐藏文件,可以ls -a 显示所有文件(包含隐藏文件)。
第三,编辑.bash_profile文件,内容如下:
——————————————————————————————————————————————————————————————————
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$ORACLE_HOME/bin
unset USERNAME
export ORACLE_SID=orcl
export ORACLE_BASE=/home/oracle/oracle
export ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1
export 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>
posted on 2014-01-10 13:25 newmanzhang 阅读(5235) 评论(0) 编辑 收藏 举报