UNIX for Dummies Questions & Answers

Hi

I have shell script to excute the SQL script.And i have scheduled those shell script in crontab.But the Shell script is not running timely and i got the below error
Crontab entry

Code:

15 05 17 7 * /export/home/vcpsapp/vcps/stat.sh

Output
Your "cron" job on uspxivus16
/export/home/pcvsapp/rvcps/stat.sh

produced the following output:
/export/home/pcvsapp/rvcps/stat.sh: sqlplus: not found

Please help me Thanks In advance

in stat.sh file, enter the full path of sqlplus. use these commands to find where it is:

Code:

which sqlplus
whereis sqlplus
whence sqlplus
locate sqlplus
find / -type f -name 'sqlplus' 2>/dev/null

You should add $ORACLE_HOME/bin to the search path inside the script:

Code:

PATH=$PATH:$ORACLE_HOME/bin

When you execute a program from CRONTAB, the job will have basic environment setting. So as others said, you have to set the env configuration required for you program inside the shell script you are executing. As such I could think of the following:

Code:

ORACLE_SID=
ORACLE_HOME=
PATH=$PATH:$ORACLE_HOME/bin