RE: To autostart database or not?

From: <Jay.Miller_at_tdameritrade.com>
Date: Fri, 11 May 2007 13:18:50 -0400
Message-ID: <304CF4722010DD4FA19829D09DDB956B21D9F3@prdhswsemlmb01.prod-am.ameritrade.com>

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_at_labor.state.ny.us] Sent: Friday, May 11, 2007 7:51 AM
To: Joel.Patterson_at_crowley.com; lfcerri_at_gmail.com; Miller, Jay Cc: oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joel.Patterson_at_crowley.com
Sent: Friday, May 11, 2007 7:31 AM
To: lfcerri_at_gmail.com; Jay.Miller_at_tdameritrade.com Cc: oracle-l_at_freelists.org
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_at_crowley.com
x72546
904 727-2546

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Luis Fernando Cerri Sent: Thursday, May 10, 2007 3:53 PM
To: Jay.Miller_at_tdameritrade.com
Cc: oracle-l_at_freelists.org
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_at_tdameritrade.com <Jay.Miller_at_tdameritrade.com>:
> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Luis Fernando
Cerri
> Sent: Thursday, May 10, 2007 1:54 PM
> To: oracle-l_at_freelists.org
> 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
>
>
>

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


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

Received on Fri May 11 2007 - 12:18:50 CDT