Monday, July 23, 2012

BASH: SQPLUS COMMAND NOT FOUND


bash: sqlplus: command not found


Oracle S/W is installed on Unix server, but  below error message is there.

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

Solution:
Go to ORACLE_HOME (Path oracle is installed)
[oracle@~]$ cd /opt/oracle/product/11.2.0/
[oracle@ dbhome_1]$ export ORACLE_HOME=/opt/oracle/product/11.2.0
[oracle@dbhome_1]$ cd bin/
[oracle@ bin]$ ./sqlplus

 SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 11 20:53:19 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

To   fix this add following entries into .bash_profile file at /home/oracle location.

Export ORACLE_HOME=/opt/oracle/product/11.2.0
Export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin