Re: Moving 2-node RAC to AWS

I agree with the voices saying "don't even try RAC on AWS/EC2". I've been running Oracle single instance on EC2 for about 6 years now, and in my experience, it's rock-solid. We are mostly on 12.1.0.2, but working on upgrading to 19.12. We have been running on EC2 since at least 11.2.0.4 w/ ASM, and no problems at all.

Also, Oracle licensing limits you to 8 vCPUs (two Oracle licenses) per instance for SE2, and (I think) unlimited, but one Oracle license per 2 vCPUs for EE. (We don't run EE at all, we are only an SE2 shop) so, not 100% certain on EE rules, but I think it's right.

-Mark

On Thu, Nov 18, 2021 at 3:57 PM Ramsankar Cheruvattath < ram.cheruvattath_at_gmail.com> wrote:

> I meant to say *VMWare cloud on AWS *below.
>
> Thanks
> Ramsankar Cheruvattath (Ram)
> 4072096276
>
>
> On Thu, Nov 18, 2021 at 3:52 PM Ramsankar Cheruvattath <
> ram.cheruvattath_at_gmail.com> wrote:
>
>> Hi Sandra
>>
>> Here are couple of good docs you can refer to on setting up Oracle on
>> EC2. It is possible to setup a data guard standby and switchover to it if
>> you are on a compatible OS on premises. As far as RAC is concerned, you can
>> use FlashGrid or VMWare cloud on Oracle.
>>
>>
>> https://docs.aws.amazon.com/whitepapers/latest/oracle-database-aws-best-practices/oracle-database-aws-best-practices.html
>>
>> https://aws.amazon.com/blogs/database/using-amazon-ebs-elastic-volumes-with-oracle-databases-part-3-databases-using-oracle-asm/
>> https://aws-quickstart.github.io/quickstart-oracle-database/
>>
>> Thanks
>> Ramsankar Cheruvattath (Ram)
>>
>> Thanks
>> Ramsankar Cheruvattath (Ram)
>> 4072096276
>>
>>
>> On Thu, Nov 18, 2021 at 2:00 PM Sandra Becker <sbecker6925_at_gmail.com>
>> wrote:
>>
>>> Current OS: RHEL6
>>> Oracle version: 11g (11.2.0.3 and 11.2.0.4)
>>>
>>> We have started a project to move our 50 or so on-prem RAC databases to
>>> AWS EC2 servers. Some use ASM, others do not. (I think the motto of
>>> previous DBAs was "consistency is for the weak.".) We cannot upgrade the
>>> databases (or the OS) due to a host of constraints put on us by the
>>> applications and stakeholders. Using FlashGrid also is out of the question
>>> since it would be an additional software cost.
>>>
>>> I'm looking for good documents to read/follow that would tell us how to
>>> set up ASM on the EC2 instances as well as the best method to move the RAC
>>> databases. Has anyone done this that can point me to good documentation?
>>> I also have some non-RAC databases to move. I was thinking of creating the
>>> standby on the EC2 then doing a switchover during a migration window to
>>> minimize downtime. Is this approach feasible? Would another approach be
>>> preferable?
>>>
>>> Thank you for any suggestions,
>>>
>>> --
>>> Sandy B.
>>>
>>>

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