Running any Node application on Oracle Container Cloud Servicer

In an earlier article, I discussed the creation of a generic Docker Container Image that runs any Node.JS application based on sources for that application on GitHub. When the container is started, the GitHub URL is passed in as a parameter and the container will download the sources and run the application. Using this generic image, you can your Node application everywhere you can run a Docker container. One of the places where (more...)

ABCS: Maintain Security & Anonymous Access

Uncategorized
| Jun 13, 2017
Since the application of the tech17 is now live here (disclaimer: for the official information about the OGh Tech17, go to www.tech17.nl), it is time to adjust the security settings. By default when trying to access the application you need to login to the Oracle Cloud to be able to access the application.
To give public access, I will create an anonymous role and add certain pages to the anonymous role, after (more...)

ABCS: Go Live with your Application

Uncategorized
| Jun 11, 2017
When you are done developing the first version of your application, you might want to go live with it. Within ABCS there are a couple of steps build in to publish your application to the public. Before you can do this, you first have to go through a Stage environment where you can check the functionality of your application before publishing the application.

To do this, in the main menu we you choose the option (more...)

ABCS: Import data from CSV

Uncategorized
| Jun 6, 2017
In this use case, I do not let the user fill the data for the application through data entry forms, but rather I use the data that is available for the OGh Tech Experience 2017, this data is in a csv file that I want to upload to display the tracks within the application.

When opening the hamburger menu on the top left, you can leave the Page Designer and go to other parts of (more...)

Oracle Database on Hyper-scale Public Cloud – License Questions!

We all know, on January 23, 2017, Oracle updated the Licensing Oracle Software in the Cloud Computing Environment document. The gist of the announcement was “When counting Oracle Processor license requirements in Authorized Cloud Environments, the Oracle Processor Core Factor Table is not applicable“. So, if you are running Oracle database on x86 Intel platform on-premise, […]

ABCS: Create a lookup

Uncategorized
| May 14, 2017
When using reference data, a lot of times you want to use a list of values or a data lookup to specify what values can be selected. Within ABCS you can create lookups to fill in this requirement. When creating a new data field, for example when creating a Business Object under a table as we did in my previous blog entry, you can select the data type to be a reference.

For my (more...)

ABCS: Creating the Data Model

Uncategorized
| May 6, 2017
One of the powers of ABCS is that it generates a Data Model for you on the fly, based on your UI needs. For the developers, do not worry, you can also do this in an expert mode or edit and adjust it afterwards, more on that later in this blog series.
We are going to build a data model to hold all the data about the sessions being held on the Tech Conference.

This (more...)

ABCS: The First Adjustments

Uncategorized
| May 3, 2017
Now that you are ready to go, let's make a few simple adjustments to the application. We want to brand the app with a logo & title and we will set up the home page, which will basically be the disclaimer of this not being the official OGh Tech Experience website.

When in your application, make sure you are in edit mode and check out the header. You will see it says 'COMPANY.LOGO' where (more...)

ABCS: Getting started

Uncategorized
| May 2, 2017
Getting started with ABCS is very easy, go to cloud.oracle.com, your starting point for all Oracle Cloud products. For every Oracle Cloud product applies that you can get a free trial through there. This trial is a great starting point for getting to know the product. If you go to the Platform section you will see Application Builder in the list. Once you went to ABCS specific site, you can register for (more...)

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?
Answer:
  • 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...)

Use PSM to push your application to ACCS

Uncategorized
| 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...)

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 12.2.0.1 instance for curiosity and was surprised by the fact that I consistently got significantly better results as on 11.2.0.4 and 12.1.0.2.

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.

IOPS

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 […]

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.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...)