This content has been marked as final. Show 3 replies
Set Bash_profile like below
login as oracle user
TMP=/tmp; export TMP
TEMPDIR=$TMP; export TEMPDIR
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1; export ORACLE_HOME
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
ulimit -u 16384 -n 65536
and then save it.
now execute sqlplus command on terminal.
Vikas Kohli wrote:Set the environment variable PATH correclty and make sure you've added $ORACLE_HOME/bin folder to it
OS : Solaris
Oracle Version : 10.1.0.2.0
When i am trying to connect to database by typing sqlplus
i am getting error
-bash: sqlplus: command not found
previously when i connect like that i am able to connect to database
when i check space
I have 32 GB Drive and free space is 288M.
Can anyone tell me is this the space issue or any other issue.
I logged in with Oracle User
Kamran Agayev A.
export PATH=$ORACLE_HOME/bin:$PATH sqlplus / as sysdba
- - - - - - - - - - - - - - - - - - - - -
My Oracle Video Tutorials - http://kamranagayev.wordpress.com/oracle-video-tutorials/