[root@oracleserver ~]# sqlplus openlab open123 -bash: sqlplus: command not found

Question

# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/10g
export ORACLE_SID=boson
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

[oracle@oracleserver 10g]$ which sqlplus
/oracle/10g/bin/sqlplus
[oracle@oracleserver 10g]$
大家帮我看看这是怎么回事？

Answer 1

执行以下语句确认当前环境变量是否有：
[oracle@oracleserver 10g]$env|grep oracle
如果你这是从图形界面进入的终端、需要先执行source .bash_profile

追问

你看看，我这对吗？

追答

环境变量是对的啊、那你就用绝对路径进去
/oracle/10g/bin/sqlplus

Answer 2

用oracle用户到oracle宿主目录下，执行source .bash_profile，让这个文件生效，应该就可以了