Install OBIEE 11g on Windows XP

Problem

How to install OBIEE 11g on Windows XP.

Solution

i. Description

Find the step by step procedure in Procedure Section.

The prerequisite are :-

i) JDK 1.7 or higher

ii) Oracle Database 11g

iii) Loopback Adapter

iv) RCU

ii. Procedure

Before installing OBIEE 11 g Fusion Middleware product, request you to ensure the prerequisite items to be installed/Configured.

1. Download & install JDK 1.7 or higher.

Download Link :- http://www.oracle.com/technetwork/java/javase/downloads/index.html

Watch video to download & install JDK 1.7 or higher

2. Download & Install Oracle 11g DB R2 on your PC as per system architecture.

Download Link :- http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Watch video to download & install Oracle 11g DB R2

3. For DHCP computer having no permanent IP Address you need to configure Microsoft default Loopback address.

Install a Loopback Adapter on Windows XP.

Install Loopback Adapter.....Click Here

Watch video to download & install Loopback Adapter

4. Download Repository Creation Utility(RCU) from OTN using below link. It would be found under Additional Software section. Windows 32 Bit version for RCU is 11.1.1.3.3.

Download Link :- http://www.oracle.com/technetwork/middleware/downloads/fmw-11-download-092893.html

Setup RCU.....Click Here

Watch video to download RCU & create Metadata Repository using Oracle RCU

5. Download OBIEE 11g (11.1.1.3.0) from OTN.

Download Link :- http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence11g-240521.html

6. Now extract the download copy into two different folders.

7. Merge the two folders content into single directory “..\bi_windows_x86_111130_32_disk1_1of2\bishiphome”.

8. Execute the OBIEE Setup (setup.exe).

Oracle Universal Installer (OUI) pre-requisite verification started.

Then the OFMW 11g Installer template initiated.

9. Click Next on Welcome screen appeared below.

10. Select the “Installation Type” as ‘Simple’ .This is most easiest and recommended for first try .All the parameters will be set by default.

N.B:- Enterprise installation is mostly required in Scalable system having the configuration required across multiple Weblogic domain or joining a existing domain to existing Weblogic Server .The “Software Only Install” requires the configuration done in different phase after the enterprise wide installation is over .

11. Pr-requisites check has been done.

12. Specify the installation location.

13. Enter the ‘Weblogic’ Admin credentials . In my case the password is : ‘weblogic#1′ (without quotes to meet Oracle Password standard) .

14. Configuring the components. In my case I select all.

15. Specify the connection parameters.

N.B:- Be aware of the joker type error message thrown here during my first installation as “INST-08029 Unable to connect to Database with given credentials.” It seems to be an Oracle BUG .See the issue in screenshot.

The reason of this error is the BIPLATFORM schema password .In RCU utility if you provide the password same as Schema name it would be creating trouble. Not sure whether it doesn’t accept the same password or it doesn’t accept the underscore(‘_’) character .I have not investigate further on it.

Anyway I get rid of it after dropping the RCU schema for BI and recreate the same with password as ‘rcu’ .This password has been provided here .

16. Specify security update section.

17. Finalize the installation.

The installation started …..

After installation done the configuration Process starts …

18. The installation and configuration completed. Click Finish.

So finally OBIEE11g has been installed successfully with the below access details for different application :

Type: Simple Install

Installation Details

Middleware Home: E:\OraFMW11g

BI Oracle Home: E:\OraFMW11g\Oracle_BI1

WebLogic Server Home: E:\OraFMW11g\wlserver_10.3

BI Domain Home: E:\OraFMW11g\user_projects\domains\bifoundation_domain

BI Domain Name: bifoundation_domain

Instance Home: E:\OraFMW11g\instances\instance1

Instance Name: instance1

Configure Components

WebLogic Console

http://localhost:7001/console

Oracle Enterprise Manager

http://localhost:7001/em

Business Intelligence Enterprise Edition

http://localhost:9704/analytics

Business Intelligence Publisher

http://localhost:9704/xmlpserver

Real-Time Decisions

http://localhost:9704/ui

19. After the installation concludes , Weblogic Server and BI Server started , IE browser window opens automatically with the homepage of Oracle Business Intelligence instance .Logging in using the weblogic server User name and password given at Step 12.

You will be successfully login to OBIEE 11g

Watch video to download & install OBIEE 11g

iii.Code

iv. Additional Info

Attachment