Oracle Database Cloud Service

In this episode, hosts Lois Houston and Nikita Abraham are joined once again by Alex Bouchereau to discuss how you can use Oracle Database Cloud Service to deploy Oracle Databases in the cloud. They also talk through the fundamentals of Oracle Cloud Infrastructure database system instances, including bare metal and virtual machine shapes and their storage architecture.   Oracle MyLearn: https://mylearn.oracle.com/ Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ Twitter: https://twitter.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Deepak Modi, Ranbir Singh, and the OU Studio Team for helping us create this episode.   --------------------------------------------------------   Episode Transcript:   http://traffic.libsyn.com/oracleuniversitypodcast/Oracle_University_Podcast_S02_EP04.mp3     00;00;00;00 - 00;00;38;21 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let's get started. Hello and welcome to the Oracle University Podcast. I'm Lois Houston, Director of Product Innovation and Go to Market Programs with Oracle University, and with me is Nikita Abraham, Principal Technical Editor.   00;00;38;22 - 00;01;07;29 Hi, everyone. In our last episode, we discussed Oracle Exadata Cloud Service with our Oracle Database Specialist Alex Bouchereau. If you missed that episode, please remember to go back and give it a listen. We're so excited to have Alex with us again and today she's going to talk about the fundamentals of OCI database system instances on Oracle Cloud Infrastructure. We'll also ask her about the DB system for bare metal and virtual machine shapes.   00;01;08;02 - 00;01;40;22 Hi, Alex. Can you tell us about the Oracle Database Cloud Service? Oracle Database Cloud Service provides you the ability to deploy Oracle databases to the cloud. You can deploy Enterprise Edition or Standard Edition 2 and any database version from 11.2 and later. You have the option to deploy using virtual machine or bare metal shapes. Database Cloud Service VM and BM metal DB systems are deployed in Oracle Cloud Infrastructure regions around the world.   00;01;40;24 - 00;02;12;01 With Database Cloud Service, you manage the database instance, including provisioning, patching, backup, and disaster recovery using OCI cloud automation tools, such as the OCI console, CLI, and API. There is also an SDK that supports a number of different languages. Using VM shapes, you can deploy real application clusters and scale your storage requirements. Walk us through the various Oracle database editions. You know, from Standard Edition 2 to Enterprise Edition Extreme Performance.   00;02;12;03 - 00;02;37;15 What are the key differences in terms of features, add-ons, and licensing options? Beginning with Standard Edition 2, features included with the service are Multitenant Pluggable Database and Tablespace Encryption. Moving to Enterprise Edition, you add additional database features, such as data guard and the EM packs of data masking and subsetting, tuning, and diagnostics.   00;02;37;17 - 00;03;14;06 With Enterprise Edition High Performance, in addition to the base Enterprise Edition, you add Management and Lifecycle Management packs as well as Advanced Security and Database Vault and Label Security. And finally, Enterprise Edition Extreme Performance has all the previously discussed features, plus Active Data Guard, Oracle RAC, and Database In-Memory. Note that all packages include Oracle Database Transparent Data Encryption, TDE. You have an option to bring your own license, BYOL, which means you could use your organization's existing Oracle Database software licenses.   00;03;14;12 - 00;03;44;27 What's the difference between bare metal instances and virtual machines in the context of Oracle Cloud Infrastructure? OCI is the only public cloud that supports BM and VMs during the same set of APIs, hardware, firmware, software stack, and networking infrastructure. Bare metal instances are single tenant and you have full control over the resources provisioned within the service. Virtual machines follow a multitenant model and share servers that are not overprovisioned.   00;03;45;00 - 00;04;11;00 So how is the customer billed for these services? For databases using bare metal and virtual machine infrastructure, Oracle Cloud Infrastructure uses per second billing. This means that OCPU and storage usage is billed by the second with a minimum usage period of one minute for virtual machine DB systems and one hour for bare metal DB systems.   00;04;11;00 - 00;04;39;29 For bare metal servers, there is an infrastructure charge along with the billing for OCPUs. Alex, can DBCS be customized? I mean, are there different kinds of DBCS offerings to fulfill the various needs of our customers? The maximum number of OCPUs, RAM, and storage for your database depends on the shape you choose. There are two types of DB systems on virtual machines. Single node or one-node virtual machine DB system consists of one virtual machine.   00;04;40;02 - 00;05;13;27 Two-node virtual machine DB systems consist of two virtual machines of separate servers. Virtual machine DB systems use Oracle Cloud Infrastructure block storage. Bare metal systems used NVMe local storage and are therefore not scalable. Storage scaling is available for all VM shapes. Online OCPU scaling is available for bare metal systems or for two-node RAC VMs. Alex, help us understand what Database Cloud Service on bare metal is.   00;05;13;29 - 00;05;43;07 How does it differ from other Oracle Database Service offerings? Database Cloud Service on bare metal is a database service offering that enables customers to deploy and manage full-featured Oracle databases on bare metal servers. Bare metal offers proven and predictable performance with local NVMe storage on dedicated servers that provide high IOPS with extremely low latency. Bare metal DB systems consist of a single bare metal server running Oracle Linux with locally attached NVMe storage.   00;05;43;07 - 00;06;11;25 If the node fails, you can simply launch another system and restore the databases from current backups. Bare metal DB system provide dedicated resources that are ideal for databases that are performance intensive. And how do you start a bare metal instance? When you launch a bare metal DB system, you select the single Oracle Database edition that applies to all the databases on that DB system.   00;06;11;28 - 00;06;49;08 The selected edition cannot be changed. Each DB system can have multiple database homes, which can be different versions. Each database home can have multiple databases, which are, of course, the same version as the database home. Are you attending Oracle CloudWorld 2023? Learn from experts, network with peers, and find out about the latest innovations when Oracle CloudWorld returns to Las Vegas from September 18 through 21. CloudWorld is the best place to learn about Oracle solutions from the people who build and use them.   00;06;49;12 - 00;07;17;22 In addition to your attendance at CloudWorld, your ticket gives you access to Oracle MyLearn and all of the cloud learning subscription content as well as three free certification exam credits. This is valid from the week you register through 60 days after the conference. So what are you waiting for? Register today. Learn more about Oracle CloudWorld at www.oracle.com/cloudworld.   00;07;17;24 - 00;07;46;08 Welcome back. Alex, can you explain how Automatic Storage Management interfaces with disks in OCI? ASM directly interfaces with the disks. When you provision a bare metal system, you will indicate the data storage percentage assigned to data storage, which is user data and database files. Your choice is 40% or 80%. The remaining percentage is assigned to RECO storage consisting of database redo logs, archive logs, and recovery manager backups.   00;07;46;08 - 00;08;20;14 Storage is continuously monitored for any faults. Any disk that fails will be taken offline. Whenever the shapes list a maximum amount of usable space and data in RECO, these reservations for rebalancing are already taken into account. The root user has complete control over the storage subsystem so customization and tuning are possible. But the service already optimally configures these by default according to best practices.   00;08;20;18 - 00;08;58;20 So what are the key benefits of running databases on virtual machines? Database Service on VMs is a Database Service offering that enables customers to build, scale, and manage full-featured Oracle databases on virtual machines. The key benefits of running databases on VMs are cost-effectiveness, ease of getting started, durable and scalable storage, and the ability to run real application clusters, RAC, to improve availability. Database Cloud Service on VMs is built on the same high performance, highly available cloud infrastructure used by all Oracle Cloud Infrastructure services.   00;08;58;22 - 00;09;23;21 RAC databases will run on a single availability domain (AD) while ensuring each node is on a separate physical RAC, ensuring high availability. When you launch a virtual machine DB system, you select the Oracle Database edition and version that applies to the database on that DB system. The selected edition cannot be changed. Depending on your selected Oracle database edition and version, your DB system can support multiple pluggable databases, PDBs.   00;09;23;28 - 00;09;59;17 Are there various kinds of compute shapes available with DBCS? Virtual machine database systems offer compute shapes with 1 to 24 cores to support customers with small to large database processing requirements. A virtual machine DB system database uses Oracle Cloud Infrastructure block storage instead of local storage. You specify a storage size when you launch the DB system, and you can scale up the storage as needed at any time.   00;09;59;17 - 00;10;27;26 On-demand up and down scaling of database OCPUs use without interrupting database operations on two-node Oracle Real Application Cluster deployments allows customers to meet application needs while minimizing costs. To change to the number of CPU cores on an existing virtual machine DB system, you will change the shape of that DB system. Can you tell us about the node virtual machine DB systems in OCI?   00;10;27;28 - 00;11;01;22 For one-node virtual machine DB systems, Oracle Cloud Infrastructure provides a fast provisioning option that allows you to create a DB system using Logical Volume Manager, LVM, as your storage management software. Fast provisioning for an Oracle Database with Logical Volume Manager increases developer productivity. Can we also choose to use Automatic Storage with DBCS? You have a choice to select ASM storage management. You will select Oracle Grid Infrastructure when you provision your DB system to use Oracle Automatic Storage Management.   00;11;01;25 - 00;11;32;03 This is required for RAC deployments. Virtual machine DB system deployments with ASM support 11.2 database versions and above, whereas virtual machine DB system deployments with LVM support 12.2 database versions and above. When you provision your virtual machine DB system, you will identify the amount of available storage. This is the amount of block storage and gigabyte to allocate to the virtual machine DB system.   00;11;32;05 - 00;11;56;05 Available storage can be scaled up or down as needed after provisioning your DB system. You will also indicate total storage, the total block storage and gigabyte used by the virtual machine DB system. The amount of available storage you select determines this value. Oracle charges for the total storage used. What our customers really want to know is how their data is kept secure?   00;11;56;11 - 00;12;26;29 Lay it out for us. Alex. Identity Management, network controls, and encryption are all built into Database Cloud Service virtual machine and bare metal DB system to provide end-to-end security. Oracle Data Safe is an integrated security service available at no additional cost. With it, you could do a few things. Identify configuration drift through overall security assessments. This helps you identify gaps and then fix the issues. Flag risks users or behavior, and see if they're all well controlled.   00;12;27;02 - 00;12;54;14 Audit user activity. Track risky actions. Raise alerts and streamline compliance checks. Discover sensitive data. Know where it is and how much you have. Mask sensitive data. Three out of four DB instances are copies for dev test. This lets you remove that risk. To help meet security compliance standards, you can optionally enable FIPS, STIG, and SELinux options.   00;12;54;20 - 00;13;15;04 Thank you, Alex, for guiding us through all of this. To learn more about Oracle Database Cloud Service, please visit mylearn.oracle.com and take a look at our free Oracle Cloud Data Management Foundations Workshop. You'll also find quizzes that you can take to test your understanding of these concepts. That brings us to the end of this episode.   00;13;15;06 - 00;13;39;11 We're very excited about our episode next week in which we'll be talking with Rohit Rahi, Vice President of OCI Global Delivery, and Bill Lawson, Senior Director of Cloud Applications Product Management for Oracle University. We'll be talking about the free Oracle Cloud Infrastructure and Cloud Apps training and certifications that are available for a limited time. So you really won't want to miss that episode!   00;13;39;13 - 00;16;23;28 Until next time, this is Lois Houston and Nikita Abraham signing off. That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.