Search This Blog

Wednesday 24 October 2012

Rcu installation


) RCU Installation


Installation of OBIEE 11.1.1.5 version on Windows XP with 3GB Ram. I have used VMware work station to install the tool. The complete installation has two parts 1) RCU Installation and 2) OBIEE11g Installation.
Pre-requisites
Install the Oracle11.1.1.7 database with Microsoft Loopback adapter.
Download the required installation files from Oracle and unzip the files into the same directory.
http://santoshbidw.files.wordpress.com/2011/10/image15.jpg
First begin installing RCU bat file.
Go to the RCU (Repository creation Utility) rcuHome\BIN directory and double click on rcu.bat file.
http://santoshbidw.files.wordpress.com/2011/10/image21.jpg
Click on next
http://santoshbidw.files.wordpress.com/2011/10/image31.jpg
Click on create and click next
http://santoshbidw.files.wordpress.com/2011/10/image41.jpg
Provide the sys credentials with system host name, port and service name and click next.
http://santoshbidw.files.wordpress.com/2011/10/image51.jpg
System will check the prerequisites, ignore this warning.
http://santoshbidw.files.wordpress.com/2011/10/image61.jpg
Click ok
http://santoshbidw.files.wordpress.com/2011/10/image71.jpg
Select the components to create repository and click next.
http://santoshbidw.files.wordpress.com/2011/10/image81.jpg
Click ok
http://santoshbidw.files.wordpress.com/2011/10/image91.jpg
Provide the password for the schemas created in the previous step. (Password: admin)
http://santoshbidw.files.wordpress.com/2011/10/image101.jpg
Click next
http://santoshbidw.files.wordpress.com/2011/10/image111.jpg
Click ok
http://santoshbidw.files.wordpress.com/2011/10/image121.jpg
Click ok
http://santoshbidw.files.wordpress.com/2011/10/image131.jpg
Click on create
http://santoshbidw.files.wordpress.com/2011/10/image141.jpg
We have installed the RCU successfully.

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 andRCU setup completed.
Step 1: Download OBIEE 11g (11.1.1.3.0) version from below link of OTN .
Prerequisite has been installed as  : Oracle 11g DB R2 and RCU 11.1.13.3 .
http://debaatobiee.files.wordpress.com/2011/02/1-0-otn-download1.png?w=510 
Now extract the download copy into two different folders ….
http://debaatobiee.files.wordpress.com/2011/02/2-0-downloaded-obiee-11g.png?w=510&h=198
Merge the two folders content into single directory “..\bi_windows_x86_111130_32_disk1_1of2\bishiphome” .
http://debaatobiee.files.wordpress.com/2011/02/2-1-merge-downloaded-obiee-11g.png?w=300&h=94 
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:
http://debaatobiee.files.wordpress.com/2011/02/3-0-loopback-address-confg.png?w=510&h=399
Step 3: Execute the setup.exe .
http://debaatobiee.files.wordpress.com/2011/02/4-0-obiee-11g-step-1.png?w=510&h=215
Oracle Universal Installer (OUI) pre-requisite verification started .
http://debaatobiee.files.wordpress.com/2011/02/5-0-obiee-11g-step-2.png?w=300&h=238 
Then the OFMW 11g Installer template initiated.
http://debaatobiee.files.wordpress.com/2011/02/6-0-obiee-11g-step-3.png?w=510 
Step 4: Click Next on Welcome screen appeared below.
http://debaatobiee.files.wordpress.com/2011/02/7-0-obiee-11g-step-4.png?w=300&h=241 
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 .
http://debaatobiee.files.wordpress.com/2011/02/8-0-obiee-11g-step-5.png?w=300&h=241 
Step 6: Pre-requisites check has been done .
http://debaatobiee.files.wordpress.com/2011/02/9-0-obiee-11g-step-6.png?w=300&h=241 
Step 7: Specify the installation location .
http://debaatobiee.files.wordpress.com/2011/02/10-0-obiee-11g-step-7.png?w=300&h=241 
Step 8: Enter the ‘Weblogic’ Admin credentials . In my case the password is : ‘weblogic#1′ (without quotes to meet Oracle Password standard) .
http://debaatobiee.files.wordpress.com/2011/02/11-0-obiee-11g-step-8.png?w=300&h=241 
Step 9: Configuring the components . In my case I select all .
http://debaatobiee.files.wordpress.com/2011/02/12-0-obiee-11g-step-9.png?w=300&h=241 
Step 10: Specify the connection parameters ..
http://debaatobiee.files.wordpress.com/2011/02/13-0-obiee-11g-step-10.png?w=300&h=241 
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 .

http://debaatobiee.files.wordpress.com/2011/02/13-1-obiee-11g-step-10.png?w=510&h=215 
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 .
http://debaatobiee.files.wordpress.com/2011/02/14-0-obiee-11g-step-11.png?w=300&h=241 
Step 12: Finalise the installation .
http://debaatobiee.files.wordpress.com/2011/02/15-0-obiee-11g-step-12.png?w=300&h=241 The installation started …..
http://debaatobiee.files.wordpress.com/2011/02/16-0-obiee-11g-step-13.png?w=300&h=241 After installation done the configuration Process starts …
http://debaatobiee.files.wordpress.com/2011/02/17-0-obiee-11g-step-14.png?w=300&h=241 
Step 13: The installation and configuration completed .Click Finish .
http://debaatobiee.files.wordpress.com/2011/02/18-0-obiee-11g-step-15.png?w=300&h=241 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\w
lserver_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.
http://debaatobiee.files.wordpress.com/2011/02/19-0-obiee-11g-login.png?w=300&h=207 
Voici … OBIEE11g installation has been completed successfully .
http://debaatobiee.files.wordpress.com/2011/02/20-0-obiee-11g-login-done.png?w=400&h=200

Saturday 6 October 2012

Create VDI image using Virtual Box


Create VDI image using Virtual Box
Problem
How to create VDI image using Virtual Box.

Solution
i.  Description
Here you will know the procedure to create virtual image of OBIEE 11g using Virtual Box software.
The main advantage of creating image file are as follows
1. Provides portability.
2. No need to install Oracle DB, OBIEE 11g & Other supporting Files on all machine where you are going to use it.
3. You need to carry only one file(.vdi)

ii. Procedure
1.
1.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343670768336/create-vdi-image-using-virtual-box/1.jpg?height=223&width=400
2.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343671476373/create-vdi-image-using-virtual-box/2.jpg?height=224&width=400
3.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343671670579/create-vdi-image-using-virtual-box/3.jpg?height=224&width=400
4.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343671696234/create-vdi-image-using-virtual-box/4.jpg?height=224&width=400
5.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343671839032/create-vdi-image-using-virtual-box/5.jpg?height=224&width=400
6.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343671885138/create-vdi-image-using-virtual-box/6.jpg?height=224&width=400
7.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343672080284/create-vdi-image-using-virtual-box/7.jpg?height=224&width=400
8.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343672093224/create-vdi-image-using-virtual-box/8.jpg?height=224&width=400
9.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343672108587/create-vdi-image-using-virtual-box/9.jpg?height=224&width=400
10.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343672124999/create-vdi-image-using-virtual-box/10.jpg?height=224&width=400

2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755103934/create-vdi-image-using-virtual-box/11.jpg?height=224&width=400
12.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755120342/create-vdi-image-using-virtual-box/12.jpg?height=224&width=400
13.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755133878/create-vdi-image-using-virtual-box/13.jpg?height=224&width=400
14.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755147149/create-vdi-image-using-virtual-box/14.jpg?height=224&width=400
15.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755159788/create-vdi-image-using-virtual-box/15.jpg?height=224&width=400
16.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755171933/create-vdi-image-using-virtual-box/16.jpg?height=224&width=400
17.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755179184/create-vdi-image-using-virtual-box/17.jpg?height=224&width=400
18.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755185547/create-vdi-image-using-virtual-box/18.jpg?height=224&width=400
19.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755193270/create-vdi-image-using-virtual-box/19.jpg?height=224&width=400
20.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755200268/create-vdi-image-using-virtual-box/20.jpg?height=224&width=400
21.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755207972/create-vdi-image-using-virtual-box/21.jpg?height=224&width=400
22.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755214679/create-vdi-image-using-virtual-box/22.jpg?height=224&width=400
23.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755221826/create-vdi-image-using-virtual-box/23.jpg?height=224&width=400
24.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755227995/create-vdi-image-using-virtual-box/24.jpg?height=224&width=400
25.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755236603/create-vdi-image-using-virtual-box/25.jpg?height=224&width=400
26.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755243837/create-vdi-image-using-virtual-box/26.jpg?height=224&width=400
27.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755251830/create-vdi-image-using-virtual-box/27.jpg?height=224&width=400
28.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755259768/create-vdi-image-using-virtual-box/28.jpg?height=224&width=400
29.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755268775/create-vdi-image-using-virtual-box/29.jpg?height=224&width=400
30.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755278257/create-vdi-image-using-virtual-box/30.jpg?height=224&width=400
31.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755288998/create-vdi-image-using-virtual-box/31.jpg?height=224&width=400
32.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755300463/create-vdi-image-using-virtual-box/32.jpg?height=224&width=400
33.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755311236/create-vdi-image-using-virtual-box/33.jpg?height=224&width=400
34.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755325679/create-vdi-image-using-virtual-box/34.jpg?height=224&width=400
35.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755337366/create-vdi-image-using-virtual-box/35.jpg?height=224&width=400
36.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755345538/create-vdi-image-using-virtual-box/36.jpg?height=224&width=400
37.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755353279/create-vdi-image-using-virtual-box/37.jpg?height=224&width=400
38.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755360531/create-vdi-image-using-virtual-box/38.jpg?height=224&width=400
39.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755368521/create-vdi-image-using-virtual-box/39.jpg?height=224&width=400
40.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755376586/create-vdi-image-using-virtual-box/40.jpg?height=224&width=400
41.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755384091/create-vdi-image-using-virtual-box/41.jpg?height=224&width=400
42.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755390859/create-vdi-image-using-virtual-box/42.jpg?height=224&width=400
43.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755400174/create-vdi-image-using-virtual-box/43.jpg?height=224&width=400
44.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755405097/create-vdi-image-using-virtual-box/44.jpg?height=224&width=400
45.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755410628/create-vdi-image-using-virtual-box/45.jpg?height=224&width=400
46.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755419363/create-vdi-image-using-virtual-box/46.jpg?height=224&width=400
47.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755428957/create-vdi-image-using-virtual-box/47.jpg?height=224&width=400
48.
https://sites.google.com/site/oraclebusinessintelligence11g/_/rsrc/1343755438795/create-vdi-image-using-virtual-box/48.jpg?height=224&width=400