RE: Automatic startup / shutdow Oracle 12c

Happy to be of help where I can, which may not be much for the next few days while I sleep.  Supporting OOW remotely seems more tiring than even being there! 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:20 PM
To: Peter Sharman
Cc: rajendra.pande_at_ubs.com; Markus.Zwettler_at_zuerich.ch; ORACLE-L Subject: Re: Automatic startup / shutdow Oracle 12c

For the record I didn't and don't ever expect you or other employees to comment on Oracle policy, just as I'd never comment publicly on policies of my employers. Apologies if it came across that way. I'm glad that we have you, and other Oracle product people, on the list without us generally pestering you for things like release dates or support.

On Thu, Oct 2, 2014 at 7:06 PM, Peter Sharman <HYPERLINK "mailto:pete.sharman_at_oracle.com"pete.sharman_at_oracle.com> wrote:

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: +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: Niall Litchfield [mailto:HYPERLINK "mailto:niall.litchfield_at_gmail.com"niall.litchfield_at_gmail.com] Sent: Friday, October 3, 2014 3:02 AM
To: Pete Sharman
Cc: HYPERLINK "mailto:rajendra.pande_at_ubs.com"rajendra.pande_at_ubs.com; HYPERLINK "mailto:Markus.Zwettler_at_zuerich.ch"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: HYPERLINK "tel:%2B61262925183"+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 




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


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