OWB11gR2 on Windows?

December 10, 2009 Oracle Warehouse Builder

So, OWB 11g R2 is out now, and has been for a few weeks – ever since the database version was released. But as a Windows version of the database hasn’t been released yet we are also stuck with Linux version version of OWB. Or are we? If you think about it, OWB is an application written in Java. So why should there be any real difference between the Windows release and Linux? At least that was my thought.

So, I set out to give it a go: Can I run the Linux installed version of OWB11gR2 on Windows? And the answer is simple: It’s easy as pie

First you need to download the stand-alone version linux version of the binaries. Follow the instruction and install the software on a linux box. I used an Oracle REL VM for this purpose. Once the installer has completed we need to copy the whole OWB home over to our Windows box (I used Windows XP VM). Once we get the 1GB directory copied over there are a few minor steps we must take:

  1. Make sure we have a java runtime to use. The Linux install will not include a Windows version of JRE/JDK. I had an Oracle DB installed on my VM so I used the JDK that came with that installation.
  2. Create a valid setowbenv.bat file that takes care of setting up the OWB runtime environment. The $OWB_HOME/bin/win32/ directory contains a template file, setownenv.tmp for this, so go ahead and make a working version.
  3. Run the owbclient.bat file from the £OWB_HOME/bin/win32/ directory and you are good to go



Since you need to connect to an OWB11gR2 repository, I simply followed the documents to run against an 11gR1 database on my VM. To put it simple you need to upgrade the pre-sseded OWBSYS schema that comes with all 11g Oracle instances to the R2 version. After that you are good to go …

UPDATE: To sum up the extra steps I have put in the comments here:

  1. To get the Control Center Agent running (the bit that takes care of the new Code Template technology): Edit the %OWBHOME%\owb\jrt\config\secure-web-site.xml file and fix the absolute path of the ssl-config keystore entry
  2. To get the Control Center Service running (the bit that takes (and always has taken) care of the regular mappings): Make sure that the %JAVAHOME% variable is set to a proper Java home, in the %OWBHOME%\owb\bin\win32\run_service_local.bat file. Then start the service using the local_service_login.bat script.
  3. /