Last Week in Stream Processing & Analytics – 13.3.2018

This is the 106th edition of my blog series blog series around Stream Processing and Analytics!

As every week I was also updating the following two lists with the presentations/videos of the current week:

As usual, find below the new blog articles, presentations, videos and software releases from last week:

News and Blog Posts


Apache Kafka / Kafka Streams / Confluent Platform

Can Ireland Continue to Win?

I've just watched Ireland win the 6 Nations, next week is Cheltenham, St Patricks Day, England v Ireland at Twickenham for the Grand Slam; can anything top that?

Well they will all rush back for the 
annual OUG Ireland Event held  22-23 March at The Gresham Hotel, Dublin.

As ever there is a great agenda, and I'm kicking off the Apps stream with a look at selecting the right, cloud solution (more...)

Docker-CE on Ubuntu 17.10 (Artful Aardvark) (2)

Three months ago i installed docker on my ubuntu 17.10. At those days there was no straight forward howto on

Now the installation is listed on

The installation manual can be found here.

root@zerberus:~# apt-get install apt-transport-https ca-certificates curl   software-properties-common
root@zerberus:~# curl -fsSL | sudo apt-key add -
root@zerberus:~# apt-key fingerprint 0EBFCD88  pub   rsa4096 2017-02-22 [SCEA]
      9DC8 5822 9FC7 DD38 854A  E2D8 8D81 (more...)


2 years ago, I have published an article series about the undocumented feature "ALTER USER RENAME":

As I was getting access to an Oracle 18c Database, I was trying directly, if the ALTER USER RENAME still works (more...)

Oracle VM x86: Installing Oracle VM Manager (getting the installation media)

If you search for "oracle vm manager" on Oracle Edelivery you will get the following:
Downloading "Oracle VM Manager with Oracle Linux" will lead to two files with *.img. These files are no cd/dvd images. But you can find a solution here:

mount -t auto -o loop,offset=$((63*512)) System.img /mnt/System
But this leads to some files with oc4j containers. 

So DO NOT search for "Oracle (more...)

Oracle VM x86: Installing Oracle VM Manager

First check the hardware requirements:

After downloading the right image (please do not laugh, this is really a problem), inside a Oracle Linux the following steps have to be done:

mount /dev/cdrom /mnt
mount: /dev/sr0 is write-protected, mounting read-only
# ls /mnt/
components       oracle-validated.params  sample.yml  ovmm-installer.bsx        TRANS.TBL
First try:
[root@localhost ~]# /mnt/
Missing required package, Oracle VM Manager requires (more...)

EXPDP using an External Password Store – facing a new ‘release’ of a well known performance issue

After a while without blogging, here a new blog post talking about a very well known performance issue:

export (exp as well as expdp) is usually slower when using an TCP based TNS-Alias instead of setting ORACLE_SID. Remember? ;-) 

In a little more detail:
An "expdb system/manager@db directory= ..." takes (usually) more time than an
"export ORACLE_SID=DB; expdp system/manager directory= ..."

But what if You have to use an external password store - a (more...)

The Legacy of A Great Friend

John Schiff died at the weekend. It was expected, he had found out he had leukaemia last October and he spent his last weeks at home with his family and hospice care. 

John was head of JD Edwards World product and a great friend to both UKOUG and me personally.

From the time Oracle purchased PeopleSoft and therefore JD Edwards, John worked with UKOUG to ensure his customers had a user group to support (more...)

Oracle database 18c: Installation via RPM

After the release of 18c i did a short dive into the "guide to new features" announced on

 And take a look, what can be found in "Database Overall -> Install, config, and patch":

RPM-based Database Installation
RPM-based Database Installation (RDI) enables an RPM-based installation of the Oracle Database software. Using the rpm-ivh command, an RPM-based database installation performs the preinstallation validations, extracts the packaged software, reassigns the ownership of the extracted (more...)

Oracle VM x86: Installation walkthrough / step by step for a node/server

Last week i tried to setup Oracle VM. For all who are interested, here a short walkthrough.
First the VirtualBox Setup: The VM which should contain the Oracle VM server:

Let's boot:

Next reboot:

 And here we go:

Managing API Policy Versioning in Oracle API Platform

Oracle’s API Platform (API-P) product avoids the use of external configuration management. If you want to better understand why, then checkout our forthcoming book as it goes into detail about why this is the case (it can be pre-release version of the book can be obtained here). In a previous blog I wrote about and illustrated the use of the API-P’s own APIs so that it was possible to see what API iterations had (more...)

Ubuntu Kernel: Adding a new menuentry as default before menuentry ‘Ubuntu’ (grub)

After the problem with s2disk/hibernate on my Ubuntu 17.10 i wanted to change the grub boot menu:
I wanted to add my new default kernel at the beginning  - before the 'Ubuntu' menuentry.

Adding the menuentry inside /boot/grub/grub.cfg does not work, because after the first kernel update the command update-grub will overwrite all changes.

Easiest way:
Go to /etc/grub.d/ and move

mv 40_custom 09_custom
Inside 09_custom add your new menuentry (just copy (more...)

Oracle Database 18c released!

Today i discovered on --> database:

The downloads-page looks like the last weeks - 12c is the default...

... but the documentations tab lists 18c: shows the following:

So the "cloud first" strategy is still in place (by the way: is this something like "america first"?).

The installation procedure looks strange:
Starting with Oracle Database 18c, installation and configuration of Oracle Database software is simplified with image-based installation.

Screenshots and more

One of my pet peeves is a sloppy screenshot. I shudder if I’m sent a screenshot in a professional document that’s blurry, too zoomed out or stretched out of ratio. I cringe if I see a presentation with a screenshot that includes a stack of irrelevant extra info – it’s not necessary to include your Amazon shopping browser tabs or to advertise how many unread Yahoo emails you have.

As a result, I like a (more...)

Firefox tab crashes by loading on ubuntu 16.04

On a ubuntu 16.04 system firefox crashes by loading

 The only way to fix this was going to "about:config":

On this page search for "webgl.disabled" and change the value from false
to true:

After that, loads without any problem...

Node.js tutorial part 2; building a proper website

Your first fully functional Node.js application

In the first part of this tutorial we set up a development environment. As you have noticed there, the core of a Node.js application is a server side Javascript file. You will be editing this file a lot and along the while it will grow accordingly.

I think the first step you will take, is change your code so that node.js serves a proper website. This (more...)

Tweaking the Manager Resources Dashboard

The Manager Resources Dashboard is being replaced in Release 13, but until we get the upgrade we still need to use the current version. Most of the content can be replaced with better OTBI output, however, Worker Availability is not able to be easily superceded.

So, for our client, they have this on its own on a Dashboard.

Manager Resources Dashboard Tweak 1

Straight away you’ll be able to see the problem. Anyone with more than four direct reports will (more...)

Docker-Machine: how to create a docker vm on a remote virtualbox server

After doing some first steps with docker, i wanted to test docker-swarm. Because of the limited resources of my notebook, i was looking for a Linux with a minimal footprint. In the context of setting up VMs for docker-swarm i found a log of articles about doing that with the tool docker-machine.
It sounds like this tool can create VMs just with one command. (here the documentation).

So let's give it a try:
(You (more...)

Enforce the HTML5 max attribute of input items with JavaScript

The HTML5 max and min attribute on input items

The max attribute is introduced in HTML5 and specifies the maximum value for an <input> element. Unfortunately, it doesn’t enforce the maximum value entered when typing in numbers as you might expect.

The syntax for the HTML element is as follows:

<input max=”number|date“>

With a small JavaScript function it’s possible to make sure no value larger than the max value (or smaller (more...)

3 Easy Ways to Capture Documents to Oracle Content & Experience Cloud with Oracle WebCenter Enterprise Capture

Document capture plays a crucial role in the overall content management process. The conversion of paper or electronic documents (PDFs, email attachments, etc.) to managed content that includes metadata, enables such content to be easily found within enterprise content management systems like Oracle WebCenter. For companies that have invested in cloud-based content management systems, such as Oracle Content & Experience Cloud (Oracle CEC), the process of capturing documents shouldn’t delay the benefits of being (more...)