Skip to content

Oracle Database Cloud Services – Concepts

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.

[Post Views: 87]

Brijesh Gogia

I’m an experienced Oracle Applications DBA with more than a decade of full-time DBA experience. I have gained a wide knowledge of the Oracle software stack and have worked on several big projects for multi-national companies. I enjoy working with the leading-edge technology and have passion for database performance and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
  
You can connect with me on LinkedIn.

Be First to Comment

Leave a Reply

Required fields are marked *

error: Alert: Content is protected !!