| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Starting Database using Cron
---Scenario specified in original question-----Start--
We are using Sun450 and Oracle 8.0.4, Sun Solaris 2.6. We are in process
of buying
a UPS for this machine. So in mean time we bring up the databae through
Server Manager
after we turn on the machine in the morning. I would appreciate if
someone could help me
in "Creating a Cron Job" to call a script which will call server
manager. This way Oracle gets loaded as soon as the machine gets turn
on or shutting a down when we want to turn
off the machine. Thanks in advance.
---Scenario specified in original question-----End--
In the above case, the entire operation system is going down or is coming up. That is operating system on which the database is running that is going down, so how can you use, cron for this purpose. If I shutdown the operating system now immidiately and if you have an entry in cron set up to run say at 1 AM every morning, then that cron entry is of no use, cron entry will work only in case of scheduled oracle backups where you want the entire operating system goes down.
Yes, you can use cron for scheduled backups but to automatically start / shutdown oracle at the time of operating system unix shutdown how cron will help you, it wont help you.
Let me know if you don't agree with this or correct me if I am wrong as I would alos like to learn about it.
The case you have mentioned is different as in your case you are not shutting down operating system. Please let me know if I am wrong.
Thanks,
Manoj Jain
On Sat, 08 Aug 1998 06:23:11 GMT, schluck_at_gironet.nl (Paul Schluck) wrote:
> 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)
Posted using Reference.COM http://WWW.Reference.COMFREE Usenet and Mailing list archive, directory and clipping service
 |
 |