sqlplus command not found
842009Mar 5 2011 — edited Mar 5 2011Hi,
i am newbie to oracle.tried installing oracle 10g in ubuntu.
i am successful with the oracle installation.
i am able to login to sqlplus using oracle OEM,but when i try to login through command prompt , i get the following error:
rakesh@ubuntu:/$ sqlplus "/ as sysdba"
bash: sqlplus: command not found
rakesh@ubuntu:/$ sqlplus
bash: sqlplus: command not found
i have also tried to set the oracle_home, oracle path & oracle SID.
please find the below configuration parameters which i have set to.
----------------------------------------------------------------------------------------------------------------------------------
root@ubuntu:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin# more oracle_env.sh
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_HOME
ORACLE_SID=XE
export ORACLE_SID
#NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
NLS_LANG='$ORACLE_HOME/bin/nls_lang.sh´ > NLS_LANG='$ORACLE_HOME/bin/nls_lang.sh'
export NLS_LANG
PATH=$ORACLE_HOME/bin:$PATH
export PATH
if [ $?LD_LIBRARY_PATH ]
then
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
else
LD_LIBRARY_PATH=$ORACLE_HOME/lib
fi
export LD_LIBRARY_PATH
------------------------------------------------------------------------------------------------------------------------------------------
Please help me out.
Thanks & Regards,
Rakesh.