Introduction to Oracle Database Cloud Service (OCI Database Services)
- Oracle database cloud service is a service of Cloud Category PaaS. It enables businesses to reap all the benefits of Platform as a Service, including subscription-based, self-service access to reliable, scalable, and elastic cloud environments.
- Earlier you needed to purchase hardware, install OS, and then install Oracle software and create a database for using the database. Now You can be up and running in minutes, without purchasing and maintaining hardware with Oracle Database Cloud Service
- Oracle database on Oracle Database Cloud Service is the same as on-premises. There are no changes to the Oracle database which also means there are no new tools or skills to learn. It’s the same software with the same standards, and there are no code changes. When you leverage DBCS, your developers can start innovating right away instead of waiting for weeks for IT to provide new infrastructure and spin up new databases.
- Oracle database on Oracle database cloud services is 100% compatible with those deployed on-premises, ensuring a smooth transition to the cloud, and an efficient hybrid cloud strategy.
- Apart from all the things mentioned above, critical database administration tasks such as setting up an Oracle RAC environment, patching, upgrades, backup, and recovery can be performed with a few clicks, enabling your DBAs and IT staff to focus on strategic activities and projects. When this happens, operating costs plummet, productivity soars and the pace of innovation accelerates.
- Oracle Cloud provides several Oracle Cloud Service deployment choices. These choices allow you to start at the cost and capability level suitable to your use case and then give you the flexibility to adapt as your requirements change over time. Choices include single schemas, dedicated pluggable databases, virtualized databases, Autonomous Database, and databases running on world-class engineered infrastructure.
Let’s check out in details for each of these
(a) Base Database
- This service Creates and manages full-featured Oracle Database instances on VMs in the cloud.
- Oracle base Database Service provides you the ability to deploy Oracle databases in the Cloud, with each database deployment containing a single Oracle database. You have full access to the features and operations available with Oracle Database, but with Oracle providing the computing power, physical storage, and (optionally) tooling to simplify routine database maintenance and management operations
- When you create database deployments, Database Cloud Service creates compute nodes to host the database, using computing and storage resources provided by Oracle Compute Cloud Service.
- Oracle provides root access to the compute nodes (and thus to the database) using networking resources provided by Oracle Compute Cloud Service. You are responsible for the patching, backup, and administration of the Oracle database using the cloud tools provided. You have full administrative privilege and full control of the database
- You are responsible for making any changes to the automated maintenance setup, and you are responsible for recovery operations in the event of a failure.
- You can create single instance database or RAC Database with this service
(b) Oracle Database Cloud Service – Bare Metal(This service is discontinued now)
- Bare Metal is Oracle’s next-generation cloud service. The bare metal cloud consists of features line Regions and Availability Domains, a modern network infrastructure, a Virtual Cloud Network, and high-performance compute infrastructure
- Cloud Database Service on bare metal offers on-demand, pay-per-use database services with the performance of dedicated hardware and local NVMe storage, and the reliability of RAC, on low latency, highly configurable, and secure Virtual Cloud Network.
- The High I/O or Dense I/O configuration consists of a single Oracle 11g or 12c database instance on 2 OCPUs, with the ability to dynamically scale up to 36 OCPUs without downtime. Select one of four editions of Oracle Database Cloud Service – Standard, Enterprise Edition, Enterprise Edition High Performance, and Enterprise Edition Extreme Performance. The storage configurations for these shapes are Bare Metal High I/O (12.8 TB NVMe SSD raw, ~3.5 TB with 2-way mirroring, ~2.3 TB with 3-way mirroring) and Bare Metal Dense I/O (28.8 TB NVMe SSD raw, ~9.4 TB with 2-way mirroring, ~5.4 TB with 3-way mirroring).
- The 2-node RAC configuration consists of two Oracle 11g or 12c Enterprise Edition Extreme Performance database instances with local shared SSD Storage on 4 OCPUs (2 OCPUs per server). 2-node RAC scales dynamically up to 72 OCPUs without downtime. The storage configuration for 2-node RAC instance is 24 TB SSD raw, ~8.6 TB with 2-way mirroring, ~5.2 TB with 3-way mirroring.
(c) Oracle Database Exadata Cloud Service
- As you all know Oracle database is the world’s most powerful database and Oracle Exadata is the most powerful database platform, The Oracle Database Exadata Cloud Service delivers the world’s best cloud database platform by combining both these and adding simplicity and cost-effectiveness of the public cloud.
- The Exadata Cloud Service enables customers to run Oracle databases in the cloud and still have available the same extreme performance and availability experienced by thousands of organizations deploying Exadata on-premises.
- Oracle databases deployed in the cloud are 100% compatible with those deployed on-premises, ensuring a smooth transition to the cloud and an efficient hybrid cloud strategy. With pay-as-you-grow dedicated Exadata configurations, and infrastructure managed by Oracle experts, the Exadata Cloud Service combines business agility and operational flexibility with zero capital expenditure.
- All of Oracle’s industry-leading database capabilities and options are included with the Exadata Service. Notable examples include In-Memory Database, Real Application Clusters (RAC), Active Data Guard, Automatic Storage Management (ASM), Partitioning, Advanced Compression, Advanced Security, Database Vault, Real Application Testing, OLAP, Advanced Analytics, Spatial, and Graph.
- Customers have complete access to all Oracle Database and OS features to ensure smooth and simple migration from on-premises Oracle deployments to Exadata Cloud Service. Each Exadata Cloud Service instance is configured such that there is a single Virtual Machine (VM), called the domU, which is owned by the customer, in each database server of the Exadata system. Customers have root privileges for the Exadata database server domU and DBA privileges on the Oracle databases.
(d) Oracle Exadata Cloud Machine at Customer
- Some of the customers have data, governance, and control requirements that preclude a pure cloud deployment. For example, some industries and businesses must comply with regulatory, legal, and privacy requirements demanding that sensitive data be stored on-premises. These organizations may also have custom security requirements.
- Customers may also need or want to maintain full control over business-critical systems, for example in deploying their own firewalls, load balancers, hardware VPNs, and so on. So it was not possible for them to get the benefits of public cloud deployment
- Oracle now also offers the Oracle Cloud Machine (OCM), which enables you to leverage exactly the same IaaS and PaaS capabilities as Oracle Cloud, but in your own data center. You can leverage cloud innovations while meeting all of your data sovereignty, privacy, and control requirements. The OCM solution allows you to concentrate on tasks that add value to your business, while Oracle installs, maintains, and manages the hardware and the IaaS and PaaS services running on that hardware
- Exadata Cloud Machine uniquely combines the world’s #1 database technology and Exadata, the most powerful database platform, with the simplicity, agility, and elasticity of a cloud-based deployment. It is identical to Oracle’s Exadata public cloud service, but located in customers’ own data centers and managed by Oracle Cloud Experts.
- Every Oracle Database and Exadata feature and option is included with the Exadata Cloud Machine subscription, ensuring the highest performance, best availability, most effective security, and simplest management. Databases deployed on Exadata Cloud Machine are 100% compatible with existing on-premises databases, or databases that are deployed in Oracle’s public cloud.
(e) Autonomous Database
- An autonomous database is a cloud database that uses ML to automate database optimization, security, backup, updates, and other routine administrative tasks traditionally performed by database administrators. Unlike traditional databases, autonomous databases perform all of these tasks but do not require human intervention.
- Oracle autonomous database can be monitored and managed by APIs and UI tools such as Enterprise Manager Cloud Control, SQL developer, Oracle machine learning web-based tool (OML)
- Three workload types are available in this service, Autonomous Datawarehouse, Autonomous Transaction Processing, Autonomous JSON Database
(f) Autonomous Database on Exadata cloud@Customer
- This is an Autonomous database on the Exadata cloud@Customer.
- This Eliminates the complexity of managing, scaling, and securing databases in your data center.
(g)Oracle Database Service for Azure
- Oracle Database Service for Microsoft Azure is an Oracle-managed service for Azure customers to easily provision, access, and operate enterprise-grade Oracle Database services in Oracle Cloud Infrastructure (OCI) with a familiar Azure-like experience.
- Users can seamlessly build Azure applications with the high performance, high availability, and automated management of Oracle Database services, such as Autonomous Database, running on OCI.
(h) MySQL Heatwave
- A fully managed open-source database service for transactional and analytical workloads
- with this service ,you can create fully managed, serverless NoSQL database
Related Article on Cloud
What is Cloud Computing
Cloud Computing Basics: iaas paas saas
Oracle Platform-as-a-Service Overview
Oracle Cloud :Infrastructure-as-a-Service Concepts
Oracle E-Business Suite on Oracle Cloud Overview
Top FAQ about Oracle E-Business Suite on Oracle Cloud