What Oracle DBAs Need to Learn in Oracle Cloud Platform?

The transition from Oracle on-premises DBA to Oracle Cloud DBA is imminent for many of us. In fact, IMHO; the existing Oracle DBAs would have to manage database both on-premises and in cloud for a long time.

So what Oracle DBA needs to learn in Oracle Cloud Platform? If you visit the Oracle Cloud website, it's a mouthful and more. Its very easy to get bogged down as there are lots of things to (more...)

Is Oracle Database in Cloud PaaS, IaaS, SaaS, or DBaaS?

Question: Is Oracle Database in Cloud PaaS, IaaS, SaaS, or DBaaS?
  • If you install and manage Oracle database in cloud by yourself, then you are using it on IaaS.
  • If you are just using it in cloud without installing or managing it, then it's PaaS.
  • If you are configuring the database instance and have access to it through SQL*Net, then its DBaaS. 
  • SaaS not really relevant when it comes to Oracle (more...)

Apache Kafka on the Oracle Cloud: My First experiences with Oracle Event Hub Cloud Service

Oracle recently made their ‘Kafka on Cloud’ service available: the Event Hub cloud service – offered as part of the Big Data Compute Cloud Service. In this article, I will briefly show the steps I went through to get up and running with this service. To be frank, it was not entirely intuitive – so this may be handy the next time I have to do it or perhaps when you are struggling. One obvious (more...)

Oracle Public Cloud – Invoking ICS endpoints from SOA CS – configure SSL certificate and basic authentication

As part of the Soaring through the Clouds demo of 17 Oracle Public Cloud services, I had to integrate SOA CS with both ACCS (Application Container Cloud) and ICS (Integration Cloud Service).


Calls from Service Bus and SOA Composites running in SOA Suite 12c on SOA CS to endpoints on ACCS (Node.js Express applications) and ICS (REST connector endpoint) were required in this demo. These calls are over SSL (to https endpoints) and for (more...)

Getting started with Oracle PaaS Service Manager Command Line Interface (PSM)

Oracle PaaS Service Manager (PSM) provides a command line interface (CLI) with which you can manage the lifecycle of various services in Oracle Public Cloud. This opens the door for scripting (recurring) tasks – such as (re)deployment of applications on ACCS to provisioning new environments. PSM makes performing admin operations on the Oracle Public Cloud a lot easier and efficient, compared to using the the GUI.

Note that the CLI is a thin wrapper over (more...)

Use PSM to push your application to ACCS

| Mar 6, 2017
To push an application on the Application Container Cloud Service (ACCS) from the terminal, you can use the Oracle product 'PaaS Service Manager Command Line Interface' (PSM CLI). PSM CLI is a tool to help you with scripting tasks you want to do against several Oracle Clouds. The steps to push your application to the Oracle Cloud are not that complex, in short:

  1. We create a container in Storage Cloud for our application.
  2. We put (more...)

Runtime version of Node on Oracle Application Container Cloud (0.12 vs. 6.9.1) – easy single click upgrade

Yesterday, I create a new application on Oracle Application Container Cloud. The application type is Node (fka Node.js), so the container type I had created was Node – rather than PHP or Java SE, the other two options currently available to me. I was a little dismayed to learn that the runtime Node version that my container was created with was (still) 0.12.17. I had assumed that by now ACCS would have (more...)

Oracle Database Cloud (DBaaS) Performance – Part 4 – Network

In the last part of this installment I'll have a brief look at the network performance measured in the Oracle DBaaS environment, in particular the network interface that gets used as private interconnect in case of RAC configuration. The network performance could also be relevant when evaluating how to transfer data to the cloud database.

I've used the freely available "iperf" tool to measure the network bandwidth and got the following results:

[root@test12102rac2 ~]# iperf3 (more...)

Oracle Database Cloud (DBaaS) Performance – Part 3 – Storage – 12.2 Update

Recently I repeated the I/O related tests on a instance for curiosity and was surprised by the fact that I consistently got significantly better results as on and

Now you're probably aware that the version 12.2 so far is "cloud-only", so I can't tell / test whether the version 12.2 is generically providing that increased performance or whether Oracle has optimized (more...)

Oracle Database Cloud (DBaaS) Performance – Part 2 – Storage

In this second part of this installment I'll focus on the performance figures related to I/O encountered when the corresponding tests were performed on the platform.


When running with minimum sized buffer cache, direct and asynchronous I/O enabled, the following average read-only IOPS figures were measured over a period of several days (this is the test described in part three of the "performance consistency" series) .

First, running on a 4 OCPU single instance configuration (more...)

Oracle Database Cloud (DBaaS) Performance – Part 1 – CPU

After having looked at the performance consistency provided by the Oracle Database Cloud offering in the previous series, I'll focus here on the raw performance figures I've measured during my tests, starting with the CPU related performance findings.

One of the first surprises is related to the fact that Oracle uses a unit called "OCPU" to specify the CPU capacity provided, which is explained here:

So one "OCPU" is supposed to represent one core (more...)

12th Day of #Cloud: Thoughts

12 Days of #Cloud: Day 12 After playing with Oracle Database Cloud Service (DBaaS) for past several days, I have mixed feeling. I like quite a lot of features and the amount of automation went into the product. For example, creating an RAC instance and creating a Data Guard instance by picking a check box […]

12 Days of #Cloud: Exploring #DBaaS with Data Guard

12 Days of #Cloud: Day 11 After a few failed attempts, I was successful in creating a Data Guard DBaaS Instance. Since I was playing with a trial account, the resources were limited. I guess when I had another database running, there is not much storage left to create two instances in Data Guard configuration. […]

12 Days of #Cloud: Backup #DBaaS to Cloud Container

12 Days of #Cloud: Day 10 In a previous post, I talked about enabling backups on a #DBaaS instance where backups were disabled when the instance was created. Today I show you how to create a database with Cloud Backup enabled at the time of creating the instance. To store backups on the Oracle Cloud, […]

12 Days of #Cloud: Apply Patch to #DBaaS Instance

12 Days of #Cloud: Day 9 I have a 12.1. Database Cloud Instance, which comes with several patches including July 2016 PSU. The dbaascli cloud tool can be used to query and apply patches. Before we use dbaascli, let’s check what the Cloud interface shows. Choose the DBaaS instance and view details. The “Administration” tile shows […]

12 Days of #Cloud: Cloning #DBaaS Instance

12 Days of #Cloud: Day 8 It is very easy to stand up a new DBaaS instance as a replica or clone of an existing instance. In this demo, I am going to create a new instance as a copy of CLDB4ACED DBaaS instance. First, need to create a snapshot using the DBaaS instance menu. […]

eProseed Oracle Open World 2016 debrief – Oracle Database & Oracle Management Cloud

For people interested, here the slide desks used internally to debrief my colleagues regarding Oracle…

12 Days of #Cloud: Adding Storage to #DBaaS Node

12 Days of #Cloud: Day 7 There are three types of storage expansion possible on Oracle #DBaaS instance. 1. Increase Default File Systems Increasing the default file systems that hold data files (/u02), FRA and backup (/u03) is easy.  These file systems can be increased by using the menu item “Scale Up / Down Service” […]

12.2 DBaaS (Extreme Edition) possible bug/issue with the DB install/setup

A few weeks ago the 12.2 Oracle Database was released on the cloud. I immediately set an account and got my 12.2 DBaaS setup. This was a relatively painless process and quick.

For me I wanted to test out all the new Oracle Advanced Analytics new features and the new features in SQL Developer 4.2 that only become visible when you are using the 12.2 Database.

When you are go to (more...)

Azure and Oracle Cloud – My First Time

Below talks about my experience trying out Azure and Oracle cloud for the very first time (and at the same time).

So last night I tried for the very 1st time the Azure and Oracle Cloud. Here, I just like to share my experience. BTW I am a big fan of DigitalOcean because of its user friendly interface, very fast to setup (end to end 2 minutes w/ few button clicks), and fantastic community and (more...)