Application Container Cloud and Multi Tenant Services – Oracle embracing 3rd party technologies and open source projects

The Oracle PaaS cloud is turning into the next generation application server platform. More specifically: Oracle has announced the roadmap for the Application Container Cloud Service (not to be confused with the plain Container Cloud Service which runs pre built Docker containers without looking into them). The Application Container Cloud Servic

  • accepts and runs applications (not containers) implemented in a number of technologies – Node.js, Java SE, PHP, Python, Ruby, Go and Spark/Hadoop (more...)

Oracle Database 12c Release 2 is out – just only on the cloud

Graphic for Getting Started pageThe next major release of the Oracle Database has always been a big thing. Last year at Oracle OpenWorld [2015], a lot of sessions were dedicated to Release 2 of Oracle Database 12c – with sharding as probably its most eye catching new feature. Talk of the release date started at once. June 2016 was a popular date in these talks. June came and went. And now, come Oracle OpenWorld 2016, R2 is out – (more...)

Bridget Jones’s Baby 2.0

Great video from Oracle OpenWorld 2016 demoing Amazon Echo and Oracle HCM Cloud: Gretchen Alacon updates her HR record using voice with HCM!

Hat tip: Nin

Oracle Functions – Serverless architecture on the Oracle PaaS Cloud

One of the interesting tidbits, somewhat hidden away in Thomas Kurian’s keynote presentation last week at Oracle OpenWorld 2016, is a new member of the Oracle PaaS Cloud Services family called Oracle Functions (or at least that seems to be the working title). Oracle Functions are serverless applications that are run on the Oracle PaaS infrastructure when one of its triggering events has been published.

The next screenshot shows a function as part of a (more...)

Replacement of environment variables or properties in Bash

Earlier I wrote about the automatic installation of Fusion Middleware components using response files. A thing that lacked in my scripts was that although I had a FMW_HOME variable set in my enviroment shell script, the response files had the location hard coded in them. At the time I hadn't had the chance to figure out how to do property/variable replacement in shell. I do know how to do it with ANT. But I figured (more...)

Oracle SQL Pattern Recognition – introducing the Match Recognize operator

imageOracle Database Release 12c (12.1) introduced a new operator that we can use in SQL queries. The MATCH_RECOGNIZE operator allows us to detect patterns in our relational data. Specifically: it allows us to identify records that mark the beginning of a set of records that together form a pattern. In this set, each record satisifies a certain condition. The fact that in a set of records these conditions are met – in a certain (more...)

New PL/SQL pragma (12cR2) to deprecate program units – sign of a modern programming language

Bryn Llewellyn (Distinguished Product Manager, Database Division, Oracle) presented at OOW2016 on new features in PL/SQL in Oracle Database 12cR2. One of the features that stood out was a new pragma deprecate that can be added to program units such as functions and procedures inside packages. This pragma is used to mark a program unit at deprecated, which typically means: the program unit is still valid, but has been superseded by a better option and (more...)

What can we learn from the Microservices movement?

If you’re into integration, SOA or web services, you’ve probably heard the term Microservices fairly often lately. Is applying Microservices architecture the one-size-fits-all solution that can replace the traditional one-size-fits-all SOA solution that doesn’t fit anymore? Of course not, because the world isn’t just black and white and both architectural concepts have their pros and cons. However, I think we can learn from the Microservices movement to improve and modernize our traditional SOA systems.

Microservices (more...)

Next Step in Row generation in Oracle Database 12c SQL using JSON_TABLE

One of those things SQL developers are frequently looking at is the generation of rows: having a query return records that do not really exist. For example to generate test data or to produce records for all days in a month. Tom Kyte usually selects from data dictionary views. Various tricks make the rounds, for example based on CONNECT BY or CUBE or UNPIVOT. This blog article by Natalka Roshak (2015) compares various row generation (more...)

I dream of wires. Not

I’m a mega Gary Numan fan. I’ve loved his stuff since the Tubeway Army days (I sometimes use “Are ‘Friends’ Electric?” as a heading on my presentations about smart user experiences) and his records were some of the first I bought.

 One of my favorite Numan tracks is “I Dream of Wires” from the Telekon album. (the song was also covered by the late Robert Palmer). The lyrics tell the story of the (more...)

Garmin vívomove: Style Disconnect

I have been testing the latest Garmin vívomove activity tracker for real. Garmin has pretty much made their high-end wearable devices a no-brainer choice for the hardcore and committed athletics and fitness types, and I already use the mighty Garmin fēnix 3

However, Garmin is also not content to leave the rest of the sports watch market to Fitbit and friends and the activity tracker market is now a large part of their business. The (more...)

Publishing applications to Application Container Cloud Service from Oracle Storage Cloud

This weekend, while preparing for a demo during Oracle OpenWorld 2016, I found a for me new way of publishing a new [version of an]application to Application Container Cloud: through Storage Cloud. The application archive – zip or tar – can be stored on Storage Cloud and the deployment to ACCS can be performed from Storage Cloud. I am not yet sure if this makes for a better automated workflow. What it does give me (more...)

IoT Workshop Guide – part 2

In last p`ost, we have setup development environment for coding and uploading scratches to NodeMCU, an IoT device.

This post, we will upload and run two examples to demonstrate how IoT device sending data into Cloud and receiving commands from Cloud.

4. Architecture Diagram

It involves several tiers and components to make the whole IoT loop. However, you will just focus on device communication with MQTT, all other components have been setup properly.



5. (more...)

IoT Workshop Guide – part 1

AppsLab and OTN will jointly host IoT Workshop at Oracle OpenWorld and JavaOne conference in 2016. We look forward to seeing you at the Workshop.

Here is some details about the Workshop with step-by-step instructions. Our goal is that you will learn some basics and get a glimpse of Oracle IoT Cloud Service at the workshop, and you can continue playing it with IoT package after going home. So be sure to bring your computer (more...)

You are in trouble when more than 8 kernel options are enabled in oracle executable

A brief headsup for everyone responsible for maintaining kernel options in the oracle executable.

The environment where I discovered this is a 3 node racattack cluster with Oracle GI & RDBMS After enabling Unified auditing in my database I noticed that all of a sudden database startup started failing with an almost  unlimited amount of core dump files being generated.

SQL*Plus: Release (more...)

For OpenWorld and JavaOne 2016, An Internet of Things Workshop


Want to learn more about the Internet of Things?

Are you attending Oracle OpenWorld 2016 or JavaOne 2016? Then you are in luck! Once again we have partnered with the Oracle Technology Network (OTN) team to give OOW16 and JavaOne attendees an IoT hands-on workshop.

We will provide a free* IoT Cloud Kit so you can get your feet wet on one of the hottest emerging technologies. You don’t have to be an experienced electronic engineer to (more...)



How to solve JSchException Algorithm negotiation fail. And get logging out of JSch in SoapUI.

I was so glad with my SoapUI solution to SFTP files to a server. But so dissapointed I couldn't have it working at my customer.

After I changed the log entries to log with e.message, I got the line:
Wed Sep 07 11:17:43 CEST 2016:INFO:JSchException Algorithm negotiation fail

Now I needed more information than that. But the hint is at least that there is a mismatch in the available cyphers client side verses server (more...)

Use SoapUI to test your SFTP based services

SoapUI is my favorite tool to do unit tests. I'd try to keep my self to test based development and build up tests along with the development service. For SOAP or REST based services this goes quite intuitively using SoapUI. For database driven it is a little harder, but SoapUI has a nice JDBC activity, that supports DML as well as callable statements as stored procedures.

But for files and especially SFTP its a little (more...)

First steps in deploying Node.js on Heroku

Recently, I used Heroku to deploy a website in the great wide open!
In this blogpost I want to tell about my first steps using Heroku, including the rookie mistakes I made: so you don’t have to make them.

Heroku in a nutshell:

“Heroku is a cloud platform that lets companies build, deliver, monitor and scale apps”
You can deploy your NodeJS application (or Rails or..) there with a simple git push.
The app (more...)