sqlplus: command not found

UNIX HP-UX
1

hi,

i need bash shell script run on the crontab(Unix tru64).

i have write my shell. it's using sqlplus command and connect to oracle db.

execute cron job when i have error messege: "sqlplus: command not found"

have you any suggestion?

2

You have to set PATH

export PATH=$PATH:$ORACLE_HOME/bin

3

yes, i defined oracle variables.

./myshell.sh 1>> pay.log 2>> pay.err

below pay.err file:

./myshell.sh: sqlplus: command not found
./myshell.sh: sqlldr: command not found
./myshell.sh: sqlplus: command not found

4

did the shell script run successful while executed from comman prompt and
you get this error while executing from cron? if yes then

export ORACLE_HOME in you shell script...

5

Thank you advice both.
i had define many variables in the shell but lost only ORACLE_HOME variable.
now it's successful run on the cron.