RE: Automatic startup / shutdow Oracle 12c

From: Peter Sharman <pete.sharman_at_oracle.com>
Date: Thu, 2 Oct 2014 11:06:51 -0700 (PDT)
Message-ID: <9b5f3c70-c219-4f09-8079-93910a62968c_at_default>



Can’t really comment on it being a mistake Niall, for obvious reasons. J

 

One comment I would add though is I do see more people installing GI in single instance environments so they get ASM.  And if they’ve done that, they get Restart as a bonus. J

 

Pete

Pete Sharman
Database Architect, DBaaS
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA

Phone: HYPERLINK "tel:+61262924095"+61262924095 | | Fax: HYPERLINK "fax:+61262925183"+61262925183 | | Mobile: +61414443449 

  _____  

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

 

"Oh no, it's not, it's much harder than that!"

Bruce Pihlamae, long term Oracle DBA

  _____  

 

From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Sent: Friday, October 3, 2014 3:02 AM
To: Pete Sharman
Cc: rajendra.pande_at_ubs.com; Markus.Zwettler_at_zuerich.ch; ORACLE-L Subject: Re: Automatic startup / shutdow Oracle 12c

 

Well I'd wonder hard about that particular one because Oracle Restart was only introduced with 11.2 and is already "deprecated". I don't imagine it will be around for as long as SQL*DBA was. Its a pretty clear signal that someone up there thinks it was a mistake. Learning how to work with your O/S to manage system services the O/S way seems to me the "right" thing to do here.

In addition I'm not sure I'd necessarily expect everyone with single instance databases to have installed Grid Infrastructure to start with..

 

On Wed, Oct 1, 2014 at 6:51 PM, Peter Sharman <HYPERLINK "mailto:pete.sharman_at_oracle.com"pete.sharman_at_oracle.com> wrote:

True, but a “future release” can be many years away.  Anyone else remember how long we were told SQL*DBA was gonna go away? ;)

 

Seriously, Restart is there and working with the Grid Infrastructure now, it took me less than half a day to get it installed and working, so why would you worry about the normal warning we give well in advance of desupport of something?  Deprecation and desupport mean two very different things.

 

It even forces you to do things the “right” way.  On my small test environment I ran out of memory with too many databases, so I tried to kill one off with a “kill -9” of PMON (my usual quick and dirty way) and the damn thing restarted on me!  LOL – had to really do the shutdown from SQL*Plus as I should have! J

 

Pete

Pete Sharman
Database Architect, DBaaS
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA

Phone: HYPERLINK "tel:+61262924095"+61262924095 | | Fax: +61262925183 | | Mobile: HYPERLINK "tel:%2B61414443449"+61414443449 

  _____  

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

 

"Oh no, it's not, it's much harder than that!"

Bruce Pihlamae, long term Oracle DBA

  _____  

 

From: HYPERLINK "mailto:rajendra.pande_at_ubs.com"rajendra.pande_at_ubs.com [mailto:HYPERLINK "mailto:rajendra.pande_at_ubs.com"rajendra.pande_at_ubs.com] Sent: Wednesday, October 1, 2014 9:54 PM To: HYPERLINK "mailto:Markus.Zwettler_at_zuerich.ch"Markus.Zwettler_at_zuerich.ch; HYPERLINK "mailto:oracle-l_at_freelists.org"oracle-l_at_freelists.org Subject: RE: Automatic startup / shutdow Oracle 12c

 

Seriously !!

 

I mean of course if there is no option then I guess in desperation – yes. But…

 

On the very page that you referenced –it says

          Starting with Oracle Database 12c, Oracle Restart is deprecated and is subject to desupport in future releases.

 

Regards

 

 

From: HYPERLINK "mailto:oracle-l-bounce_at_freelists.org"oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zwettler Markus (OIZ) Sent: Wednesday, October 01, 2014 7:25 AM To: ORACLE-L
Subject: AW: Automatic startup / shutdow Oracle 12c

 

You might configure Oracle Restart with 12c.

 

http://docs.oracle.com/database/121/ADMIN/restart.htm#ADMIN12709

 

Cheers, Markus

 

 

 

Von: HYPERLINK "mailto:oracle-l-bounce_at_freelists.org"oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] Im Auftrag von Eriovaldo Andrietta Gesendet: Dienstag, 30. September 2014 20:11 An: ORACLE-L
Betreff: Automatic startup / shutdow Oracle 12c

 

Hi, 

 

Does anyone knows how to configure the automatic startup / shutdown in Oracle 12c  for Linux?

 

I am talking about the resource used when we do the boot in the server and wants the database (container and plugable)  on line without execute the startup manualy.

 

Best regards

Eriovaldo

 

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info 


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 02 2014 - 20:06:51 CEST

Original text of this message