Skip to Main Content

Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with Cron/Crontab

586608Sep 5 2008 — edited Sep 8 2008
Hi,


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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2008
Added on Sep 5 2008
3 comments
1,890 views