Defining Boundaries for Logical Gateways on the API Platform a multi cloud / multi region context

The Oracle API Platform takes a different licensing model to many platforms, rather than on CPU it works by the use of Logical Gateways and blocks of 25 million successful API calls per month. This means you can have as many actual gateway nodes as you like within a logical group to ensure resilience as you like, essentially how widely you deploy the gateways is more of a maintenance consideration (i.e. more nodes means (more...)

Making an IoT Badge – #badgelife going corporate

Code Card 2018

Editor’s note:  Noel is the last man standing from the AppsLab to work at Oracle. He created this project while being part of the Oracle Groundbreakers Team. The rest of the original AppsLab team members are now scattered throughout different companies in the tech sector.

For years I’ve been wanting to create something fun with the almighty esp8266 WiFi chip. I started experimenting with the esp8266 almost exactly four years ago. Back then (more...)

Tuning Time

"“You see,” he continued, beginning to feel better, “once there was no time at all, and people found it very inconvenient.
They never knew whether they were eating lunch or dinner, and they were always missing trains. So time was invented to
help them keep track of the day and get places when they should. When they began to count all the time that was available,
what with 60 seconds in a minute and 60  (more...)

Helidon and the embracing of micro services

XEYO9H51_400x400Oracle have announced another Open Source project called Helidon ( as a microservices platform built on top of Netty (which is built around a contemporary async model). If you look at the literature you’ll note two flavours one called SE which aligns to the programming characteristics or Node.js – asynchronous. The author is MP which aligns to the rapidly evolving J2EE MicroProfile which essentially follows a coding style along the lines (more...)

Oracle Open World 2018 and More

Hi Everyone! These have been crazy weeks, but almost ready to board to another trip to Oracle Open World. I will like to thank everyone that participated on my Oracle Webcast last week “Does Cloud Mean the End of the

ODC Appreciation Day : ODC Podcasts

So I’m probably up bending the spirit of the ODC Appreciation Day, as the focus should be on tech. But this year I’d like to flag the podcasts put together by Bob Rhubart. These are as at-least diverse in subject as the Oracle technology portfolio. One month the podcast will be about API and the next AI, from Women in Technology to NoOps. Even if the subject is not an area that maybe of (more...)

Analytics and Stats for APIs

The Oracle API Platform provides the means to examine statistics and slice and dice the numbers by application, gateway, duration and so on resulting in visually appealing graphical representations.  The way the analytics works means you can book mark specific views, so you can return the same report view with the relevant features as often as you like.  However, presently there is no data export option.

The question why would I want to (more...)

using AWR on Exadata

Oracle released a brand new Whitepaper for Exadata

How to use AWR Report on Exadata Machines

This Whitepaper gives details how the AWR reports can be used in conjunction with Exadata to monitor and analyze database performance issues




ORAchk (EXAchk) und der Collection Manager (Teil 2)

Nun geht es mit Teil 2 weiter.

Nach dem nun die APEX Installation fertig ist, geht es darum den Collection Manager zu installieren und zu konfigurieren.

Dazu empfehle ich sich für das Setup parallel die Dokumentation, also das User’s Guide „Oracle® ORAchk and EXAchk“ und hier Kapitel 1.9 Oracle Health Check Collections Manager for Oracle“ zu öffnen.

Wir melden uns nun am Admin Service an:



Der neue „Workspace“ wird erstellt. Im zweiten Schritt (more...)

Oracle Developer Podcast – Developer Evolution

podcast-356-dev-evolutionLast month I was fortunate enough to have been invited to participate in another Oracle Developer Podcast.  Rather than focusing on specific technologies, this focused on more how the thew job market is changing for IT and what might be driving change, and how things may change in the future. Check it out here.

As ever thanks to Bob Rhubart of the invitation, and putting together these excellent recordings.

Well, That Didn’t Work …

"There are no wrong roads to anywhere."
-- Norton Juster, The Phantom Tollbooth

Interesting behavior with the unified audit trail has been reported by Jeff Hunter and verified on at least two platforms, Solaris 10 and RedHat Enterprise Linux 6. While other ports of Oracle behave as expected (Windows and Oracle Enterprise Linux 7, to name two that I’ve tested) the problem platforms fail to return data from V$SESSION because the AUDSID values apparently (more...)

GraalVM – why a different VM?

If you read press around Java you’ll have come across references to GraalVM. So what is it and why would I use it?

There is an excellent podcast from Software Engineering Daily that digs into the subject and can be found here and here. But let draw out some of the reasons as to why GraalVM is interesting.

Whilst multiple languages on top of the JVM is nothing new, such as Scala , Kotlin, and (more...)

ORAchk (EXAchk) und der Collection Manager (Teil 1)

ORAchk & EXAchk sind wichtige Tools im täglichen Oracle DBA Geschäft. Allerdings habe diese Tools wenn man Sie einmalig oder mehrfach startet den großen Nachteil das man jeweils einzelne Reports erhält und diese nicht miteinander vergleichen kann, oder eine Historie erhält. Es bedeutet im Umkehrschluss man muss sich selbst eine „Ordnung“ überlegen und die Verwaltung übernehmen.

Genau an diesem Punkt kommt nun der „Collection Manager“ ins Spiel, der eine komplette APEX Anwendung ist und die (more...)

Eviction Notice

"Expectations is the place you must always go to before you get to where you're going. Of course,
some people never go beyond Expectations, but my job is to hurry them along whether they like it or not."
-- Norton Juster, The Phantom Tollbooth

Oracle has decided that Solaris needs to retire, giving those who are running Oracle on Solaris roughly two years to move to another operating system. A possible choice involves commodity (more...)

Could RedHat’s absolute commitment to OpenShift put them into difficult waters?

As a middleware (to use a fading term) or technical architect, I preferred not to get too involved in the detailed OS layer considerations when it can be helped (my Infrastructure Architect colleagues will always know more about NICs, port bonding, kernel versions etc etc than I ever will) and why I prefer to work with PaaS over IaaS.

But there is an undeniable trend where having a greater understanding of the OS is necessary, (more...)

API Developer Podcast

The authors of the API Platform book, got to record an Oracle Developer Podcast together in support of the book – the recording can be here at here or at here

As ever, thanks to Bob Rhubart for giving us this opportunity.


hostname in Oracle Linux 7.x ändern

Möchte man in Oracle Linux Version 7.x (ich nutze hier im Beispiel OL 7.5) den „hostname“  ändern, hat man drei Möglichkeiten:

NetworkManager text user interface tool

# nmtui

Menüpunkt auswählen Namen setzen abspeichern fertig

NetworkManager command line tool „nmcli“ 


# nmcli general hostname

Setzen des hotsname mit

# nmcli general hostname o2


Das „hostnamectl“ Kommando

# hostnamectl set-hostname o2 --static

Überprüfen kann man seine „Arbeit“ wie folgt

# hostnamectl status
Static hostname: o2

Oracle Podcasts – Beer & Pizza

We have been fortunate enough to participate an ArchDev podcast about meetups –

The podcast talks about the differences between the meet-ups and events such as conferences, what we try to get out of a meetup and the effort put into arranging them.

Form more info about the meetup I help organise checkout out

Oracle DB Upgrade 12.1 auf 12.2

Ich bin gerade dabei einige Datenbanken von 12.1 -> 12.2 upzugraden. Dazu setzte ich den DBUA ein und bin sehr positiv überrascht. Viele Checks werden im Dialog abfragt und diese werden dann während des Upgrade Prozess umgesetzt. Der Upgrade läuft reibungslos durch auch wie in meinem Fall auf RAC Datenbanken.

Möchte man den Pre-Upgrade vorab durchführen und dies per Skript steuern, dann kann man auf Metalink dazu ein Skript herunterladen. Dieses Skript sammelt (more...)

Introducing SQLdb360: merging eDB360 and SQLd360, while rising the bar to community engagement

Today, we are very happy to release SQLdb360, a new tool that merges together eDB360 and SQLd360, under a single package.

Tools eDB360 and SQLd360 can still be used independently, but now there is only one package to download and keep updated. All the new features and updates to both tools are now in that one package.

The biggest change that comes with SQLdb360 is the kind invitation to everyone interested to contribute (more...)