Oracle Business Intelligence Enterprise Edition(OBIEE) 11g Installation


Below screenshots will guide you through step by step installation of OBIEE 11 g Fusion Middleware product .Before start the setup make sure Oracle 11g database installed and RCU setup completed.

Step 1: Download OBIEE 11g (11.1.1.3.0) version from below link of OTN .

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

Prerequisite has been installed as  : Oracle 11g DB R2 and RCU 11.1.13.3 .

Now extract the download copy into two different folders ….

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

Step 2: For DHCP computer having no permanent IP Address you need to configure Microsoft default Loopback address .Follow the steps provided under section “Installing a Loopback Adapter on Windows 2003 or Windows XP”  from Nicolas Loopback Adapter Configuration .The glimpse of it as below:

Step 3: Execute the setup.exe .

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

Then the OFMW 11g Installer template initiated.

Step 4: Click Next on Welcome screen appeared below.

Step 5: 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 .

Step 6: Pre-requisites check has been done .

Step 7: Specify the installation location .

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

Step 9: Configuring the components . In my case I select all .

Step 10: 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 .

Step 11: Specify security update section .

Step 12: Finalise the installation .

The installation started …..

After installation done the configuration Process starts …

Step 13: 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://deba:7001/console
Oracle Enterprise Manager
http://deba:7001/em
Business Intelligence Enterprise Edition
http://deba:9704/analytics
Business Intelligence Publisher
http://deba:9704/xmlpserver
Real-Time Decisions
http://deba:9704/ui

Step 14: 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 8 .

Voici … OBIEE11g installation has been completed successfully .

Oracle Database 11g R2 Installation


Hello All ….Welcome Back after long time !! The tale of new journey begins… 🙂

So … prior to setup and configure new OBIEE 11g version (The Fusion Middleware  , RCU setup etc) the prerequisite must be completed . And here comes Oracle 11g R2 installation .

The configuration for my system as below :

RAM: DDR2 4 GB 667 MHz bus speed.

CPU: Intel Core 2 Duo 2.33GHz.

Hardware Cache : 4 MB L2 Cache

OS : Windows XP Professional Version 2002 – Service Pack 3

Firewall : Zonealarm

Step 1: I have downloaded Oracle 11g R2 Server version from OTN :

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

The content downloaded for 32 bit windows for setup in Windows XP like as below :

The downloaded content looks like below:

Step 2: Execute the “setup.exe” file .

It starts to check and validate the pre-requisite …

Step 3: Configuring security Updates

Step 4: Since I want a starter database to be installed and configured hence choose option 1

otherwise see the tooltip option which is suitable for your need if you want to upgrade from existing DB or want to install DB binaries only …

Step 5: Choose the system class . In my case it will be desktop class system .

Step 6: Configure basic parameters ….

Click “Next” and it will perform some basic checks about validating Memory , Space left at the target location , Swap Memory size , Global variable and PATH , Environment variables etc ….

Step 7: Save the response file if you would like to resume the same configuration and setup later using command line parameters …Just kickoff the installation by ‘Finish’ .

Step 8: The progress bar started continuing the installation and copying the required files.

The database creation initiates :

Note: If you have firewall configuration to protect any application accessing Internet , you can see several applications (sqlplus.exe , perl.exe , tnsping.exe ,java.exe , javaw.exe,emdctl.exe,emagent.exe,nmzctl.exe and others) would be trying to access Internet and the default loop back IP address 127.0.0.1 .Just allow all of them in the firewall configuration.

Step 9: Oracle 11g R2 database installation completed .

Step 10: I prefer unlocking password for ‘HR’ , ‘BI’ ,’SCOTT’ schema and define passwords for SYS,SYTEM as ‘Sys12345’ and ‘SCOTT’ as tiger. Click OK after that .

Step 11: The installation has been done and the Enterprise manager DB console can be accessible through URL : https://localhost:1158/em .In my configuration it would take ~ 45 Minutes .

 

Step 12: Just validate the OEM access using the above URL :

Step 13: OEM Homepage for the instance DB instance ‘Oradeba’ as below :

N.B :- Use ‘SYSTEM’ account for Connect As Normal rather as ‘SYSDBA’ .

Finally I have done with Oracle 11gR2 Installation.