how can i call sqlplus?

theodore · #1 (**permalink**) 04-02-2008

i am new working with hp-ux but i had to because of my job.
so i want to execute some sql scripts but
when i call sqlplus to run them it responds
/sbin/sh: sqlplus not found.
i have oracle 8.1.7 installed.
what should i do
sorry if this sounds too easy but i am now learning.
The same appears for gunzip. Is it missing or i don't have the right shell???

vbe · #2 (**permalink**) 04-02-2008

start by :
which sqlplus

Does it find it?
If not you would have to set your path to include the directory where it lies, most certainly /opt/oracle/product/8.1.7/bin but as this depend on how it is installed you will have to check...

theodore · #3 (**permalink**) 04-02-2008

at which sqlplus it says
no sqlplus in /usr/sbin /opt/java1.4/bin /usr/dt/bin /usr/bin / /usr/local/bin /
var/opt /usr/css/bin /usr/ucb /etc /bin /opt/bin .

so i suppose i haven't set my path to include the directory where it lies.
the path installed is /usr/oracle/u01/8.1.7/bin
what do i have to write to set my path to include this directory?

thank you vbe

vino · #4 (**permalink**) 04-03-2008

Quote:

Originally Posted by theodore

at which sqlplus it says
no sqlplus in /usr/sbin /opt/java1.4/bin /usr/dt/bin /usr/bin / /usr/local/bin /
var/opt /usr/css/bin /usr/ucb /etc /bin /opt/bin .

so i suppose i haven't set my path to include the directory where it lies.
the path installed is /usr/oracle/u01/8.1.7/bin
what do i have to write to set my path to include this directory?

thank you vbe

You need to set ORACLE_HOME, ORACLE_SID explicitly. Do this
In sh/ksh

Code:

set ORACLE_HOME=/usr/oracle/u01/8.1.7
set PATH=${ORACLE_HOME}/bin;${PATH}

theodore · #5 (**permalink**) 04-03-2008

Quote:

Originally Posted by vino

You need to set ORACLE_HOME, ORACLE_SID explicitly. Do this
In sh/ksh

Code:

set ORACLE_HOME=/usr/oracle/u01/8.1.7
set PATH=${ORACLE_HOME}/bin;${PATH}

hi vino, thanks for your answer.
after the second command set PATH=....
i get ksh: /usr/sbin:/opt/java1.4/bin:/usr/dt/bin:/usr/bin:/:/usr/local/bin:/var/opt:/
usr/css/bin:/usr/ucb:/etc:/bin:/opt/bin:: not found
am i doing something wrong???

Other UNIX.COM Threads You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
sqlplus call	JohnZ1385	UNIX for Dummies Questions & Answers	1	4 Weeks Ago 07:48 AM
Call sqlplus in the shell script	beaniebear	Shell Programming and Scripting	3	05-13-2008 06:30 AM
how to differentiate system call from library call	muru	UNIX for Advanced & Expert Users	2	07-19-2007 08:20 PM
Sqlplus	LiquidChild	Shell Programming and Scripting	9	06-01-2007 08:22 AM
Sqlplus	antkiu	Shell Programming and Scripting	4	09-13-2006 09:36 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode