Oracle Database 18c

Happy New Year 2018!

We all have questions on Oracle Database 18c and its ability to self-drive! I tried to summarize my understanding of Oracle Database 18c and RU/RUR in a blog post here.

What to expect in Oracle Database 18c

“Oracle Database 18c by itself is NOT Self-Driving. It is the Oracle Autonomous Database Cloud Service that brings the “Self-Driving” in 18c. Oracle Database 18c installed on-prem will “drive” pretty much the same as Oracle Database 12c.”

I like the idea of releasing major features more frequently and releasing patches and updates that are smaller in size and easy to test. But, the question still is how many DBAs out there are ready to patch every quarter, even if you are able to automate the patching using OEM and other tools.

Oracle Database on Hyper-scale Public Cloud – License Questions!

We all know, on January 23, 2017, Oracle updated the Licensing Oracle Software in the Cloud Computing Environment document. The gist of the announcement was “When counting Oracle Processor license requirements in Authorized Cloud Environments, the Oracle Processor Core Factor Table is not applicable“. So, if you are running Oracle database on x86 Intel platform on-premise, when moving to AWS or Azure cloud, your available licensed CPUs are cut in half. Read my blog on this topic.

Can I run Oracle RAC on Public Cloud?

The answer is “yes!”. On AWS and Azure (for that matter any public cloud), you could use third party product Flashgrid to make local storage shared on all nodes, and have ASM on top. FlashGrid Storage Fabric turns local drives into shared drives accessible from all nodes in the cluster. The local drives shared via FlashGrid Storage Fabric can be block devices of any type including Elastic Block Storage (EBS) volumes, local SSDs, or LVM volumes. The sharing is done at the block level with concurrent access from all nodes. With ASM, you can choose normal redundancy (two copies) or high redundancy (three copies). I believe, this is the limitation of Flashgrid as of today, you can have up to 3 node RAC using Flashgrid. Read more.

Oracle RAC in AWSOn Oracle cloud, you can have a two node RAC natively using Oracle DBaaS service. If you need bigger capacity servers, Oracle Bare Metal Cloud service is the answer. With Bare Metal Cloud, you can have up to 72 OCPU and 1TB of memory per node. With bare metal also, only two node RAC is possible – no more than two nodes.

What about licensing RAC on Public Cloud?

The Licensing Oracle Software in the Cloud Computing Environment document has a link to “eligible” technologies and products on the cloud (this document also updated on Jan 23, 2017). I see Database SE, SE2, EE, even Partitioning, Advanced Security, Advanced Compression listed, but I do not see Oracle RAC. Does this mean, from a licensing standpoint, Oracle RAC on AWS & Azure using Flashgrid is not allowed?

Note, Oracle’s official document is under review. Hopefully, some clarity comes out in the next few days.

How about In-Memory, Multitenant and Active Dataguard?

I also do not see these technologies listed in the document. So, are these products/technologies not allowed on Azure/AWS? I know technically it is possible to create a Container Database with the In-memory option and Active Dataguard (together or separate) on AWS EC2 or Azure Compute (both IaaS). Question is, am I allowed to do so? Amazon’s own white paper, Oracle Advanced Architectures include Active Dataguard in multiple scenarios. This white paper was published in April 2016 though, much before Oracle updating the Cloud Licensing Document!

Thoughts??