Problem with Cron/Crontab
586608Sep 5 2008 — edited Sep 8 2008Hi,
My Platform: Oracle 10g R2, Oracle Enterprise Linux AS 5
I created a crontab file that starts up my oracle instace at a particular time specified in the file.
The start.sh script resides on /home/oracle/ and I edited my crontab as follows:
30 12 * * * /home/oracle/start.sh -- to run @ 12:30 everyday.
Here is the content of start.sh script:
===========================
#!/bin/bash
# Title: start.sh
cd $ORACLE_HOME/bin
./sqlplus /nolog <<EOF
conn /as sysdba;
startup;
EOF
============================
But when the script runs I get the error below:
/home/oracle/start.sh: line 6: ./sqlplus: No such file or directory
Again, when I run the same script (start.sh) from shell it runs successfully.
[oracle@kerrysson ~] ./start.sh --- run successfully.
Please what could be the solution here? Put me through please.
Thanks and regards,
Creems