Re: Starting Database using Cron

On 8 Aug 1998 05:02:41 GMT, mjain_at_bigfoot.com wrote:

>The CRON job is not the solution in this scenario.
....
....

>CRON job wont work because CRON jobs are specified to occur

>at fixed/seleced points in times. Generally OS startup and

>shutdown is not fixed in time. Moreover, OS shutdown is

>almost all cases manual process. So you need a solution which

>is event driven based on operating system bootup or shutdown.

I am a little puzzled about these remarks. At our site we do a full system backup each night. The backup is scheduled using CRON with an entry in the crontab like:

0 1 * * * /sb/bin/backup

In this backup script several other scripts are started, the first being su - oracle -c dbshut and the last being su - oracle -c dbstart. The dbshut and dbstart scripts are the one's provided by ORACLE in the $ORACLE_HOME/bin directory. This has worked since years and I realy don't see your problem. I would welcome a reaction

Kind regards

Paul Schluck (schluck_at_gironet.nl) Received on Sat Aug 08 1998 - 01:23:11 CDT