Oracle compute, storage and network services that we discussed earlier in this website are part of Infrastructure as a Service (IaaS).
In this post we will briefly discuss about Oracle database cloud services which is part of Platform as a Service (PaaS). PaaS contains some of the platform services like Database, Business Analytics, Application Development (Java, Mobile,Messaging etc), Integration, Content and Collabration etc.
In simple words , Oracle Database Cloud Service offers elastic database services for application development, test and production deployment. The service delivers an easy to use web console user interface and RESTful API to provision and administer Oracle Database on Oracle Compute Cloud Offerings. 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. Additionally, it provides access to the compute nodes (and thus to the database) using networking resources provided by Oracle Compute Cloud Service.
Oracle database cloud services are highly scalable and will prove beneficial for individual Developers, small business, Enterprise or for huge mission critical database application. Based on the workload that you have, you can choose between general purpose infrastructure or Engineered (Exa) Systems infrastructure.
Listed benefits of Oracle Database Cloud services are:
- Reduced Time and Cost of Provisioning and Management
- Self Service and Ease of Access
- Standardization of Services Eases Database Management
- Elastic, Capacity on Demand
- Easier Adoption of Full Oracle Capabilities through Automation. Full Oracle Capabilities like : Real Application Clusters (RAC), Data Guard, Active Data Guard, TDE Encryption,Multitenant PDBs, Compression, Partitioning, Spatial, Text, JSON, XML, In-Memory, Performance and Tuning Advisors, ASM, REST
- Subscription Pricing
Subscriptions Types for Oracle Database Cloud:
1. Unmetered
The database schema service is sold as an Un Metered service with terms of monthly, 1 year, 2 years and 3 years.
2. Metered
Cloud credits charged hourly against a rate card. For example an Oracle EE Extreme Performance service will burn credits faster then an Oracle SE1 database. Likewise a database server on 16 OCPUs (cores) will burn cloud credits faster then a 2 OCPU shape.
Oracle Database Release Version
At the time of writing this post, when creating a database deployment on Oracle Database Cloud Service, you can choose one of the following Oracle Database software release versions:
- Oracle Database 11g Release 2
- Oracle Database 12c Release 1
- Oracle Database 12c Release 2
Oracle Database Software Package
When creating a database deployment on Oracle Database Cloud Service, you choose one of the following Oracle Database software packages:
Standard Edition—Oracle Database Standard Edition, which delivers unprecedented ease of use, power, and performance for workgroup, department-level, and Web applications. It includes all the facilities necessary to build business-critical applications.
Enterprise Edition—Oracle Database Enterprise Edition, which provides the performance, availability, scalability, and security required for mission-critical applications such as high-volume online transaction processing (OLTP) applications, query-intensive data warehouses, and demanding Internet applications.
Enterprise Edition – High Performance—provides all the features of Enterprise Edition, plus these options and packs:
Multitenant, Partitioning, Real Application Testing, Advanced Compression, Advanced Security, Label Security, Database Vault, OLAP, Advanced Analytics, Spatial & Graph,
Diagnostics Pack, Tuning Pack, Database Lifecycle Management Pack, Data Masking and Subsetting Pack, Cloud Management Pack for Oracle Database
Enterprise Edition – Extreme Performance—provides all the features of Enterprise Edition – High Performance, plus these options and packs:
Active Data Guard, Oracle Real Application Clusters (Oracle RAC), In-Memory Database
High Level Steps for using Oracle Database Cloud
1. GET ACCESS TO ORACLE DATABASE CLOUD
Get a trial environment or purchase a subscription to Oracle Database Public Cloud Services
2. ADD/MANAGE USERS AND ROLES
Create accounts for your users and assign them appropriate privileges. Assign the necessary Database Cloud Service roles.
3. CREATE AN SSH KEY PAIR
Create SSH public/private key pairs to facilitate secure access to the compute nodes associated with your database deployments.
4. CREATE DATABASE DEPLOYMENT
Use a wizard to create a new database deployment.
5. ENABLE NETWORK ACCESS
Permit access to network services associated with your database deployments.
6. LOAD DATA INTO DATABASE
Use standard Oracle Database tools (RMAN, expdp/impdp etc) to load data into your databases.
7. MONITOR DATABASE DEPLOYMENTS
Check on the health and performance of individual database deployments.
8. MONITOR THE DATABASE SERVICES
Check on the day-to-day operation of your service, monitor performance, and review important notifications.
9. PATCH A DATABASE DEPLOYMENT
Apply a patch or roll back a patch
10. BACKUP THE DATABASE DEPLOYMENT
Back up a database or restore a database from a backup.
You have a range of options available to ensure an easy migration to the Oracle database Cloud. The automatic provisioning, powerful cloud tooling and integrated systems offer ease of migration and administration.
In coming posts we will discuss more on Oracle Database Cloud.
- Oracle Multitenant DB 4 : Parameters/SGA/PGA management in CDB-PDB - July 18, 2020
- Details of running concurrent requests in Oracle EBS - May 26, 2020
- Oracle Multitenant DB 3 : Data Dictionary Architecture in CDB-PDB - March 20, 2020