RE: To autostart database or not?
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <Jay.Miller@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 May 2007 15:58:36 -0400
I wrote a custom script here for the sa... one stop shopping for
shutting and starting everything on any server for patching etc.
Operates of of a custom environment setting script and oratab. It will
operate on all or any listener, database, agent, and all Oracle managed
services. I desired he can exclude any with oratab.
Works for me.... he was getting frustrated with all of the details that
varied not only among oracle servers, but other applications as well,
and dependent databases.
For individual ones . oraenvset SID sqlplus...
Never called me since. Logs everything to screen and disk.
Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904 727-2546
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Jay.Miller@xxxxxxxxxxxxxxxx
Sent: Thursday, May 10, 2007 3:18 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: To autostart database or not?
We used to have our SAs restart using a script until the day the standby
database server crashed and they used the regular database startup
script to restart it.
After that we asked to be called.
Jay Miller
Sr. Oracle DBA
x68355
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Luis Fernando Cerri
Sent: Thursday, May 10, 2007 1:54 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: To autostart database or not?
Why not give the SA the minimum knowledge to use dbshut/dbstart and
always update your /etc/oratab when you create, update or remove an
instance? I've worked this way for years and SAs always did a good
job. Of course I always change the shutdown method to immediate on
dbshut.
If I cannot trust that Oracle do a minimum quality health-check at
startup I should not sleep by other reasons.
Just my thinking.
Best regards,
Cerri
2007/5/10, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante@xxxxxxxxxxxxxxxxx>:
> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dwayne Cox
> Sent: Thursday, May 10, 2007 8:38 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxx
>
> --
> //www.freelists.org/webpage/oracle-l
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
