OWB11gR2 on Windows?

December 10th, 2009 by

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

config.png

owb11gr2_on_windows.png

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. /

Comments

  1. Ragnar Wessels Says:

    Interesting.
    Likely unsupported by Oracle but good job.

  2. Borkur Steingrimsson Says:

    Thanks Ragnar.

    Good point. But I guess my point here is that you can start looking at OWB11gR2 even though you don’t have on-going access to a Linux/Unix box to test out. You can set up your repository on 11gR1 RDBMS and have a local 11gR2 OWB installation sitting next to your 10gR2/11gR1 client install of OWB

    But I can just imagine the surprise in the voice of your Oracle Support rep: You did WHAT??

  3. Jon Mead Says:

    Excellent, can we have OBIEE Administrator and Catalog Manager on Linux next please :)

  4. Borkur Steingrimsson Says:

    I guess some Wine might help there. Keep an eye on this blog ;)

  5. Rich Thayer Says:

    Wow, thanks! Never would have thought of that. I can now upgrade my customer to 11GR2.

    Great idea.

  6. Mark Rittman Says:

    Hi Borkur

    Good stuff. Do the Control Center Service and Control Center Agent Services run OK as well, in this form under Windows?

    regards, Mark

  7. Venkatakrishnan J Says:

    Nice one Borkur. I doubt whether Wine will get BI Admin to run on Linux as i did go down that route once but had stopped midway since BI Admin is not a self contained exe. It has quite a good number of dependencies on other files. But let us know how it goes, as always, in the blog :-)

  8. uli bethke Says:

    Nice one. Good thinking.

  9. Borkur Steingrimsson Says:

    @Rich Go for it ;)

    @Mark To start the CCA you need to fix one file, E:\oracle\product\owb\owb\jrt\config\secure-web-site.xml . The path to the ssl-config keystore is hard-coded to the original Linux OWB_HOME. Change it to fit where you copied OWB and it should start up w.o. any problems. I haven’t deployed anything to it yet, but I’ll report back here if I have any issues.

    @Venkat I guess I have my Friday evening plans set for me then!

  10. antonio romero Says:

    Borkur,

    You’re a very brave man.

    I wouldn’t recommend calling Support with any issues but I suppose people are welcome to try stuff… :)

    -Antonio

  11. Borkur Steingrimsson Says:

    @Antonio The real reason for me trying this was to get one VM with OWB11gR2 and OBIEE to run demos. This runs smoothly and doesn’t seem to have any problems at all. I promise I won’t call Support for help on this ‘hack’ ;)

    @Mark The Control Center Service runs fine as well, but since I am not using the JDK that should come with the OWB install I had to hard-code the %JAVAHOME% in the run_service_local.bat file to point to my own JAVAHOME. After that I ran local_service_login.bat -startup e:\oracle\product\owb to start the service. This gives you a chance to start both the CCA and the CCS

  12. Andy Pearce Says:

    Borkur – inspired idea!

    I managed to get round the JAVA_HOME hard coding issue by simply copying the directory structure of my jdk installation under the OWB Home, seems to work fine.

    Also, rather than upgrading an existing 11GR1 repository (I only had 10gR2 database available outside the VM), you can run the reposinst.bat script directly – once I created a blank rtrepos.properties file it ran through without error…

  13. Borkur Steingrimsson Says:

    Thanks for your feedback, Andy.

    Like you said, there doesn’t have to be an upgrade of an existing repository involved. At the time of my write-up I had an 11gR1 repo already on the same machine so I took that route. You could also be using an existing repo that matches your version or go for a clean new one. Both seem to work just fine.

    cheers
    Borkur

  14. Peter Says:

    Any suggestions on how to make this work on Windows 7?

  15. Mark M Says:

    Great find. Actually easier than waiting for the entire install.

    Rgds/Mark M.

  16. Danilo Says:

    Nice article congratulations.

    I’ve followed your instructions and I already have a repository in a 11gR2 DB outside the VM. When I start the OWB Design Center under Windows, it doesn’t prompt the connection dialog, so I can’t get access to my repository. How can I fix this?

    Thanks,

    Danilo

Website Design & Build: tymedia.co.uk