Category Archives: Oracle

OTech Magazine – Winter 2014

OTech Magazine winter 2014The winter edition of OTech Magazine, the independent magazine for Oracle professionals, is available. In OTech Magazine – Winter 2014 subjects include:

  • Time Series Forecasting in SQL
  • Flashback – Empowering Power Users
  • Starting WebLogic
  • DevOps and Continuous Delivery for Oracle
  • The Rapid Reaction Force – real time business monitoring

Download OTech Magazine Winter 2014 here.

OTech Magazine – Summer 2014

OTech magazineThe fourth issue of OTech Magazine, the independent magazine for Oracle professionals, is available. For the summer 2014 issue there are some more personal articles included. Titles vary from The Spiritual Programmer to The Next Generation: Oracle SOA Suite 12c and back via How to protect your sensitive data using Oracle Data Vault.

Download OTech Magazine – Summer 2014 here.

Article on integration infra components published in OTech magazine

article OTech magazine - integration infra componentsDuring Oracle Open World 2013 OTech magazine was launched. OTech is a new independent magazine for Oracle professionals. The magazine’s goal is to offer a clear perspective on Oracle technologies and the way they are put into action. As a trusted technology magazine, OTech Magazine provides opinion and analysis on the news in addition to the facts.

My article in OTech magazine one of the most frequently asked questions is how to pick the right integration infrastructure component to solve the problem at hand.

Download the fall issue of OTech magazine.

Lean, agile and Software development reading list of 2013

In this blogpost I’ll share a list of books I read during the first six months of 2013.

Hadoop – The definitive guide

Hadoop the definitive guideThis book proved very useful to get an introduction and solid background in Hadoop. I was reading it a little before starting an enhancement of MapReduce code. This made it possible to better understand the production code and how to make the changes.

Hadoop The Definitive Guide (amazon) is recommended for anyone interested in Hadoop stuff.

Essential scrum

Essential ScrumWanted to read Essential Scrum to renew and deepen my theoretical knowledge of Scrum. This is a great read for that purpose!

I like the visuals that are used and set it apart from other books on the subject. Besides that I liked the MindMap-like figures that support the stucture in the chapters.

The scope goes beyond the core of Scrum and does that well. It also touches on subjects like Multilevel and Portfolio planning, The role of managers in Scrum context, and Product Planning.

This is a great follow up read for anyone with basic Scrum training or certification. It doesn’t just offer the big picture but both details and examples on how to become more agile. It will help you deal with the complexities of implementing and refining Scrum.

Thinking Fast and Slow

Thinking Fast And SlowThe aim of Daniel Kahneman the author of Thinking Fast and Slow is to enrich the vocabulary of people talking at a watercooler, where opinions and gossip are exchanged. He wrote this book to influence the way they talk about judgements and choices of others. He has succeeded. As Economist has put it: Kahneman shows that we are not the paragons of reason we assume ourselves to be. When you realise this it put you and the world around you in a different perspective.

Mr. Kahneman is a person that understands like no other on the planet how and why we make the choices we make. He knows how to share his insights! This is a great read for any curious mind, escpecially those with an interest in how and why we make choices.

This book will change the way you think.

There is an interesting talk on Thinking Fast and Slow by Mr Kahneman at the The Long Now.

Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement

Seven databases in seven weeksThe book Seven databases in seven weeks will take you on a tour visiting some of the hottest open source database today. This is typical software development reading.

It has a progressive style of offering insigts to databases and their capabilities. The open source databases covered are PostgreSQL, Riak, Apache HBase, MongoDB, Apache CouchDB, Neo4J, and Redis. These were chosen to span five database styles or genres: Relational, Key-Value, Columnar, Document and Graph.

This book is recommended for anyone looking for a solid introduction fo databases besides the traditional RDBMS. It will provide the knowledge you need to choose one database to suit your needs.

VirtualBox – Install Ubuntu 13.04

To install Ubuntu 13.04 in a fresh VirtualBox image, create a VirtualBox image as described in the blog post on installing Ubuntu 11.04 in VirtualBox. Focus on the Prepare Ubuntu install in VirtualBox section.

In the latest versions of VirtualBox you can choose multiple types of virtual disks (.vdi , .vmdk , et cetera). This is most relevant if you want to share your image across multiple virtualization platforms. If you have no specific requirements go with the default.

Install Ubuntu 13.04 in VirtualBox

  • Go to the settings of the newly created VirtualBox image;
  • In the storage section add an IDE Controller pointing to the installation disk: ubuntu-13.04-desktop-i386.iso for 32 bit or ubuntu-13.04-desktop-amd64.iso for 64 bit;
  • Ensure that you have asigned the VBox image enough processing power and memory;
  • Boot the installation iso by starting the VirtualBox image;
  • Watch Ubuntu 13.04 booting;
  • Choose your language and install Ubuntu;
  • After Ubuntu prepared it’s install and checks some stuff for best results, click Continue to go on with the installation;
  • In a new VirtualBox image you can safely choose to erase all stuff on disk and install Ubuntu (it will use ext4 as a file system);
  • Select the created VBOX Harddisk to do so. Choose install now;
  • Choose the location while Ubuntu continues creating the file system in the background;
  • While Ubuntu keeps copying files choose your keyboard layout;
  • Choose your name, the computer’s name, your username and password. For additional security you choose to encrypt your home folder;
  • Restart the Virtual Machine and log in;

VirtualBox Guest additions

The screenshots in the gallery also show how to install the VirtualBox guest additions in Ubuntu 13.04. Check this post for more details to install Vbox guest additions to install the VirtualBox guest additions.

VirtualBox VERR_VMX_MSR_LOCKED_OR_DISABLED solved

VirtualBox Manager VERR_VMX_MSR_LOCKED_OR_DISABLEDWhile creating a Ubuntu 12.10 machine VirtualBox I ran into an error – VirtualBox VERR_VMX_MSR_LOCKED_OR_DISABLED – on my company issued HP ProBook. This halts the startup process of the virtual machine. You won’t be able to use it.

Here is the complete log and a screenshot:


Failed to open a session for the virtual machine Ubuntu 12.10.

VT-x features locked or unavailable in MSR. (VERR_VMX_MSR_LOCKED_OR_DISABLED).

Result Code: E_FAIL (0x80004005)
Component: Console
Interface: IConsole {db7ab4ca-2a3f-4183-9243-c1208da92392}

I remembered that there were issue were issues with HP bios from the VirtualBox FAQ using ENABLE VT-X/AMD-V:

some HP BIOSES have a glitch, When You ENABLE VT-X/AMD-V, You DISABLE it, so do try both ways.

VirtualBox Enable VT-x AMD-VSo the first solution I tried was to uncheck the box to ENABLE VT-X/AMD-V. That solved my problem. Now VirtualBox was able to start my Ubuntu machine. Check the screenshot how to disable (or enable the) VT-X/AMD-V setting.

Yep, I know this is against the advice I gave to improve VirtualBox performance. However I need it on this hardware to get my machines running…

Configure BPM engine to publish to BAM

By default the Oracle BPM engine (Business Process Management) is configured so it won’t publish events to BAM (Business Activity Management). So should you choose to use BAM and use these great dashboards, you have set the DisableActions property to false/empty. Here is how it works to configure BPM to BAM:

  • Log in to the Fusion Middleware Control – http://bpm-host:7001/em
  • Navigate through the Farm – WebLogic Domain – select the domain and then select the Server in which BPM is running (soa_server1 in a default install)
  • Use the WebLogic Server dropdown menu as shown in the first screenshot
  • Select the System Mbean browser in the menu
  • Expand the folder ans shown in the second screenshot: Application Defined MBeans - oracle.as.soainfra.config - BMNNConfig - bpmn
  • Find the DisableActions property and remove it’s value
  • Apply the changes

Where do the JDeveloper extensions go?

Where does the downloaded stuff go after you installed JDeveloper extensions, like SOA Composite Editor, Oracle BPM Studio, or AIA Service Constructor?

On Windows you can find them here:
JDeveloper extensions location

C:\Users\_your_username_\AppData\Roaming\JDeveloper\tmp\update

Shouldn’t you be able to access the AppData directory, follow these instructions:

  • Go to the folder options, on Windows7 by clicking the Organize menu and the Folder and search options.
  • Choose the tab view.
  • Choose Show hidden files, folders and drives.

BPM Suite configure BAM Adapter

To have the BPM server push events to BAM – Business Activity Monitoring – we have to configure the BPM suite to use the BAM Adapter. The BAM Adapter is configured (like other SOA Suite and BPM Adapters) in the WebLogic Server Console.

Configure BAM Adapter

  • In the WLS Console, locate the Domain structure and select Deployments.
  • In the Deployments table that is shown, search and click the OracleBAMAdapter (you could filter on type Resource Adapter)
  • As shown in the first screenshot: Select the Configuration tab and within that the Outbound Connection Pools tab
  • Drill down on the oracle.bam.adapter.adc.soap.SOAPConnectionFactory to eis/bam/soap
  • In the properties tab: fill in the details of the connection to the BAM Server (depending on how you installed it). Remember to acknowledge the changes of each field using the enter key (leaving a field without using the enter key and changes will be lost)
  • Save
  • First time you alter the BAM Adapter you have to create a Deployment Plan. Select the Path to the deployment plan and Save
  • Since you need to update the Adapetr now, select it and chose Update
  • Choose the option Update this application in place with the new deployment plan changes and click Finish.

SOA Suite EM create partition

In Oracle SOA Suite 10g, or more specific BPEL 10g, one could group functionality in domains. This feature has been away in the early versions of SOA Suite 11g. They have returned in more recent version and can be used for all SCA composites (instead of BPEL only). Nowadays these 10g domains are called partitions.

Create SOA Suite partition

  • Login to the Fusion Middleware Enterprise Manager: http://server-name:portnr/em
  • Use the tree-view on the left and select soa-infra.
  • Use the SOA Infrastructure dropdown menu and select the Manage Partitions item.
  • SOA Suite EM Manage Partitions

  • The manage partitions page appears and you should select Create… to create your new SOA Suite partition.
  • SOA Suite Create Partition

  • Enter a name for the partition and press the create button.
  • SOA Suite Partition

While deploying SCA appications from JDeveloper or ANT you should add the partition from now on.