RE: To autostart database or not?
- From: <Jay.Miller@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 11 May 2007 13:18:50 -0400
Oh, and of course one of the other big reasons to have a customized
script is pinning packages on startup. Though I remember someone
posting a while ago a neat database startup trigger to take care of
that. I keep meaning to switch over to using that method.
Jay Miller
-----Original Message-----
From: Mercadante, Thomas F (LABOR)
[mailto:Thomas.Mercadante@xxxxxxxxxxxxxxxxx]
Sent: Friday, May 11, 2007 7:51 AM
To: Joel.Patterson@xxxxxxxxxxx; lfcerri@xxxxxxxxx; Miller, Jay
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: To autostart database or not?
Me too. Make a copy of the script and put it in a standard directory.
One thing that dbshut & start do not do is start things like the Oracle
agent, listener, Ldap/Oid services, Oem services, Dbconsole/Grid etc.
So I write a script to start all of this stuff as well as the databases.
The SA's run my script during system startup or shutdown.
--------------------------------------------------------
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
Joel.Patterson@xxxxxxxxxxx
Sent: Friday, May 11, 2007 7:31 AM
To: lfcerri@xxxxxxxxx; Jay.Miller@xxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: To autostart database or not?
We never used dbshut without customizing it first. It shutdown aborts
etc., good for SA who reboots server before shuting down database, or a
crash if it is rc3 directories... but for normal use we always seemed to
have to customize it... same for oraenv which be default only sets a
couple variables.
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 Luis Fernando Cerri
Sent: Thursday, May 10, 2007 3:53 PM
To: Jay.Miller@xxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: To autostart database or not?
Thats why I stated to always keep /etc/oratab updated, dbshut and
dbstart are based on it. :-)
Thanks for sharing your experience.
Best regards,
Cerri
2007/5/10, Jay.Miller@xxxxxxxxxxxxxxxx <Jay.Miller@xxxxxxxxxxxxxxxx>:
> 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
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
