RE: To autostart database or not?

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Thu, 10 May 2007 08:18:06 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB307EF00E9@x6009a.umb.corp.umb.com>

I really like to have the on call dba bring up instances, especially in the case of a crash. However, I can definitely see in the case of small shop where you might want to let them start automatically. It might also depend on how good the people are that bring up the system. Do they know to call you if there is something strange going on with Oracle?

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F (LABOR)
Sent: Thursday, May 10, 2007 7:59 AM
To: dwaynec_at_infotechfl.com; oracle-l_at_freelists.org Subject: RE: To autostart database or not?

Dwayne,

You are not being over-controlling if you want to be called to come in every time the server burps. That is the only issue.

Personally, I do not want to be called. Let Oracle come up by itself and only call me if it fails to start.

Tom

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dwayne Cox Sent: Thursday, May 10, 2007 8:38 AM
To: oracle-l_at_freelists.org
Subject: To autostart database or not?

We are running a few Oracle9i and 10g databases on RHEL and I have always opted NOT to have the databases automatically restart when the server goes down due to something unexpected. My thinking was that if the server crashed, then I want to be there to bring up the databases to

assess and repair any damage (yes, I am the only production DBA).

Am I being overly controlling? Looking for other opinions and thoughts on the matter.

Thanks

--

Dwayne Cox, Corporate DBA
Info Tech, Inc.
dwayne.cox_at_infotechfl.com

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l

---

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

---

--

http://www.freelists.org/webpage/oracle-l Received on Thu May 10 2007 - 08:18:06 CDT