This post covers the overview of Oracle Database on Cloud including various Database Offerings & Database Edition available in Oracle Cloud Infrastructure (OCI).

Database Offerings

1. In Oracle Cloud Infrastructure, Database is divided into two types:

a) User-Managed Database

b) Autonomous Database

1. User-Managed Database: In User-Managed database, DBA task such as patching, cloning, backup & restore is managed by customers. It is further divided into three types.

• Virtual Machine DB Systems: Database is running on Virtual Machine & It supports both 1 -node, and 2-node RAC DB systems on Virtual Machine.
• Bare Metal DB System: Database is running on Bare Metal & It only supports only  1-node DB systems (RAC is not supported)
• Note: Where A bare metal server is a “single tenant” physical server. This means that the server is dedicated to one customer and not shared between multiple customers & A virtual server is hosted in a “multi-tenant” environment. This is where multiple virtual servers share the same physical hardware.
• Exadata DB System: Exadata DB systems runs on Exadata on Cloud and consist of a quarter rack, half rack, or full rack of compute nodes and storage servers, tied together by a high-speed, low-latency InfiniBand network and intelligent Exadata software and it is always a 2-node RAC only.

2.  Autonomous Database: Oracle Cloud Infrastructure‘s Autonomous Database is fully managed by Oracle such as patching and another administrating task.  Autonomous Database is further divided into types:

• ADW: ADW stands for Autonomous Data Warehouse and used for decision support or data warehouse workload.
• ATP: ATP stands for Autonomous Transaction Processing and used for a transactional workload.

To know more about Autonomous Database, Click here. 

 Database Editions

All 1- node RAC DB systems support the following Oracle Database editions:

• Standard Edition
• Enterprise Edition
• Enterprise Edition – High Performance
• Enterprise Edition – Extreme Performance (required for 2-node RAC DB systems)

When to opt for Exadata DB system & Bare Metal 0r Virtual Machine DB System?

Oracle Cloud Certifications available for DBAs:

There are mainly two types of certifications available for DBAs on Oracle Cloud.

1. Oracle Cloud Database Certification Exam [1Z0-160]
2. Oracle Autonomous Database Cloud Certification Exam [1Z0-931]

1. Oracle Cloud Database Certification Exam [1Z0-160]: To become Oracle Database Cloud certified, you would need to pass the Oracle Database Cloud Service 1Z0-160. This tests your Oracle Database Cloud Service skills, demonstrating your ability to administer your database in the Cloud.  For More details please check our blog Cloud Database Certification Exam [1Z0-160]

2. Oracle Autonomous Database Cloud Certification Exam [1Z0-931]: An Oracle Autonomous Database Specialist is an individual who has the skills to Manage complete Lifecycle Management of Autonomous Database (ATP & ADW) which includes a provision, manage & migrate to Autonomous Transaction Database (ATP) and Autonomous Data Warehouse (ADW).

To know more about this exam, Register for our FREE Masterclass on “How To Be Oracle Autonomous Database Cloud Specialist [1Z0-931] In 7 Weeks” 

Related/Further Readings

• [1Z0-931] Oracle Autonomous Database Cloud Certified Specialist Everything You Must Know 
• Create Oracle Autonomous Data Warehouse 18c on OCI
• How To Create Database on Oracle’s Gen2 Cloud (OCI)
• How to Connect to an Autonomous Database on Oracle Cloud
• Oracle Autonomous Database Cloud  Specialist: 1Z0-931 Training Program
• Oracle Autonomous Database Cloud Certification [1Z0-931]: Step-by-Step Activity Guides To Clear The Exam

Begin Your Cloud Journey

Begin your journey towards becoming an Oracle Cloud Expert and earn a lot more in 2024 by joining our FREE CLASS. You will also know more about the Roles and Responsibilities, Job opportunities for OCI Architects, Admins in the market, and what to study Including Hands-On labs you must perform to get the Higher Paying jobs.

Click on the below image to Register for Our FREE Class on MASTERING ORACLE CLOUD FOR DBAs, APPs DBAs, ARCHITECTS & SYS ADMINS