I am getting sqlplus not found error while trying to connect to database from unix.
my sql plus is present at the location
/opt/dbms/app/oracle/product/10.2_Client
and i gave in shell script as below.
ORACLE_HOME=/opt/dbms/app/oracle/product/10.2_Client
export ORACLE_HOME
Please help me with this..am i missing something here?
What is the result of the
# which sqlplus
command ?
And
# echo $ORACLE_HOME
?
For Oracle 9.2 this is the path (on my system):
/usr/oracle/app/oracle/product/9.2/bin/sqlplus
Mind the bin directory.
type..
whereis sqlplus
or
which sqlplus
Sorry for the confusion.
It is working finw now..i gave it as follows.
ORACLE_HOME=/opt/dbms/app/oracle/product/10.2_Client
export ORACLE_HOME
$ORACLE_HOME/bin/sqlplus -s ........
. oraenv
would normally be used to set up the environment.
Hi rdhanek,
export ORACLE_HOME and PATH vraibles as
ORACLE_HOME=opt/dbms/app/oracle/product/10.2_Client ;
export ORACLE_HOME
PATH=${ORACLE_HOME}/bin:${PATH} ;
export PATH
Now try
Hi folks,
I don't really understand why you need to do that.
head -20 /usr/local/bin/oraenv
#!/bin/sh
#
# $Header: oraenv.sh.pp 16-jun-2005.10:46:09 mlfallon Exp $ oraenv.sh.pp Copyr (c) 1991 Oracle
#
###################################
#
# usage: . oraenv
#
# This routine is used to condition a user's environment for access to
# an ORACLE database. It will prompt for the value of the new SID unless
# the variable ORAENV_ASK is set to NO, in which case it will use the
# current value of ORACLE_SID.
# The character "*" denotes a null SID.
#
# NOTE: Due to constraints of the shell in regard to environment
# ----- variables, the command MUST be prefaced with ".". If it
# is not, then no permanent change in the user's environment
# can take place.
#
#####################################
I'm not sure I agree with this statement, though!!