Re: UNIX System Database Startup Script

On Jun 11, 5:19 pm, Michael42 <melliot..._at_yahoo.com> wrote:
> Hello,
>
> I would like to get a consensus of what is currently being used to
> start Oracle 10g databases upon a Sun UNIX system boot.
>
> Like many, in the past I used the legacy /etc/init.d/dbora (which
> calls dbstart\dbshut) and requires entries in the /var/opt/oracle
> file.
>
> At present with approx. 25 databases I use what is found in the
> scripts section here:www.michael-elliott.com (dbctl.sh)
>
> What do you use and why do you prefer it?
>
> Thanks for your feedback,
>
> Michael

While prevailing opinions do blow back and forth like the pirates and Captain Jack many of us who have been around a while don't especially like automated start operations whether it's under unix or windows or whatever.

There are 2 primary complications. First, if you are having power supply problems of any kind ( on UPS bypass with the clock ticking, on generator but gas running empty, substation instability etc ) you don't really want to get partway thru attempted restarts ... get the system bounced again ... start again etc.

Second maybe there are some problems with storage devices whether they are directed attached, NAS, SAN etc and the stability of storage needs to be checked out and diagnosed before attempts are made to use potentially corrupt or unavailable storage.

I think Nuno Suoto ( sp? apologies ) had a fairly recent posting in this area that you may want to look up.

Personally I want to know if and when a database server was re-booted and want to get involved in any assessment of whether we are ready to restart the oracle that any specific server was responsible for.

At the minimum maybe you want to script out some kind of "checking" routine that looks and verifies that all necessary storage appears to be available and ready before invoking any kind of mass restart. Received on Tue Jun 12 2007 - 06:17:33 CDT