RE: Automatic startup of pluggable databases - why not the default?
Date: Fri, 24 Jul 2015 15:17:44 +0100
Message-ID: <EC65ECF8123FEE4D8FC5B212637C304001674D209F69_at_EXCH1.morrisonsplc.co.uk>
Yes I agree Brent that is the workaround that the changes in 12.1.0.2 were meant to address. I am interested in understanding why it was not seen as reasonable to start the pdb databases up after a container restart
John
From: Brent Day [mailto:coloradodba_at_gmail.com]
Sent: 24 July 2015 15:15
To: John Hallas
Cc: oracle-l_at_freelists.org
Subject: Re: Automatic startup of pluggable databases - why not the default?
You could create a database trigger after startup that has the following
execute immediate 'alter pluggable database all open';
Brent
On Fri, Jul 24, 2015 at 6:18 AM, John Hallas <John.Hallas_at_morrisonsplc.co.uk<mailto:John.Hallas_at_morrisonsplc.co.uk>> wrote:
Now 12.1.0.2 allows you to save a state in advance using ‘alter pluggable database xxx save state’ which does seem a step forward
However why would the default not be to start all the pluggable databases (or services as they are seen) not leave them in a mounted state. Obviously Oracle have thought about this and changed the trigger method, maybe due to customer feedback but I wonder why they have not gone the whole hog and started the services automatically.
Wm Morrison Supermarkets Plc is registered in England with number 358949. The registered office of the company is situated at Gain Lane, Bradford, West Yorkshire BD3 7DL. This email and any attachments are intended for the addressee(s) only and may be confidential.
If you are not the intended recipient, please inform the sender by replying to the email that you have received in error and then destroy the email. If you are not the intended recipient, you must not use, disclose, copy or rely on the email or its attachments in any way.
This email does not constitute a contract in writing for the purposes of the Law of Property (Miscellaneous Provisions) Act 1989.
Our Standard Terms and Conditions of Purchase, as may be amended from time to time, apply to any contract that we enter into. The current version of our Standard Terms and Conditions of Purchase is available at: http://www.morrisons.co.uk/gscop
Although we have taken steps to ensure the email and its attachments are virus-free, we cannot guarantee this or accept any responsibility, and it is the responsibility of recipients to carry out their own virus checks.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 24 2015 - 16:17:44 CEST