Category Archives: Service Bus

Installing Ubuntu 11.04 in VirtualBox

This post will show you how to install Ubuntu 11.04 in VirtualBox (Recently a post on installing Ubuntu 12.04 in VirtualBox became available and even more recent installing Ubuntu 13.04 in VirtualBox). In later posts this will be used to run: JRockit 64 bit, WebLogic Server (WLS) and Oracle Service Bus (OSB).

Prepare Ubuntu install in VirtualBox

A short recipe for preparing the Virtual Machine to install Ubuntu on it. The blog post Installing Ubuntu inside Windows using VirtualBox is more extensive on this subject…

  • Create a new Virtual Machine using the VirtualBox Manager
  • Click Next in the Welcome screen
  • Choose a Name for the Virtual Machine and select the Operating System (OS) before you click Next
  • Set the amount of memory you want to allocate to the Virtual Machine
  • When asked for the Virtual Hard Disk, check the Boot Hard Disk box and Create a new hard disk. Then the Create New Virtual Disk Wizard will start guiding you through the process
  • I choose a Fixed-size storage when asked for the Hard Disk Storage Type
  • Choose the Size (16 GB) and Location (left it default) for the Virtual Hard Disk
  • Check the summary
  • Watch the progress while the .vdi file is created
  • Click Finish to acknowledge the creation of the new Virtual Machine
  • The newly created Virtual Machine will show up in the VirtualBox Manager
  • In order to install Ubuntu 11.04 on the Machine go to the settings to alter the storage settings
  • Use the icon besides the IDE Controller to add the disk image – ISO file – you downloaded to boot and install Ubuntu as media in a drive
  • Check the boot order and make sure that the Machine is booted from the CD/DVD device first
  • Acknowledge
  • Start the Virtual Machine and the “regular” installation of Ubuntu will start

The screenshot that come with the short instructions above:

Ubuntu install

  • Boot the installation ISO
  • Choose Install Ubuntu and your language
  • Preparing to install Ubuntu – You don’t need the additions here to later install WebLogic Server and Oracle Service Bus
  • Allocate drive space – If you created a new Virtual Disk before you can safely erase the empty disk here
  • Erase disk and install Ubuntu – Acknowledge
  • Choose location and time zone
  • Keyboard layout
  • Who are you – Fill in the username, computer name and password
  • Welcome screen
  • Installation is complete – click the button to restart
  • Login as the user you just created

Watch the screenshots that come with the steps above:

Installing VirtualBox Guest Additions

  • From the VirtualBox Manager menu choose the Devices - Install Guest Additions options
  • Choose the application to start
  • Click Run
  • Authenticate with your password
  • You need to restart Ubuntu to make it work

Watch the screenshots that come with the steps above:

ESB: No WebService Provider is registered at this URL

When you are using Oracle ESB 10g and encounter the message No WebService Provider is registered at this URL when testing a web service from the ESB Console try the following:

Oracle Enterprise Manager OC4J_SOA


Verify the ESB web service providers are generated correctly in ESB runtime (known as the esb-rt):

  • Login into Enterprise Manager
  • Go to the Application Server Control
  • Click OC4J_SOA oc4j instance
  • Click Web Services tab
  • Verify the deployed web services are listed here, and test that services.

In case there are no web service from the ESB runtime (esb-rt) the service providers were not generated correctly, restart ESB-RT:

  • Click OC4J_SOA oc4j instance
  • Click the Applications tab
  • Expand Middleware Services, ESB and esb-dt
  • Check the esb-rt and click the restart button

Now check the j2ee/_instance_name_/log/*/oc4j/log.xml to see if the ESB application has started correctly. Verify that ESB-RT application is initialized correctly by searching for ‘ESB bootstrap: Runtime initialized‘ message in the log file. If you also restarted the ESB-DT, verify that ESB DT application is initialized correctly by searching for ‘ESB bootstrap: Repository initialized‘ message in the log file. And finally check that the ESB web service providers were generated correct (see above).

Purging BPEL and ESB instances

The question on the ability to purge instances for both Oracle BPEL and Oracle ESB keeps recurring so I decided to come up with a small overview.

Oracle BPEL

  • FMW version and up, there is a new version of the purge_soainfra_oracle.sql. Ensure that you run the purge setup scripts from the RCU or RCU location, respectively, as this contains the latest purge details. Details are in the SOA Admin Guide
  • FMW version and up, there is a purge_soainfra_oracle.sql script in the RCU_HOME/rcu/integration/soainfra/sql/purge directory. In the release before you need to apply patch 10297850 to obtain the updated purge scripts. More details are in the FMW Admin Guide on Managing Database Growth. Mark Kelderman posted on how to improve the performance of this script by adding a specific index.
  • From BPEL in SOA Suite version and up, there is a purge_instances_oracle.sql script in the SOA_HOME/bpel/system/database/scripts directory.
  • For BPEL in SOA Suite version you need patch 7162289. After applying this patch purge_instances_oracle.sql will be located at SOA_HOME/bpel/system/database/scripts.
  • In case you’re still running BPEL check Oracle support document 398578.1 and document 341102.1

Oracle ESB

  • For Mediator in FMW 11g refer to the scripts and links mentioned in the BPEL paragraph.
  • To purge ESB instances in you need to apply at least MLR#4 to have purge scripts available. There are 3 scripts available:
  • $ORACLE_HOME/integration/esb/sql/other/purge_by_date.sql

Update 2011-06 SOA Suite 11gR1 PS3

Recently the SOA Suite Engineering Team published a presentation on Purging strategies in Oracle SOA Suite 11gR1 PS3. Besides the information presented in this post, the presentation goes into targeted deletion from the EM and looks into looped and parallel purges. It also mentions the use of database partitioning. That can be very useful when you have long running instances and a large installation (the presentation gives more than 500GB total OR more than 10GB daily depending on environment specifics).

Update 2011-07 Purging the Extreme Edition

Mark Kelderman posted a blog on Purging SOA Suite 11g Extreme Edition. He give a SQL script that deletes data from Mediator, BPEL, BPM, Workflow and Composite, and after that reclaims disk space.

Update Purge Oracle Service Bus

Marc Kelderman posted on his blog on Purging OSB Report Data. Besides the default way to delete the data using the console. He also gives a SQL script to purge directly in the database.

SOA 11g database growth strategies

In January of 2012 the Oracle Fusion Middleware whitepaper on database growth strategies was published. The advice presented should facilitate better dialog between SOA and Database administrators when planning database and host requirements. An important aspect of the whitepaper is purging of the SOA database.

Related documentation:

Updated purging strategies on Oracle Support

purging in OFM 11gAs part of the Oracle Fusion Middleware (FMW) SOA 11g Infrastructure Database: Installation, Maintenance and Administration Guide [ID 1384379.1] A purging guide has been published to offer strategies and procedures for managing database growth in a production SOA 11g implementation.
Purging is not supported for MS SQL Server out of the box or through a patch in any version of 11g. The provided scripts can, however, be used as a solid base from which to create usable purge scripts for SQL Server.

InfoQ videos: Using a Service Bus to Connect the Supply Chain

The session I presented at the SOA Symposium 2010 is now available online via InfoQ. You can find it as a Service Bus case study. It is introduced as:

a case study of using a service bus in a supply channel connecting a wholesale supplier with hundreds of retailers, the overall context and challenges faced – including the integration of POS software coming from different software providers-, the solution chosen and its implementation, how it worked out and the lessons learned along the way.

Watch the video, download the mp3 or sheets.

Install OSB next to VirtualBox SOA Suite 11g Appliance

In this post will show you how to install the Oracle Service Bus on the VirtualBox SOA Suite 11g appliance. For this demo we used a pretty straightforward installation scheme.

Oracle WebLogic Server installation

Download wls1033_oepe111150_linux32.bin for installation on Linux. Install using the command ./wls1033_oepe111150_linux32.bin:

Install WebLogic 10.3.3

The following screenshots will give you a good idea of the installation flow.

Oracle Service Bus installation

Start the Disk1/ and specify the JRE/JDK location /oracle/osbhome/jdk160_18/.

Install Oracle Service Bus

This sequence of screenshots gives you a good impression.

Configure a WebLogic Domain

Configure a Domain using the Oracle Fusion Middleware Configuration Wizard using ./ in the /oracle/osbhome/oracle_common/common/bin directory.
Configuring a WLS Domain
A straightforward configuration of the WLS Domain requires the following steps:

Start WebLogic

./ and Have Fun!

Using a Service Bus to connect the Supply Chain

So here is my presentation from the SOA Symposium 2010. Hope you enjoy it:

SOA Cloud 2011 Brazil

SOA Cloud Symposium 2011

The SOA Cloud Symposium 2011 logo has just been released. In 2011 the SOA Symposium will be held on April 27 and 28 in Brasilia the capital of Brasil.

Configuring SOA Infrastructure for SOAP optimization

SOA Infrastructure Common SettingsIn the 10g release of Oracle SOA Suite you could set properties to instruct web service calls to go via SOAP or not. If you were calling services on the same server or domain you could gain some performance with a native call and avoiding the SOAP overhead. To do this you would set the optSoapShortcut property.

With SOA Suite 11g on WLS SOAP optimization is automatically configured. In the scenario where you upgraded to 11g R1 and are using this optimization shortcut approach, you should specify the Server URL in the SOA Infrastructure Common Settings. Optimized calls are only active when the host name value (referred to as WSDL URL in the composite.xml) matches the Server URL.

To configure the SOA Infrastructure Common Settings choose from the SOA Infrastructure Menu > SOA Administration > Common Properties. As shown in the screenshot. Other access ways to this configuration screen are described here.

Set the Server URLEnter the server URL in the Server URLs section. This URL is published as part of the SOAP address of a service in the concrete WSDL file. Either set both values to the host name (for example, myhost) or to the full domain name (for example, If these values do not match, a regular SOAP call is performed instead of an optimized local call.

One of the scenarios that you have to set the Server URL in order to use the optimized local call is after a migration of AIA to AIA 11g R1.

Restart a failed AIA 11g R1 installation

In this blogpost I’ll share some steps you can take to get your AIA 11g R1 installation back on track. If you do not perform the Pre-Installation Configurations as described in the Foundation Pack 11g Release 1 ( Installation Guide (available as partnumber E17949-01 via eDelivery), it is possible that your AIA installation fails. After checking the pre-installation configuration it is possible to start the installation again if you follow these steps:

  1. Navigate to /user_projects/domains/ and delete the edit.lok file.
  2. Delete any file located in /user_projects/domains//pending
  3. Log into the weblogic console and activate all the changes.
  4. Restart SOA Suite and Weblogic domain.
  5. Press retry button on the installation screen

If the installation screens are no longer available because you closed them, use the log files to figure out what targets haven’t been performed yet and run these targets (in the sample case below it were Deployments and PostInstallScript):

Move to the /aia30/aia_instances/aia30poc/bin and source ./

ant -f /aia30/Infrastructure/Install/AID/AIAInstallDriver.xml -DDeploymentPlan=/aia30/config/FPInstallDP.xml -DPropertiesFile=/aia30/config/AIAInstallProperties.xml Deployments

ant -f /aia30/Infrastructure/Install/AID/AIAInstallDriver.xml -DDeploymentPlan=/aia30/config/FPInstallDP.xml -DPropertiesFile=/aia30/config/AIAInstallProperties.xml PostInstallScript

SOA Suite 11gR1 PS2 notes and blogs

In the blogpost on the release of SOA Suite 11gR1 PS2, I mentioned a link to the documentation index. Since it hasn’t been update by now, I suggest you go to the middleware documentation page. This page is more up to date and has the link to the web library and download address (Alert! approx. 860 MB) of E14571-01 – the Fusion Middleware Online Documentation Library 11g Release 1 (

SOA Suite 11gR1 PS2 installation notes

Besides the reference in the documentation library to the Install Guide and the Quick Install Guide, there are several blogs describing the installation of Which is actually a patch on

SOA Suite on Amazon EC2

This week it was announced that BPM 11g R1 is available as an Amazon Machine Image (AMI). This AMI includes SOA Suite 11gR1 Patchset 2 and JDeveloper with the SOA and BPM extension. In AWS filter on 64-bit and put soa-bpm in the search box. This should enable you to find oracle-soa-bpm-11gr1-ps2-4.1-pub. Some of the tips I posted on x SOA Suite in the cloud could be useful here as well.

Running SOA Suite 11g on your workstation

Fusion Middleware 11gThere are several advantages when working in a project with Oracle SOA Suite to have a local installation of the SOA Suite on your workstation. While developing and trying bits of code you can’t break other peoples work as you can on a central server. Running FMW 11g on a workstation with say memory on the low end of the spectrum can be challenging. In this blog I’ll show you some additional (to this previous post) measure that my blogless colleague Rob Heikoop came up with.

Rob came up with two things:

  • Create an All in One AdminServer as described on the Oracle wiki. We skipped BAM in the installation Use only one Domain in WLS. You’ll have to combine the admin en the SOA_domain. Running just one domain saves memory.
  • Keep the database centralized. In the central database each developer has it’s own SOA schema that is especially created for him. To do this run the RCU for every developer and use the prefix to reflect for example the developers initials (example of using RCU on slideshare). Not running the database on your workstation saves memory and CPU.

In order to have new developers being able to use this quickly we copy the reference installation (with plug-ins, patches and the works) and alter the configuration:

  • Alter the scripts in the C:\Devel\SOAMiddleware\user_projects\domains\soa_domain\bin directory to reflect your workstation name instead of that of the reference machine. You can do this easily by using an editor like Notepad++ and use Search > Find in files > Replace in files. Otherwise you’ll be stopping your teammates server…. (again sorry Rob)
  • Change the configuration files in C:\Devel\SOAMiddleware\user_projects\domains\soa_domain\config\jdbc to reflect the prefix created especially for you while using the RCU. Again Notepad++ can help you here.

Now you can start the tools:

  • WebLogic Server: C:\Devel\SOAMiddleware\user_projects\domains\soa_domain\bin\startWebLogic.cmd
  • JDeveloper: C:\Devel\SOAMiddleware\jdeveloper\jdeveloper.exe