My first steps with Oracle Cloud API Gateway – the stock response

| Dec 23, 2019

The API Gateway service on Oracle Cloud Infrastructure went live very recently – read my overview article of what API Gateway entails. In brief: API Gateway is a reverse proxy that exposes HTTP endpoints on which external (or internal) clients can make requests. API Gateway can handle these requests: authorize, rate limit, map and route to OCI internal or public HTTP endpoints or specifically to Oracle [serverless] Functions. API Gateway allows us to allow selective (more...)

Introducing Oracle Cloud API Gateway – the light weight public or private router to public and private OCI endpoints

| Dec 22, 2019

Two days ago, the API Gateway service on Oracle Cloud Infrastructure went live – read the announcement. This is a crucial component for many applications and in many solution designs. This new API Gateway is a prime candidate for example for inclusion in our reference architecture for OCI based solution designs. The API Gateway acts as a reverse proxy that handles HTTP requests from clients – either within OCI or on the public internet – (more...)

Creating a VM on Oracle Always Free

| Oct 25, 2019

I’m going to create a new Cloud VM to host some of my machine learning work. The first step is to create the VM before installing the machine learning software.

That’s what I’m going to do in this blog post and the next blog post. In this blog post I’ll step through how to setup the VM using the Oracle Always Free cloud offering. In the next I’ll go through the machine learning software install (more...)

Oracle’s Always Free Autonomous Database and Cloud Infrastructure

| Sep 17, 2019
Yesterday Larry Ellison announced in his keynote during the Oracle Open World 2019 the "Always Free Autonomous Database and Cloud Infrastructure". For more details about it see:

In short terms, you get a full environment with:
  • 2 Always Free Databases
  • Up to 1 OCPU and 20GB of Storage for each Database
  • SQL Developer Web-based
  • APEX
  • Automatic REST
  • SQL Notebooks for Machine Learning
  • 1 (more...)
  • ADW – Loading data using Object Storage

    | Aug 12, 2019

    There are a number of different ways to load data into your Autonomous Data Warehouse (ADW) environment. I’ll have posts about these alternatives.

    In this blog post I’ll go through the steps needed to load data using Object Storage. This might appear to have a large-ish number of steps, but once you have gone through it and have some of the parts already setup and configuration from your first time, then the second and subsequent (more...)

    Where is My Money Going? Checking the balance with Oracle Cloud Account Metering REST APIs

    | Aug 7, 2019
    Where is My Money Going? Checking the balance with Oracle Cloud Account Metering REST APIs
    How much did I spend so far?
    Where is My Money Going? Checking the balance with Oracle Cloud Account Metering REST APIs

    It's a typical question we ask ourselves daily and what do we do? Probably check the bank account status on our phone and yell at ourselves for all the money we trashed the previous night at the pub.

    The Cloud

    One of the great benefits of the cloud is that there is no big upfront cost required to start playing with the latest tool or technology, we just (more...)

    Oracle ADW how to loading new OML notebooks

    | Jul 29, 2019

    Oracle Autonomous Database (ADW) has been out a while now and have had several, behind the scenes, improvements and new/additional features added.

    If you have used the Oracle Machine Learning (OML) component of ADW you will have seen the various sample OML Notebooks that come pre-loaded. These are easy to open, use and to try out the various OML features.

    Screenshot 2019-07-29 13.07.01

    The above image shows the top part of the login screen for OML. To see (more...)

    Oracle and Microsoft to Interconnect Oracle Cloud and Microsoft Azure

    | Jun 11, 2019

    On the 5th of June 2019, both Oracle and Microsoft made a joint announcement on the interconnection between Oracle Cloud and Microsoft Azure:

    Oracle’s Press Release
    Microsoft Press Release

    The key aspects of the announcement are:

    1. A direct interconnect between Oracle Cloud and Azure Cloud, starting in Ashburn (North America) and Azure US East, with plans to expand additional regions in the future.
    2. Unified identity and access management, via a unified single sign-on experience (more...)

    Oracle Linux hangs after “probing EDD” in Oracle Cloud

    | Feb 5, 2019

    Just short note: If your imported Oracle Linux image hangs on boot in the Oracle cloud, just set GRUB_DISABLE_UUID=”true” in /etc/default/grub

    Observations About the Scalability of Data Loads in ADWC

    | Jul 26, 2018

    In the last days, I am running a number of tests based on the TPC-DS benchmark against Oracle’s Autonomous Data Warehouse Cloud service (ADWC). One of the first thing I did is of course to create the TPC-DS schema and populate it. The aim of this blog post is to share some observations related to the population step.

    I started by generating the data with the tool provided by TPC-DS: dsdgen. With the following command, (more...)

    Which Privileges Are Required to Use the ADWC Service Console?

    | Jul 17, 2018

    The Autonomous Data Warehouse Cloud (ADWC) service provides a Service Console that can be used to monitor the service activity and to carry out a small number of administration tasks (e.g. changing some resource management rules).

    The documentation specifically says to use the ADMIN user to login. But, actually, any unlocked database user having the CREATE SESSION privilege can be used to login. This is not only useful, but, in my opinion, necessary. In (more...)

    DBMS_CLOUD Package – A Reference Guide

    | Jul 12, 2018

    The Appendix A of the Using Oracle Autonomous Data Warehouse Cloud guide describes the DBMS_CLOUD package. Unfortunately, it documents only a subset of the subroutines. And, for some of them, the description could also be enhanced. Therefore, while I was testing all the subroutines the DBMS_CLOUD package provides, I took a number of notes. By the end of my tests, I got what I can call my personal reference guide to the package. Since it (more...)

    Jarvis Pizzeria: Custom Reports & Dashboards

    | Jun 3, 2018
    In our previous blog we showed the out of the box functionality of Dashboard & Reporting. Next to the default dashboards, you can also create your own custom dashboards. However, before we can create dashboards on this, we need to set up some indicators within our application. In the composer we have to go to the tab Indicators.

    There are three types of indicators that you can create here:
    - A Dimension represents the grouping (more...)

    Jarvis Pizzeria: Business Reports & Dashboards

    | May 28, 2018
    Within the workspace there are some out of the box dashboards that you can use to monitor your instance. When you go to My Tasks and click Dashboard, by default the Health dashboard is shown.
    There are a total of 5 default dashboards, Health, Open, Workload, Trend & Closed. You can use the filters on the right hand side to filter the dashboard.

    The health dashboard will give you an instant, real-time view of the (more...)

    Playing with ADWC (Autonomous Data Warehouse Cloud Service)

    | May 16, 2018
    Oracle has launched Oracle 18c and the Autonomous Data Warehouse Cloud Service (ADWC). Many people call the Oracle 18c as the Autonomous database, and this is a huge mistake! Oracle 18c (that is in reality Oracle is not an

    Playing with Oracle Ravello – Migrating your VMs to the Cloud

    | May 9, 2018
    Hello everyone, A few years back we had the boom of the “Private Cloud” rush, where everyone started to implement virtualization technologies to make a better use of it Infrastructure resources and improve high availability, scalability and innovation! Now to

    The Forgotten Link To The Cloud

    | Apr 20, 2018
    (Note: This article was also published at – Last year when presenting a session at Collaborate’17 in Las Vegas regarding Tips and Best Practices for DBAs, I went thru the evolution of the DBA profession and also gave

    Jarvis Pizzeria: Aborting a Process

    | Apr 17, 2018
    In this blog entry, we will take a look at the way a dynamic process deals with a process that ends with an exception. We will implement this in our “Register Order” process.

    We modeled the process as depicted below:

    When saved, published and activated, we start a new dynamic process; of course through our famous form:

    The expectation is that Register Order starts and that we can start executing the task. When we open (more...)

    Playing with Oracle Cloud – Creating a Hybrid DR Deployment

    | Apr 9, 2018
    On this article, we will create a Hybrid Disaster Recovery (DR by using Data Guard) Oracle Database Cloud Service database deployment with a primary database on-premises and a standby database in the cloud. This can be used to implement an improve the high

    Playing with Oracle Database Cloud – Migrating to Cloud using an Oracle Cloud Backup

    | Apr 4, 2018
    The idea for this scenario is to learn how to migrate an Oracle Database from on-premises to Oracle Cloud DBaaS by using a previously done backup using Oracle Cloud Backup Services. First, we will create an Oracle Database Cloud Services database