Re: RE Startup on boot

Dave Morgan wrote:

> We have automated start scripts and I feel it is part of the job
> to take calls at 3 AM to do starts. Also , the sysadmins I trust have
> been shown how to start oracle. (NOT how to STOP oracle).

You *must* also show them how to shut Oracle down cleanly, and make sure that they always do it. Traditional sysadmins tend to type things like:

# sync; sync; sync; poweroff

Which simply dumps the OS disk cache (VERY different to the SGA) to disk, kills every process without warning, and switches off the entire machine. This is because ordinary Unix daemons, such as FTP servers and the like, don't mind that sort of behavior.

(Note: I have no idea why they sync three times, but every sysadmin  I've ever met does. I've checked, and a single time would be enough.  Must be some weird tribal tradition.)

g

-- 
guy ruth hammond <grh_at_agency.com> | One is punished for being
Technology Analysis & Consulting  | weak, not for being cruel.
07879607148 http://www.agency.com |       -- Baudelaire