Xref: alice comp.databases.oracle.server:26516
Path: alice!news-feed.fnsi.net!priori!news.he.net!news.reference.com!not-for-mail
From: mjain@bigfoot.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Starting Database using Cron
Date: 8 Aug 1998 15:07:25 GMT
Organization: Reference.Com Posting Service
Lines: 79
Message-ID: <6qhpjd$lhs$1@orthanc.reference.com>
References: <35CBB084.83CDA39E@interramp.com> <6qgm5h$ei6$1@orthanc.reference.com> <35cbeca8.1884888@news.gironet.nl>
Cc: schluck@gironet.nl, usb00335@interramp.com, mayaora@hotmail.com
X-Originating-Host: 1cust136.tnt6.redmond.wa.da.uu.net
Originator: panuser@reference.com ()


---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@gironet.nl (Paul Schluck) wrote:
> On 8 Aug 1998 05:02:41 GMT, mjain@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@gironet.nl)




  -------------------------------------------------------------------- 
  Posted using Reference.COM                  http://WWW.Reference.COM 
  FREE Usenet and Mailing list archive, directory and clipping service 
  --------------------------------------------------------------------