Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE Startup on boot
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: root_at_fatcity.com [mailto:root_at_fatcity.com]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 recovery? 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
--
Dave Morgan
Senior Database Administrator
Internet Barter Inc.
www.bartertrust.com
408-910-4183
--
Author: Dave Morgan
INET: dmorgan_at_bartertrust.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message