Re: UNIX System Database Startup Script

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Mon, 11 Jun 2007 16:44:38 -0700
Message-ID: <1181605478.435009.43520@g4g2000hsf.googlegroups.com>

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

We like to use our own scripts that start/stop Oracle via SQLPlus because we pin certain packages in the shared pool on instance startup as well as run a verification routine that reports the status of specific items. What we do varies by database so using our own script gives us better control.

You can run your own script via rcd for auto-start/shutdown or manually as needed. If you have no special needs then the oratab file along with rcd is all you need.

HTH -- Mark D Powell -- Received on Mon Jun 11 2007 - 18:44:38 CDT