Implementing OBIEE on Linux (Fedora) [Part I]
By Gus Segura – Senior BI Architect / Analyst. www.FODAREC.com
I wanted to try this and keep it as cost-effective as possible. I didn’t want to go burn through another couple thousand euro (dollars) to put together a new server just to test this out. So, I grabbed a couple of older single core desktops. They had been moved into the trash pile. Literally. I opted to get new enclosures with new power supplies (60) and because they’re older I was able to get 2Gig of Ram each for about (50). Total (2X60 + 2X50)= 220.
The new enclosures are nice. I was able to transfer the guts of both comps with no problems. That took about 1ManDay Total for both Desktops. [See Picture.]
The point here is that both those computers were basically trash. No good for Windows XP let alone Vista or Windows 7. They had run they’re race and I had them because of a forensic data recovery on the hard-drives to get some inventory data. The client was happy with they’re recovered data on a nice new external and told me that I could dispose of what was left as I saw fit. We did an ISO wipe of the boot-data drives [Extremely Important] but kept the hardware around just in case we needed the parts.
[Remind me, I will write a separate article soon about how important it is to wipe your old drives when they're done. Everything leaves a foot-print. Data Recovery is what we do first but we also know how to help you dispose of that data.. The right way.]
Next Step, We downloaded the install image for Fedora [Latest Version].
A few things on Fedora. It’s stable for me. I patch it often and I try to make sure to read the warning notifications before I do. If these would have been small blade servers; I would have RAID 0/1 the os drives and the oracle install directory. I also would have used a small disk farm and probably OPS – Oracle Parallel Server for load balance and fail-over. Again, I wanted cost effective. I got it with these two re-cycled computers but you really can go all out if you want. A second NIC card in each box. A USB Shared Disk with a few TB of disk space and you may find that you’re really close to having an Oracle 11G mini-Grid.
I wanted to share the load and have some horse power left over for other things in each box. After I installed Fedora and made sure I had the pre-requisites for both Oracle 11G and OBIEE [Libraries, Environment Variables,..etc.], I went ahead and downloaded Oracle11G to one box and OBIEE to the other. You can find the software downloads from Oracle. Make sure to download the ones for [Oracle Linux]. You will need to unpack them to a temp directory somewhere and remember that when you install Oracle.. it will be to it’s home directory as specified in the setup. Install software and patches are normally stored elsewhere.
I’m not going to go over the actual setup because I will dive deep in Part II about actually using OBIEE and Oracle11G database to do something useful. The documentation in the setup is fairly straight forward. Make sure you set you environment properly. The Installer will prompt you if there are problems. Again, The jest of this is using old computers that were trash; We were able to get a good install of Oracle11G database and OBIEE up and running.
[Actual Oracle11G Node.]
login as: oracle
Last login: Wed Mar 24 10:59:38 2010 from fodarec_lap
[oracle@crackerone ~]$ sqlplus “/ as sysdba”
SQL*Plus: Release 184.108.40.206.0 Production on Wed Mar 24 12:36:32 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[Actual OBIEE Node.]
login as: oracle
Last login: Wed Mar 24 13:20:10 2010 from fodarec_lap
[oracle@crackertwo ~]$ cd $OBIEE_BASE
[oracle@crackertwo OracleBI]$ ls
corda50 install jdbc odbc server uninstall xmlp
index_bi_ee_files Install_Backup log office setup version.txt
index_bi_ee.html inventory oc4j_bi oui systemsmanagement web
[oracle@crackertwo OracleBI]$ cd setup
[oracle@crackertwo setup]$ ls
attachments obiee_start.sh run-sa.sh sawserver.sh uninstallperfsaw.sh
common.sh obiee_stop.sh run-saw.sh saw.sh UnixChk.sh
installperfsas.sh oc4j run-sch.sh sysenvinit.sh user.sh
installperfsaw.sh odbc.ini sa-cli.sh systunesrv.sh
kill.sh run-ccs.sh sa-init.sh uninstallperfsas.sh
[oracle@crackertwo setup]$ cat obiee_start.sh
source run-sa.sh start
source run-saw.sh start
source run-sch.sh start
Those last three are the main start scripts for OBIEE. You’ll need to run them in order. Once you have them started you should be able to log into the Administration screen. I’m going to pause here.. In part two I want to go over the process of logging into Admin and actually doing to the dashboards to get a report running – Really, the point of using OBIEE is getting those reports up.
Note: There is a process. I’m a reasonable person when it comes to process. Seems reasonable to use the different desktop tools to get the repository built for reporting. I get into that process more in Part II. It’s important to know know what your getting into with OBIEE as far as process. It’s not like Oracle Discover. I think the cross-platform compatibility and the fact that it’s database agnostic makes it very powerful. Also, Originally the Oracle11G ODBC driver were problematic for me on Windows 7. There was just an update. I was able to get everything running well with the newest version on the ODAC110720.