Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

sqlplus: not found oracle 11g

996050Mar 11 2013 — edited Mar 12 2013

I have installed Oracle 11g on RHEL6.. on VM machine..
when i try to start sqlplus it says command not found..

[oracle@localhost ~]$ sqlplus
-bash: sqlplus: command not found

I have set the $ORACLE_HOME path aswell.. but still the issue persists.. some one please help me.

echo $ORACLE_HOME
/home/oracle/app/oracle/product/11.2.0

env command output...

[oracle@localhost ~]$ env
HOSTNAME=localhost.localdomain
SELINUX_ROLE_REQUESTED=
TERM=xterm
SHELL=/bin/bash
HISTSIZE=1000
SSH_CLIENT=192.168.75.1 2824 22
SELINUX_USE_CURRENT_RANGE=
OLDPWD=/home/oracle/app/oracle/product/11.2.0/dbhome_1
SSH_TTY=/dev/pts/0
USER=oracle
MAIL=/var/spool/mail/oracle
PATH=/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin
PWD=/home/oracle
LANG=en_US.UTF-8
SELINUX_LEVEL_REQUESTED=
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
HISTCONTROL=ignoredups
SHLVL=1
HOME=/home/oracle
LOGNAME=oracle
SSH_CONNECTION=192.168.75.1 2824 192.168.75.128 22
LESSOPEN=|/usr/bin/lesspipe.sh %s
ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0
G_BROKEN_FILENAMES=1
_=/bin/env

Paul M.

I have set the $ORACLE_HOME path aswell

But you didn't set it within PATH environment variable, for example

$ export PATH=$ORACLE_HOME/bin:$PATH

Dude!

The following should work:

[root@ol1 ~]# su - oracle
[oracle@ol1 ~]$ . oraenv
ORACLE_SID = [oracle] ? yoursid
The Oracle base has been set to /u01/app/oracle
[oracle@ol1 ~]$ which sqlplus
/u01/app/oracle/product/112/db/bin/sqlplus

alvaromiranda

Hi there

try dude suggestion, but you got the wrong oracle home

checking the output you should do

export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH

you should set the ORACLE_SID as the db instance, but with the PATH and the proper ORACLE_HOME you will get sqlplus

Alvaro.

1 - 3

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2013

Added on Mar 11 2013

#generic-linux, #linux

3 comments

15,340 views

Infrastructure Software

sqlplus: not found oracle 11g

Comments

Post Details