Installing Oracle BI Applications (Siebel Analytics)

We’ve seen Siebel Analytics in use at a number of client sites, but I’ve rarely had an opportunity to get to grips with it. I performed some base installations a long while back, from a set of instructions, but that’s pretty much it. I’ve recently had a lot of interest in what’s happing in this space and have decided to revisit what is now Oracle Business Intelligence Applications. In this post, I’ll share with you my experience of downloading, installing and configuring this set of tools.

Downloading is very straight forward. Visit Oracle eDelivery, select the ‘Oracle Business Intelligence’ Product Pack and your requirement platform. Select Oracle Business Intelligence Applications 7.9.5.2 for Oracle Data Integrator Media Pack for Microsoft Windows (32-bit) then download and unpack the following ZIP files:

• Oracle Business Intelligence Suite Enterprise Edition 10.1.3.4.0
• Oracle Business Intelligence Applications 7.9.5.1
• Informatica PowerCenter and PowerConnect Adapters 8.6.1

Installation has a number of steps:

1. Set yourself up a Windows 2003 / 2008 virtual server. I’m still using Windows Virtual PC.
2. Install Oracle 11g database using the Enterprise option
3. Create a new database (I always create SIEBDATA and SIEBINDX tablespaces) and create INF, OLTP and DAC users
4. Install the OBI Suite
5. Install the OBI Applications
6. Install Informatica PowerCenter Server, Client, Siebel Server / Repository, Siebel Client and hot fixes

This should all be pretty straight forward. The fun comes in actually configuring the applications and getting it all up and running together. The subject of a future post, I’m afraid!