PaaS & Middleware Partner YouTube Update October 2016

The October edition of the PaaS & Middleware Partner Update contains three key topics:

· Oracle OpenWorld 2016 summery

· PaaS Summer Camps training material & cloud accounts

· SOA & BPM Partner Community Webcasts October 25th 2016

For regular updates please subscribe to our YouTube channel here. For the latest SOA & BPM Partner Community information please visit our Community update wiki here (Community membership required)

SOA & BPM Partner Community


Integration Cloud Service – Promote Integrations from Test to Production (T2P) by Shreenidhi Raghuram


The purpose of this blog is to provide simple steps to move Oracle Integration Cloud Service (ICS) integrations between different ICS environments. Oracle ICS provides export and import utilities to achieve integration promotion.

A typical use-case is to promote tested integrations from Test ICS Environment to Production ICS Environment, in preparation for a project go-live. Usually the Connection endpoints used by the integrations will be different on Test and Production Environments.

The main steps involved (more...)

My Favorite Scripts – 2016

I did a talk at the Dallas Oracle Users Group Technical Training Day which was held on Oct 20th. The title was My Favorite Scripts and basically talked through some of the scripts I use most often and logged on to a system and showed how they work. I promised I would upload the presentation and a zip file here. So here you go.


My Favorite Scripts 2016 – Presentation

My Favorite Scripts 2016 (more...)

Leveraging the Twitter Adapter in ICS – Tweeting through Oracle Integration Cloud Service by Lucas Jellema


The Oracle Integration Cloud Service – ICS – comes loaded with a rich collection of Cloud Adapters. These adapters facilitate the integration with SaaS applications and internet services of various natures. These include Oracle SaaS applications (such as RightNow, Eloqua, ECommerce Cloud, ERP Cloud, HCM Cloud), on premises ERP applications (SAP, EBusiness Suite, Siebel) and assorted third party applications such as SalesForce, Facebook, Google Mail and Task, LinkedIn and Evernote. Through these adapters, interacting with (more...)

Transactions and SCNs

It’s general knowledge that the Oracle database is ACID compliant, and that SCNs or ‘system change numbers’ are at the heart of this mechanism. This blogpost dives into the details of how the Oracle engine uses these numbers.

Oracle database version
Operating system version: OL 7.2, kernel: 4.1.12-61.1.14.el7uek.x86_64 (UEK4)

Redo generation
Whenever DML is executed, redo is generated in the form of ‘change (more...)

Lethal Combination Unpacked in Bucharest’s TechHub

Check out the report of the awesome Vector and Oracle Applications User Experience co-hosted event held at Bucharest’s TechHub.  

The evening’s interactive sessions focused on engaging the digital community there on the topics of cloud and wearable technology user experience.

Who will leave their Apple Watch to their grandchildren? Enablement in Digital Romania

Special care was taken to ensure all aspects of the event were well balanced:


(Guinness versus Murphys)

Watch out (more...)

Oracle Health Check

Currently, I am working on health check for ODA and find there are too many tools with disparate information.

I am sure there are more than the ones listed below and stopped searching.

ODA Oracle Database Appliance orachk Healthcheck (Doc ID 2126926.1)
Multiplexing Redolog and Control File on ODA (Doc ID 2086289.1)

ORAchk – Health Checks for the Oracle Stack (Doc ID 1268927.2)
How to Perform a Health Check on the Database (more...)

Reminder: EBS 12.2 Minimum Patching Baselines and Dates

Oracle E-Business Suite 12.2 is now covered by Premier Support to September 30, 2023. This is documented here:

Oracle Lifetime Support table for EBS

Premier Support includes new EBS 12.2 patches for:

  • Individual product families (e.g. Oracle Financials)
  • Quarterly security updates released via the Critical Patch Update process
  • New technology stack certifications with server-based components
  • New certifications for end-user desktops and mobile devices

What are the minimum patching baselines for EBS (more...)

Create an Integration on ICS to expose a REST API for a SOAP Connection for an external web service by Lucas Jellema


In this article, I will show a little bit more of ICS – the Integration Cloud Service. In a previous article, I have introduced some concepts – such as Connection, Integration, Business Identifier. I have shown how to create an integration connecting two connections – an inbound and an outbound one (both of type SOAP).

In picture, that looks like this:

In this article, I will create a new connection (REST API style) and (more...)

EM13c: Get List of URLs Monitored by Beacons

When you need to monitor web services, you can use EM beacons. A beacon is a target that allows the EM Agent to remotely monitor services. You can add beacons to any EM agent using “Add Non-Host Targets by Specifying Target Monitoring Properties” option in the Add Targets Manually page. After adding a beacon, you can configure it to fetch a web page and test the status of the service according to the result of (more...)

While upgrading to I faced error ORA-01830 / ORA-06512

The other day I was running an upgrade for a client that is using ACLs ( Access Control Lists) from to If you have been doing upgrades to 12c, you know that when running the -n 4 catupgrd.sql it entails 73 steps. So this upgrade failed in step 65 with the following error (I have trimmed the output for reading purposes) :

Serial   Phase  (more...)

Data Visualization Desktop Data Flow Component

My previous post contained a brief description of Data Visualization Desktop (DVD) new features in, in terms of sources, visualisations and components. In this post we're going to simulate a typical analyst use case and understand how DVD can support the process.

Data Visualisation Desktop is a tool aimed at departmental analysis, with data coming from different sources and results that need to be delivered quickly. Given the ad-hoc nature of (more...)

Conjuctive Normal Form

I recently tweeted about a comment I’d picked up at the Trivadis performance days regarding tablescans and performance.

“If you can write your SQL in conjunctive normal form it can help the optimizer to offload more predicates”

Inevitably someone asked me if I had an example to demonstrate this – I didn’t, and still don’t really, but here’s an interesting demo based on an example from the Oracle In-Memory blog showing how the optimizer will (more...)

Oracle EMPTY_CLOB Function with Examples

In this article, I’ll explain what the EMPTY_CLOB function does and show you an example of how to use it. Purpose of the Oracle EMPTY_CLOB Function The EMPTY_CLOB function is used to initalise a CLOB column to EMPTY. It can be used in several places: In an INSERT statement In an UPDATE statement Initialising a […]

Oracle Forms & Reports available

Since a few hours the latest Release of the Oracle Forms & Reports is available for download in Oracle Technology Network under

The related documentation can be found under

For all the lovers of Oracle Reports, here is the bad news: It's time to prepare for bye-bye !

The next planned Oracle Reports will be the terminal release for Oracle Reports !

Note can be found here

Weblogic available

Since a few hours the latest Release of the Oracle WebLogic Server is available with Oracle Technology Network for download.

The Installation sources can be found under:

The documentation for the latest Oracle WebLogic Server can be found under

VirtualBox 5.1.8

VirtualBox 5.1.8 has burst through the chest of it’s host organism.

Downloads and changelog are in the usual places. It’s a maintenance release, so there are a bunch of bug fixes in there.

I’ve installed it on macOS (Sierra), Windows 7 and Oracle Linux 6 with no problems.SO far no dramas. 🙂

Happy upgrading!



VirtualBox 5.1.8 was first posted on October 19, 2016 at 2:19 pm.
©2012 "The (more...)

Data Visualization Desktop

Yesterday Data Visualization Desktop (DVD) Version was released. DVD, since its first release, aims to extend Oracle's Data Visualization portfolio by adding a desktop tool allowing data visualization capabilities directly to end users without the intervention of the IT department, in line with the Gartner's bi-modal IT.

The new version adds several capabilities to the existing product like visualization types, data sources and a wrangling option. This post will share the (more...)

Install cx_Oracle for Python

This shows you how to install the cx_Oracle library for Python 2.7 on Fedora Linux. If Fedora has it on the server you can download it with the following yum command:

yum install -y cx_Oracle-5.2.1-11g-py27-1.x86_64.rpm

Currently, you’ll get the following failure because it’s not available in the Fedora repository:

Loaded plugins: langpacks, refresh-packagekit
mysql-connectors-community                                      | 2.5 kB  00:00:00     
mysql-tools-community                                           | 2.5 kB  00:00:00     
mysql56-community                                               | 2.5  (more...)

Bulgarian Oracle User Group (BGOUG) Autumn 2016 Conference

bgougIt’s been over two years, but I’m finally going back to my second home. I’m presenting at BGOUG Autumn 2016 Conference. 🙂

I get back from the OTN APAC Tour, go to work for three days, then I’m off to Bulgaria. I figure if I confuse my body enough it won’t recognise how many time zones I’ve travelled through…


At the moment it looks like this is the last event I’m presenting at in 2016, (more...)