Re: Oracle database on Azure - suggestions and best practices

Most Oracle licensing agreements make no mention of Azure oCPUs, AWS vCPUs or similar. The count is per core and depends on processor model. For AWS, there's a handy conversion chart here:

https://aws.amazon.com/ec2/physicalcores/

To get processor types, models, specs, you can look here:

https://aws.amazon.com/ec2/instance-types/

I am quite sure the other cloud providers have similar documentation.

Also of note, AWS RDS has provided certain optimizations that may help some Oracle customers manage costs: https://aws.amazon.com/blogs/database/new-features-to-reduce-and-optimize-vcpus-on-amazon-rds-for-oracle-data/

Jeremiah

From: "Chris Taylor" <christopherdtaylor1994_at_gmail.com> To: "Tim Gorman" <tim.evdbt_at_gmail.com> Cc: "Jeremiah Cetlin Wilton" <jcwilton93_at_earlham.edu>, cichomitiko_at_gmail.com, "Michael Gangler" <mjgangler_at_yahoo.com>, "Oracle Mailing List" <oracle-l_at_freelists.org> Sent: Friday, May 7, 2021 8:26:23 AM
Subject: Re: Oracle database on Azure - suggestions and best practices

That's an interesting point, so now I have some questions.

Let's say I want to move my application running on Oracle hardware in-house to Azure (as an example).

I know in Oracle cloud , they use OCPUs and you pay for 'x' amount of steady state OCPus and then have bursting capability that you can pay extra for if you need to boost up CPU resources temporarily.

What I'm now curious about is how you determine on non-Oracle cloud how many "CPUs" you need, how many "CPUs" you actually use. Does Oracle have any ability to audit your CPU usage in someone else's cloud? How does an Azure guarantee you you're only ever using the CPU counts your licensed for - or is it totally up to the customer to make sure they buy "X" amount of Cloud CPU licenses from Oracle and only ever use that many cloud CPUs ?

Chris

On Fri, May 7, 2021 at 11:19 AM Tim Gorman < [ mailto:tim.evdbt_at_gmail.com | tim.evdbt_at_gmail.com ] > wrote:

Great point, Jeremiah!

Please don't bother asking the cloud provider about Oracle licensing, documents like this [ https://www.oracle.com/assets/cloud-licensing-070579.pdf | HERE

     ] are merely general advisory. Oracle licensing is a contract, negotiated between your company and Oracle, possibly through one or more reseller(s), and the cloud provider has no influence whatsoever in the matter.

On 5/7/2021 6:46 AM, Jeremiah Wilton wrote:

BQ_BEGIN The processor core rules for non-Oracle clouds Oracle puts out are not necessarily part of your license agreement with Oracle. That doc even has some kind of notation like “educational purposes only.” Your license agreement is the final word on how to count cores, regardless of whether you run in or off a cloud service.

Jeremiah

Sent from my iPhone

BQ_BEGIN On May 7, 2021, at 4:53 AM, Radoulov, Dimitre [ mailto:cichomitiko_at_gmail.com | <cichomitiko_at_gmail.com> ] wrote:

Thank you very much Mike!

I'm aware, of course, that Kellyn Potvin contributes to oracle-l and thanks for mentioning her blog, I'll check the Azure related posts. I know that we're supposed to patch our instances by ourselves just like we do on prem.

As a side note: we have a huge number of cloud managed databases on Google and the fact that all the backup and patching related stuff is handled by Google is really great (just like the other cloud vendors database managed solutions, I suppose).

Best regards
Dimitre

BQ_BEGIN On 07/05/2021 13.40, Michael Gangler wrote: Hi Dimitre,

Kellyn Potvin-Gorman who use to work for Oracle and is now works for Microsoft and is the Oracle SME for Azure, has provided great information on setting up Oracle on Azure. I was able to setup a couple Oracle instances and it works great. Please note, though, Oracle in Azure is more IAAS so many of the items such as Oracle patching, etc. will have to be done by you. Her Blog is : [ https://dbakevlar.com/about/ | https://dbakevlar.com/about/ ] Kellyn also follows this site and I'm sure she will also provide more expert than myself. Overall, worked like a charm, good performance and pretty straight forward install.

--Mike

Thank You,
 Mike [ mailto:mike_at_gangler.net | mike_at_gangler.net ] On 5/7/21, 6:40 AM, "Radoulov, Dimitre" [ mailto:oracle-l-bounce_at_freelists.orgonbehalfofcichomitiko_at_gmail.com | <oracle-l-bounce_at_freelists.org on behalf of cichomitiko_at_gmail.com> ] wrote:

    Hello all,

    we have to set up Oracle database on MS Azure. I'm reading various     articles/blog posts on Internet and try to choose the best options for us.     If I understand correctly the licensing is different (one processor     license covers one virtual core, thus the Intel core factor doesn't apply).     RAC isn't supported, but you can deploy Data Guard as HA, and eventually     DR (on a different region), solution.

    We definitely need to patch OS and databases on a regular basis.     We currently don't use the multitentant option, but I suppose that we'll     need to switch to it because the single tenant will be deprecated.

    I don't believe ASM would be more appropriate than XFS with     filesystemio_options set to setall for a single instance.

    It would be really great if you could share your experience, suggestions     and new "best practices" for running an enterprise grade Oracle database     on non-Oracle public cloud.

    Thanks in advance!

    Best regards

    Dimitre

• [ http://www.freelists.org/webpage/oracle-l | http://www.freelists.org/webpage/oracle-l ]
  • [ http://www.freelists.org/webpage/oracle-l | http://www.freelists.org/webpage/oracle-l ]

BQ_END

• [ http://www.freelists.org/webpage/oracle-l | http://www.freelists.org/webpage/oracle-l ]

BQ_END BQ_END
--

http://www.freelists.org/webpage/oracle-l Received on Fri May 07 2021 - 18:37:44 CEST