bash: sqlplus: command not found 解决方法

bash: sqlplus:command not found 解决方法(一)

环境变量已经配好，但是仍报错：

[oracle@dg1 ~]$ vi .bash_profile

# .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
unset USERNAME

export EDITOR=vi
export ORACLE_SID=dg1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
exportPATH=/u01/app/oracle/product/10.2.0/db_1/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
export PATH=$ORACLE_HOME/bin:$PATH
umask 022

解决方法：

[oracle@dg1 ~]$ sqlplus /nolog
bash: sqlplus: command not found
[oracle@dg1 ~]$ ln -s $ORACLE_HOME/bin/sqlplus /usr/bin
ln: creating symbolic link `/usr/bin/sqlplus' to `/bin/sqlplus': Permissiondeni ed
[oracle@dg1 ~]$ su - root
Password:
[root@dg1 ~]# ln -s $ORACLE_HOME/bin/sqlplus /usr/bin
[root@dg1 ~]# su - oracle
[oracle@dg1 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon May11 12:51:24 2009

Copyright (c) 1982, 2005, Oracle.  All rightsreserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
FixedSize                 1218316 bytes
VariableSize             79694068 bytes
Database Buffers          83886080 bytes
RedoBuffers               2973696 bytes
Database mounted.
Database opened.
SQL>

bash: sqlplus: command not found解决方法(二)

 

环境变量:

[oracle@ocmdb2~]$ cat .bash_profile

# .bash_profile

 

# Get thealiases and functions

if [ -f~/.bashrc ]; then

        . ~/.bashrc

fi

 

# User specificenvironment and startup programs

 

PATH=$PATH:$HOME/bin

 

export PATH

unset USERNAME

exportORACLE_BASE=/u01/app/oracle

exportORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

报错:

[oracle@ocmdb2bin]$ sqlplus / as sysdba

-bash: sqlplus:command not found

解决办法:

在参数文件中添加

exportPATH=$PATH:$ORACLE_HOME/bin

原因是sqlplus应用程序的脚本位于这个文件夹下