Re: Oracle database on Azure - suggestions and best practices

  • From: Tim Gorman <tim.evdbt@xxxxxxxxx>
  • To: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
  • Date: Fri, 7 May 2021 14:39:51 -0700

Azure vCPUs are CPU hyperthreads, which are either 1 (disabled) or 2.  The memory-optimized VM instance types I recommended for use with Oracle use HT=2, so each vCPU is 0.5 CPU core.  There are some VM instance types (usually compute optimized) with HT=1 (no hyperthreading).  Either way, one Oracle license core is either one or two vCPUs in Azure.  Oracle essentially says the same thing HERE <https://www.oracle.com/assets/cloud-licensing-070579.pdf>.

So if you provision a Standard_E16s_v4 instance type VM in Azure, you'll need to get licensing and support for 16 vCPUs or 8 cores.  It is totally up to the customer to be licensed for all software used on the VM.



On 5/7/2021 8:26 AM, Chris Taylor wrote:

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 <tim.evdbt@xxxxxxxxx <mailto:tim.evdbt@xxxxxxxxx>> wrote:

    Great point, Jeremiah!

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

    On May 7, 2021, at 4:53 AM, Radoulov, Dimitre<cichomitiko@xxxxxxxxx>  
<mailto:cichomitiko@xxxxxxxxx>  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

    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
    mike@xxxxxxxxxxx  <mailto:mike@xxxxxxxxxxx>
On 5/7/21, 6:40 AM, "Radoulov, Dimitre"<oracle-l-bounce@xxxxxxxxxxxxx on behalf of cichomitiko@xxxxxxxxx> <mailto:oracle-l-bounce@freelists.orgonbehalfofcichomitiko@xxxxxxxxx> 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

         --
         //www.freelists.org/webpage/oracle-l  ;
<//www.freelists.org/webpage/oracle-l>




    --
    //www.freelists.org/webpage/oracle-l  ;
<//www.freelists.org/webpage/oracle-l>


    --
    //www.freelists.org/webpage/oracle-l  ;
<//www.freelists.org/webpage/oracle-l>




Other related posts: