.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>