OBIEE 11g & CentOS 5.5

So a few weeks ago I got this great idea (as I already mentioned in my 1st blog entry) to make a Linux Box with OBIEE 11g.

This blog will try to summarize all the problems I encounter and the workaround I had to do. Since is only a summarize I will just link you to pages useful to help you get it right.
Just for the record I haven’t worked with Linux before so probably some of my mistakes were consequences of this.

As I stated before the idea was to have everything one one Linux VBox. I ended up with two virtual boxes and Admin tool on my laptop (you can always consider a 3rd win box).

I choose to use Oracle’s acquisitioned tool VirtualBox (from Sun package). At home I have a bit of a mediocre net line. So just the install of CentOS 5.5 (cause is Red Hat as is Oracle Enterprise Linux, more or less) was an adventure. All the components I used are 64-bit, so OS, Oracle DB 11R2 and OBIEE 11g.

Now two things you should know about VBox:
I. Installing guest additions is a must if you want to mount shared folder from the host
II. Make the machine big enough (OBIEE alone demands something like 12G) it’s a pain to resize it and I was able to make it work just once

More details:
I. VBox Guest Additions for Linux are provided on a ISO CD-ROM.


Installation generally involves the following steps:
A) It is recommended using DKMS for Linux guests as well. On CentOS:

yum install dkms
Make sure to install DKMS before installing the Linux Guest Additions.

B) Install the addition (don’t forget the sh, if you open the file you will see why)

sh ./

Now you should be able to do things like :

II. So if you by mistake make a to small image you can try CloneVDI, which has the option of resizing it. To do anything with that space you than need QTParted and system-config-lvm 1.1.5 to deal with it. I would really recommend you don’t mess with this if you really don’t have to. More info on the cloning topic can be find here.

At this point I had 2 VBoxes. Clones in fact. To install Oracle I found this some useful blogs:
Blog #1
Blog #2

The only real problem I found is that they changed some of those kernel parameters in the newest version so be carefull which documentation you follow.

Useful commands:

emctl start(stop) dbconsole lsnrctl start(stop) dbstart(dbshut) dbca

I had an adventure with my DB cause I swapped from Nat to Bridged and set static IP-s to DB after first run. So I had to redo the configuration of my DB more info here. And don’t forget to open 1521 port to the rest of the world (or better the obiee box) when you are ready to share your OracleDB.

Now OBIEE 11g is something else – not sure if it’s really easy, if you ask me it has it’s tricks. I searched for info on installing it till almost at the end of my mission I found this site.
There is even an explanation on how to start the system once you restart the box. The only thing I would like to add is if you happen to encounter something like this in the log:

<BEA-001128> <Connection for pool "bip_datasource" closed.>
<BEA-001128> <Connection for pool "mds-owsm" closed.>
<BEA-001128> <Connection for pool "mds-owsm" closed.>
<BEA-001128> <Connection for pool "rtd_datasource" closed.>
<BEA-001128> <Connection for pool "rtd_datasource" closed.>
<Created "1" resources for pool "rtd_datasource", out of which "1" are available and "0" are unavailable.>
<Created "1" resources for pool "mds-owsm", out of which "1" are available and "0" are unavailable.>

Then you should try the following command: ./opmnctl startall

If it gives you an error about ORACLE_INSTANCES this might help.
So next problem is that the AdminTools exist only for Win. I need to stay I didn’t realize this till the end. So you can resolve this by following this.

Anyway after all this effort I know you want to at least see how this “monster” looks like so there you go:

Will add my 7min long video as soon as I get it uploaded on MegiaVideo

I hope my experience helps someone, somehow.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.