Re: DBShut/DBStart scripts does'nt working in Crontab....

From: Full Moon DBA Services $remove NOSPAM to reply$ <info_at_NOSPAM.fullmoondba.com>
Date: Mon, 17 Sep 2001 14:58:13 GMT
Message-ID: <9cop7.22313$5A3.7261003@news1.rdc2.pa.home.com>

You need to set your environment variables in the script -- i.e. ORACLE_HOME, PATH, etc.

-Joe

"Adnan" <adnanans_at_cyber.net.pk> wrote in message news:d29dbd53.0109170651.74d3238f_at_posting.google.com...
> i m using SCO-UnixWare 7 with Oracle8i Rel2 Enterprise edition. i m
> facing the following problem...can any body provide me with the sol.
>
> i have created a crontab for my oracle8i user for a cold backup as
> follows:
>
> 0 1 * * * bk.sh
>
> bk.sh contains the following entries:
>
> dbshut > dbshut.log
> date > endshut.log
> cp /home2/oracle8i/dbfiles/* /home1/oracle8i/backup/*
> tar cv8 /home2/oracle8i/dbfiles/*
> dbstart > dbstart.log
> date > dbstartdt.log
>
>
> when i run dbstart.sh and dbshut.sh manually ....they worked
> fine...but when i see for log file 'dbstart.log' & 'dbshut.log' the
> next day....the files were not there...means the database was not
> shutdown or started...so cold backup has been corrupted. the date
> entry file were available...means the crontab utility works fine.
>
> can any body provide me with the sol..
>
> Regards,
>
> Adnan
Received on Mon Sep 17 2001 - 09:58:13 CDT