Run SQLcl from ANT

I think since last year ORacle released SQLcl which could be seen as the commandline variant of SQL Developer. But even better: a replacement of SQL Plus.

A few years ago I created what I called a InfraPatch framework, to do preparations on an infrastructure as a pre-requisite for the deployment of services and/or applications. It can run WLST scripts for creating datasouces, jms-queues, etc.  It also supported the running of database scripts, but (more...)

OSB 12c Customization in WLST, some new insights: use the right jar for the job!

Problem setting  and investigation

Years ago I created a Release & Deploy framework for Fusion Middleware, also supporting Oracle Service Bus. Recently revamped it to use 12c. It uses WLST to import the OSB service to the Service Bus, executing the config file.

There are lots of examples to do this, but I want to zoom in on the execution of the customization file.

The WLST function that does this, that I use is as (more...)

Create the SOA/BPM Demo User Community, with just WLST.

As said in my previous post (I've learned somewhere you should not post twice on the same day, but spread it out over time), I'm delivering a BPM 12c training. And based it on the BPM Quickstart. Although nice for UnitTests and development, the integrated weblogic lacks a  proficient set of users to test your task definitions.

Oracle has a demo community and a set of ANT and Servlet based scripts to povision your SOA (more...)

BPM Exception when deploying BPM project with Human tasks

This week I deliver a BPM 12c Workshop, that I based on the BPM QuickStart. When the students worked on the lab on Human Workflow, they hit an error deploying the Composite, where in the log you can find something like:

Caused By: oracle.fabric.common.FabricException: Error occurred during deployment of component: RequestHolidayTask to service engine: implementation.workflow, for composite: HolidayRequestProcess: ORABPEL-30257

exception.type: ERROR
exception.severity: 2

Oracle x Girl Geek Dinner definitely does compute

Oracle hosted its first Girl Geek Dinner last Thursday, December 7, 2017. The dinner was 18 months in the making. With at least 400 women and men in attendance, it is the largest Girl Geek Dinner of the year.

Alexa Push Notifications via Reminders

From the first day I got the Amazon Echo in December 2014 I looked for more interesting ways to interact with it. Before the Alexa team released an official API, I came up with a rather creative way to control things . It was not perfect since I had to add things to the “todo” list and then poll private APIs for changes. A few months later the official API came and things have been (more...)

OSB: Disable Chunked Streaming Mode recommendation


These weeks I got involved in a document generation performance issue. This ran for several months, maybe years even. But it stayed quite unclear what the actual issue was.

Often we got complaints that document generation from the front-end application (based on Siebel) was taking very long. End users often hit the button several times, but with no luck. Asking further, it did not mean that there appeared a document in the content management (more...)

BPM BAC Subversion Server refusing connections Revised

A little background

In April I wrote about our BPM Server installation, that is actually a single host cluster on dev and test. But installed like it was a dual-node  server, so we had a cloned domain.

A BPM installation has a component that is called the Process Asset Manager. Under the hood it uses a replicated SubVersion server. Each node has one, so they had to synchronize. But since we're on the same host, (more...)

SOASuite 12c: keep running instances using ANT

At my current customer I implemented a poor man's devops solution for Release and Deploy. It was based on a framework created as bunch of Ant projects, that I created years ago. It was based on scripts from Edwin Biemond. See for instance here, here and here. I never wrote about my solution, because although I refactored them quite intensively, the basics were already described thoroughly by him.

What I did was that I (more...)

Enable WebService test client on SOA/BPM production mode environments

At my current assignment I need to trouble shoot the identity service because of a BPM->OID coupling. I use the support document 1327140.1 for it, that suggest to test http://<soa-server>:<port>/integration/services/IdentityService/identity

Doing so in a production mode soa or bpm environment, you'll soon find out that it uses the WebService test client via uri /ws_utc, and that this does not work. Resulting in http-404 Not found errors.

First I found a blog of Maarten of Amis (more...)

Jeremy on the Role on Emerging Technology

Here’s a video from our Group Vice President, Jeremy Ashely (@jrwashley)  about Emerging Technology and how it should be helping people to use the system. This is a nice, concise description of what we do and why. Related Posts:

IoT Cloud Brewed Beer @ OOW: The Details

Now that Oracle Open World has come and gone, I have some time to go into the details of how this project was conceived and realized, and how it faired at OOW.  Let’s start with that last one.

I guess to no one’s surprise, the actual booth with (free!) beer was a crowdpleaser;  we blew through the stock of 12 kegs with time to spare.

Lines for IoT Cloud Brewed Beer

Lines for IoT Cloud Brewed Beer

That’s roughly (more...)

IoT Workshop and Robots

AppsLab has been offering the IoT Workshop since Oracle OpenWorld 2016. And over past one year we have hosted the workshop in 20 cities around world as part of Oracle Code events, plus at Kscope 2017 conference. And if you still managed to miss all the events,  Oracle OpenWorld 2017 might be your last chance 🙂

IoT device kit for workshop participants

IoT device kit for workshop participants

Just come by Oracle Developer Community Lounge in Moscone West (no pre-registration (more...)


In this post I will simultaneously have Fun With Data and Fun With Maps. I will use public APIs to turn my Isle of Alameda into a “choropleth“, a map which displays areas that are colored or patterned in relation to data.

To do this I will need to find boundaries within Alameda that I can associate with data of some kind. For this I turn to the ultimate source of geographical data (more...)

IoT Cloud Brewed Beer @ OOW

For the past few months we have worked together with the Oracle Developer Community and Alpha Acid Brewing on a secret IoT project.   Come see (and taste!) it at the Developer Lounge in Moscone West during Oracle Open World.

Hope to see you there!


Mark.Possibly Related Posts:

Oracle Code – Recap

Oracle Code 2017

March 1, San Francisco, USA – August 30, Seoul, South Korea
183 days (exactly 6 months), 20 cities around the world
thousands of speakers, OTN staff and local consultants
hundreds of thousands of participants and coders

That’s the Oracle Code 2017 tour, presenting current and upcoming technologies in packed sessions, providing Oracle cloud services lab for hands-on experience, and a relaxing and fun Code Lounge to be inspired! It is a large (more...)

The Isle of Alameda

The best way to learn how to make your own maps is to map someplace familiar. The place I live, Alameda, is an island in the San Francisco Bay, but existing maps don’t do it justice.

So as part of my Fun With Maps project I set out to disentangle Alameda from the urban sprawl that surrounds it and, using open source data, make a cleaner map that captures the windblown isolation of a real (more...)

Implementing the KeyStore Service with Fusion MiddleWare 12c

For the passphrases, use the passphrases used earlier.Thinking about TLS (Transport Layer Security, the succesor of Secure Socket Layer, SSL) and WebLogic and Oracle HTTP Server, allways gave me Cold Water Fear. You have to create keystores with keys, wallets, certificate signing requests, import signed and trusted certificate chains. Not to mention the configuration of WebLogic and OHS.

Now, creating keystores with the Java Keytool turns out not that hard. And generating the Certificate (more...)

Welcome NAO

On a quiet Thursday morning, I went to our Gadget Lab at Oracle HQ and turned on the light. Inside the comfy egg shell chair sat an NAO robot, waiting for me.

NAO inside of egg-shell chair

Welcome NAO, our latest team member!

NAO is a little adorable humanoid robot created by SoftBank Robotics. It can talk, walk, and dance; it can read stories to babies; it can have a conversation with adult human…… (more...)

Fun With Maps

Maps are one of the oldest and most powerful forms of visualization. Lately I’ve been learning how to make my own maps using open source data and public APIs.

I started by simply plotting locations on a world map. World maps in svg format are readily available on the web. Wikimedia Commons, for example, has free maps in a variety of formats. The simplest is an equirectangular projection.

It’s dirt simple to plot locations on (more...)