Re: Oracle shutdown on Wintel

From: MJ Mody <emjay.mody_at_gmail.com>
Date: Tue, 16 Feb 2016 13:57:35 -0600
Message-Id: <687A7D44-54FB-4FA6-80F9-40DDE7056A50_at_gmail.com>

Oracle on Wintel has Administrative Assistant for Windows which allows one to configure startup/shutdown options.

We have a custom shutdown script that is implemented by way of GPO that shows in gpedit.msc > computer configuration > windows settings > scripts > shutdown

The content of the script is a simple

   net stop oracleserviceORCL > serviceshut.log

All of this is contingent on the admin asst for win to be configured to perform the preferred shutdown option.

Cheers
MJ

> On Feb 16, 2016, at 1:25 PM, Mark W. Farnham <mwf_at_rsiz.com> wrote:
>
> I have always considered it a useful practice to stop Oracle before pulling the rug out from under it.
>
> Not that you really need to, because as was noted earlier in the thread crash recovery *should* work just fine.
>
> However, where a standard prelude to OS shutdown includes an Oracle shutdown (possibly immediate or abort); startup restrict; shutdown (normal), then the restart after reboot is as fast as it can been, and if an all storage snapshot or backup is taken before the OS restart you’ve got something to which no recovery need be applied.
>
> So plus one to Martin’s practice. (You do probably need a bailout in case there is a long running transaction or rollback in progress that eat up too much of the planned patching window.)
>
> mwf
>
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Herbener, Martin - Division of Engineering and Management
> Sent: Tuesday, February 16, 2016 12:14 PM
> To: Oracle-L_at_freelists.org
> Subject: Re: Oracle shutdown on Wintel
>
> Daniel Hubler,
>
> The behavior you describe does indeed seem to be standard for Oracle on Windows (it’s described further in 309230.1). As part of migrating to 12c we did some mitigation by implementing a Windows shutdown script that shuts down the Oracle Windows service before the OS actually quits. This was not my idea – there are other discussions of this out there in the www – but I didn’t make a note of original writer.
>
> I can share the specific script/configuration we used if you want it.
>
> Martin
>
>
> Martin Herbener
> Kentucky Department of Education
> 502 564 2020
>
> KDE on Facebook: www.facebook.com/kydeptofed
> KDE on Twitter: twitter.com/KyDeptofEd
>

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

Received on Tue Feb 16 2016 - 20:57:35 CET