Re: oracle on EC2
Date: Tue, 12 Jan 2016 11:13:50 -0600
Message-ID: <CAEueRAWA4d0AgKg7dRuGDx-vf0cHiWrWpvF5NMZLvzVACeC_Zg_at_mail.gmail.com>
I disagree. Non-rolling patches like OJVM are quite rare.
Would you choose not to use RAC based on this one exception?
Seth Miller
On Tue, Jan 12, 2016 at 8:57 AM, Adric Norris <landstander668_at_gmail.com> wrote:
> Provided that you don't include the OJVM PSU. That's a pretty big caveat,
> IMO.
>
> On Tue, Jan 12, 2016 at 8:42 AM, Seth Miller <sethmiller.sm_at_gmail.com>
> wrote:
>
>> Rolling patching.
>>
>> Seth Miller
>>
>> On Mon, Jan 11, 2016 at 10:37 PM, Andrew Kerber <andrew.kerber_at_gmail.com>
>> wrote:
>>
>>> Yes, I can understand how it can be done. But I can't think of any
>>> reason why.
>>>
>>> Sent from my iPad
>>>
>>> On Jan 11, 2016, at 10:25 PM, Thomas Roach <troach_at_gmail.com> wrote:
>>>
>>> Here is a document from Oracle about running RAC in public clouds.
>>>
>>>
>>> http://www.oracle.com/technetwork/database/options/clustering/overview/rac-cloud-support-2843861.pdf
>>>
>>> Sent from my iPhone
>>>
>>> On Jan 11, 2016, at 8:06 PM, Andrew Kerber <andrew.kerber_at_gmail.com>
>>> wrote:
>>>
>>> I just can't think of a use case of RAC on EC2. Can someone enlighten
>>> me.
>>>
>>> Sent from my iPad
>>>
>>> On Jan 11, 2016, at 9:17 PM, Jeremiah Wilton <jcwilton93_at_earlham.edu>
>>> wrote:
>>>
>>> I wrote this to help people who want to see if RAC on EC2 will work for
>>> them.
>>>
>>> https://aws.amazon.com/articles/7455908317389540
>>>
>>> Jeremiah
>>>
>>> Sent from my iPhone
>>>
>>> On Jan 11, 2016, at 7:12 PM, soumya das <soumya2home_at_gmail.com> wrote:
>>>
>>> Hi guys,
>>>
>>> Thanks for all the valuable input. I have a question even though its not
>>> entirely related to subject. Is it possible to create a RAC setup on ec2 ?
>>> I did few googling and found that aws still doesnt support it. Has anyone
>>> of you tried it or have any clear picture on this? If you do please share
>>> your opinion.
>>> Thanks,
>>>
>>> Soumya
>>>
>>> On Tue, Jan 12, 2016 at 1:10 AM, Jeremiah Cetlin Wilton <
>>> jcwilton93_at_earlham.edu> wrote:
>>>
>>>> Right.
>>>>
>>>> This is the license-related doc:
>>>>
>>>> http://www.oracle.com/us/corporate/pricing/cloud-licensing-070579.pdf
>>>>
>>>> These are the docs to address the hypervisor support issue:
>>>>
>>>> https://support.oracle.com/epmos/faces/DocumentDisplay?id=1901155.1
>>>>
>>>> http://aws.amazon.com/articles/7455908317389540#FAQ1
>>>>
>>>> Jeremiah
>>>>
>>>> ------------------------------
>>>> *From: *"Seth Miller" <sethmiller.sm_at_gmail.com>
>>>> *To: *"Jeremiah Cetlin Wilton" <jcwilton93_at_earlham.edu>
>>>> *Cc: *"max scalf" <oracle.blog3_at_gmail.com>, "Oracle Mailing List" <
>>>> oracle-l_at_freelists.org>, "Maris Elsins" <elmaris_at_gmail.com>
>>>> *Sent: *Monday, January 11, 2016 11:15:16 AM
>>>> *Subject: *Re: oracle on EC2
>>>>
>>>> Neither of these links reference licensing.
>>>>
>>>> Seth Miller
>>>>
>>>> On Mon, Jan 11, 2016 at 12:55 PM, Jeremiah Cetlin Wilton <
>>>> jcwilton93_at_earlham.edu> wrote:
>>>>
>>>>> Not really. There's also a doc for that :-)
>>>>>
>>>>> https://support.oracle.com/epmos/faces/DocumentDisplay?id=1901155.1
>>>>>
>>>>> I talk about it a little bit here:
>>>>>
>>>>> http://aws.amazon.com/articles/7455908317389540#FAQ1
>>>>>
>>>>> Jeremiah
>>>>>
>>>>> ------------------------------
>>>>> *From: *"Seth Miller" <sethmiller.sm_at_gmail.com>
>>>>> *To: *"Jeremiah Cetlin Wilton" <jcwilton93_at_earlham.edu>
>>>>> *Cc: *"max scalf" <oracle.blog3_at_gmail.com>, "Oracle Mailing List" <
>>>>> oracle-l_at_freelists.org>, "Maris Elsins" <elmaris_at_gmail.com>
>>>>> *Sent: *Monday, January 11, 2016 10:50:36 AM
>>>>>
>>>>> *Subject: *Re: oracle on EC2
>>>>>
>>>>> Does this mean that you have to make sure you are running EC2
>>>>> instances in an Oracle VM hypervisor?
>>>>>
>>>>> Seth Miller
>>>>>
>>>>> On Mon, Jan 11, 2016 at 12:27 PM, Jeremiah Cetlin Wilton <
>>>>> jcwilton93_at_earlham.edu> wrote:
>>>>>
>>>>>> There's a doc for that:
>>>>>>
>>>>>> http://www.oracle.com/us/corporate/pricing/cloud-licensing-070579.pdf
>>>>>>
>>>>>> Jeremiah
>>>>>>
>>>>>> ------------------------------
>>>>>> *From: *"Seth Miller" <sethmiller.sm_at_gmail.com>
>>>>>> *To: *elmaris_at_gmail.com
>>>>>> *Cc: *"max scalf" <oracle.blog3_at_gmail.com>, "Oracle Mailing List" <
>>>>>> oracle-l_at_freelists.org>
>>>>>> *Sent: *Monday, January 11, 2016 10:20:28 AM
>>>>>> *Subject: *Re: oracle on EC2
>>>>>>
>>>>>> Maris,
>>>>>>
>>>>>> How are you licensing these databases?
>>>>>>
>>>>>> Seth Miller
>>>>>>
>>>>>> On Mon, Jan 11, 2016 at 9:29 AM, Maris Elsins <elmaris_at_gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> We're running a configuration that addresses some of your IOPS
>>>>>>> concerns and it's basically one of the architectures from this whitepaper
>>>>>>> https://d0.awsstatic.com/whitepapers/aws-advanced-architectures-for-oracle-db-on-ec2.pdf
>>>>>>>
>>>>>>> - We have created our EC2 for Oracle DBs using Oracle Linux 6
>>>>>>> (requirement for Oracle Smart Flash Cache)
>>>>>>> - We've set up ASM on multiple provisioned IOPS EBS volumes (SSD)
>>>>>>> for striping
>>>>>>> - We've enabled Oracle Smart Flash Cache on part of the ephemeral
>>>>>>> instance store SSD (it doesn't have even the tiny network latency that EBS
>>>>>>> volumes have, as they are local). And based on the AWR reports we see this
>>>>>>> works very well. And in fact with larger EC2 instances one gets plenty of
>>>>>>> instance store SSDs that otherwise are of no big use.)
>>>>>>> - We don't rely on EBS volumes' snapshots for backups, as we have a
>>>>>>> DataGuard set up and when needed we stop the recovery there and take
>>>>>>> snapshots from it (for cloning purposes usually). I'd think this would also
>>>>>>> work with "ALTER DATABASE BEGIN/END BACKUP" + simultaneous snapshot of all
>>>>>>> striped EBS volumes too.
>>>>>>> - We take regular RMAN backups for point in time recovery
>>>>>>> requirements.
>>>>>>>
>>>>>>> May be this is not exactly what you were looking for as you provided
>>>>>>> a link related to RAID configurations, but probably you can still extract
>>>>>>> something useful from what I wrote.
>>>>>>>
>>>>>>> regards,
>>>>>>>
>>>>>>> ---
>>>>>>> Maris Elsins
>>>>>>> _at_MarisElsins <https://twitter.com/MarisElsins>
>>>>>>> www.facebook.com/maris.elsins
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Mon, Jan 11, 2016 at 4:44 PM, max scalf <oracle.blog3_at_gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hello all,
>>>>>>>>
>>>>>>>> This question is related to running oracle database on Amazon Web
>>>>>>>> Service. Just so i respect everyone's time on here, I would say please
>>>>>>>> ignore this question if you do not work with AWS.
>>>>>>>>
>>>>>>>> We are running oracle some 11g and 12c database on AWS EC2 server.
>>>>>>>> Most of the server have anywhere from 2 -8 EBS Volume attached(general
>>>>>>>> purpose SSD), they are NOT striped or mirrored. Lately we have been seeing
>>>>>>>> some performance issue(year end closing) with high IO wait time(60-80 ms
>>>>>>>> per read), for some mission critical application we have moved the EBS
>>>>>>>> volumes from general purpose SSD to Provisioned IOPS(PIOPS) and everything
>>>>>>>> seems happy. But now we are coming back to some of the other application
>>>>>>>> and our sysadmin says instead of moving everything from general purpose
>>>>>>>> volumes to PIOPS we should just strip the volumes to get better
>>>>>>>> performance.
>>>>>>>>
>>>>>>>> I agree with him, but my question if we were to strip the EBS
>>>>>>>> volumes how do we deal with taking EBS Snapshot and managing them. We rely
>>>>>>>> on them for our DR in another region. From what i understand about taking
>>>>>>>> snapshot when your EBS volumes are stripped is that you have to freeze the
>>>>>>>> IO before you do the snapshot to guarantee EBS snapshot consistency, see
>>>>>>>> below link..
>>>>>>>>
>>>>>>>>
>>>>>>>> https://aws.amazon.com/premiumsupport/knowledge-center/snapshot-ebs-raid-array/
>>>>>>>>
>>>>>>>> So i wanted to see what others are doing in the community
>>>>>>>> to achieve higher IOPS and i am sure quite a few ppl are running oracle on
>>>>>>>> AWS and also I wanted to find out when they say "Freeze IO", I am assuming
>>>>>>>> putting database in HOT BACKUP mode is the wrong thing.
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>
>
> --
> "In the beginning the Universe was created. This has made a lot of people
> very angry and been widely regarded as a bad move." -Douglas Adams
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 12 2016 - 18:13:50 CET