i have shell script. when i run in normail mode..it run ok but when i use crontab command to set that program run in certain time it give an error.
error 'SQLPLUS cannot execute'
what the problem.i already set all the correct path and use both root and normal id but still cannot execute properly.
It's the environment - is $ORACLE_SID defined, ORACLE_HOME, etc.
crontab processes run without executing the same profiles that an interactive user runs.