Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE Startup on boot

RE: RE Startup on boot

From: Steve Orr <>
Date: Wed, 7 Jun 2000 10:42:23 -0700
Message-Id: <>

YES! Generally, if a production machine is recycled it's either a scheduled event or a catastophe. In either case the DBA should be in the picture. Why spend time automating something that shouldn't happen that often? Especially if it could just create more problems? How hard is it to execute an "automated" start up script to bring up the database, listeners, apps, etc? With a little training and documentation of procedures, even sysadmins can do it!

Steve Orr

-----Original Message-----

From: []On Behalf Of Dave Morgan Sent: Wednesday, June 07, 2000 9:35 AM
To: Multiple recipients of list ORACLE-L Subject: RE Startup on boot

Hi all,

        We never start our production Oracle in the boot scripts.

	What happens if the machine crashes and Oracle needs

	What happens if you were taking online backups, the machine
	crashes and Oracle needs recovery?

	If you are running parallel server and both (or more) nodes are brought
	up at the same time (inexperienced sysadmin) you will run into
	contention problems as the instances will fight over who is the master.

	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).

	The answer to all of the What happens is you have created trouble for
	your sysadmin, yourself and your clients.

	And I only work 35 hours a week. I am paid for what I know, and to pass
	that knowledge onto others (So I don't have to take calls at 3 AM :)


Dave Morgan
Senior Database Administrator
Internet Barter Inc.

Author: Dave Morgan

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jun 07 2000 - 12:42:23 CDT

Original text of this message