Saturday, December 10, 2011

Installation of OBIEE 11G R1 (

1). Prerequisites 

OBIEE 11gR1 ( Supported Platforms and Operating Systems

Operating System Support

•  Oracle / Red Hat Enterprise Linux 4 (Update 7+), 5 (Update 3+)
•  SUSE Linux Enterprise Server 10 (SP1+), 11
•  Windows XP Professional with SP3
•  Windows 2003 with SP2/R2+
•  Windows Server 2008 with SP1+
•  Windows Server 2008 R2
Database support for Repository   Creation                
•  Oracle ,,
•  IBM DB2 9.1+, 9.5+, 9.7+
•  MS SQL Server 2005, 2008
•  Teradata 12, 13

Hardware Specification 

•  Disk Space: 20GB or more
•  Available Memory: 4GB or more
•  Temp Space: 950MB or more
•  Swap Space: 3GB or more
•  CPU: dual-core Pentium, 1.5GHz or greater

For more details about prerequisites download certification matrix from below link.
2). Download installation setup files.                                                                                  
Download Link OBIIEE 11g and additional Software Repository Creation Utility from below link.

3). Extract the OBIEE 11g setup files and Repository component in separate folders. 

Put the extracted repository creation utility folder into the same drive where the operating system is installed. Extracted files will store in a new folder named rcu_home.

3.2) Extract all the setup files of OBIEE 11g in a single folder.

4). Check out the prerequisites once again for your system.
This installation is done on below platform
1.  Operating System   : - Windows Server 2003 SP2 (32-bit) with
2.  Database Server     : - Oracle 11g R2 (For repository creation)
3.  RAM                      : - 4GB
4. Processor                : - Core i3 2.93 GHz
5. Disk space              : - 50 GB
6. Software’s               :- Microsoft .Net Frame Work 2.0, Mozilla 4.0 and Internet Explorer 7.0

5). Extract the Repository Creation Utility and navigate to rcu.bat file this path:

6). Create Repository using Repository Creation Utility software.

6.1) Run the  rcu.bat  from \ofm_rcu_win_11.\rcuHome\BIN to open the main RCU installer. (Repository Creation Utility 

Pass the welcome screen and then chose “Create” to create and load component schemas into the database.

6.2).  Select Database Type to Oracle. Enter Database Connection Details like server/host name, port number, service name Also enter database name, username and password that you created earlier. (You can use the default system user name and password also).

Click on next to start the pre-requisite checks.

6.3). Enter DEV into create a prefix box and select components as shown in the screen shot.

Click the Business Intelligence check box.  This automatically selects the Metadata Services (MDS) and Business Intelligence Platform schemas and others, which are required by Oracle Business Intelligence. 

It will check prerequisites for schema and its owner. 

Click  OK to close the Checking Prerequisite screen. Fix errors if  they appear before continuing.

6.4). Create a password for all the schemas.   

Specify the password same for below 2 different schemas .Be aware of the current setup related issue with RCU schema password (Seems to be an Oracle Bug). Two different schemas’s having different password or the password having underscore (‘_’) character causing issue while set up OBIEE 11g Fusion Middleware .Hence for the current situation keep password simple and same for both schema’s as ‘rcu’ .This password will be reused later during OFMW11g setup.

Click “Next” and take a look at the summary.     

6.5) Next screen comes for Map Tablespaces with a message -> Click ok on Message. 

6.6). Next screen creates table spaces.          .

6.7) Check summary for user schemas and tables with components. 

6.8).All that’s left is to take a look at the summary completion for status with success messages and click “Close”.       

RCU has been created successfully and hence close the window.

6.9) Check and verify into data base for rcu user schemas.

6.10). The SQL scripts and the installation log can be found in below reference location of the executed batch  file.  

7). Installing and configuring Loopback Adapter for DHCP computers.

If you are using dynamic IP Address and don’t have permanent  IP Address then you need to configure
Microsoft default Loopback address after installing Microsoft Loopback Adapter and if you have 
7.1). Click on Start button and got to Control Panel -> Add Hardware.
7.2). Click Next in welcome screen -> Select – Yes, I have already connect the hardware.
7.3). Click Add a new Hardware device from Add Hardware Wizard -> Click Next.

7.4). Select install the hardware that I manually select form a list (Advanced) and then -> click on Next.

7.5) Select Network adapters -> Click on Next.

7.6) Select Microsoft from Manufacturer pane and Select Microsoft Loopback Adapter from Network Adapter tab. .

7.7). Click Next in the next screen to start installation of Microsoft Loopback Adapter.

7.8). Click Finish button to complete installation in the next screen.

7.9). Go to
My network places Right click and open Properties.

7.10). Open properties of newly created Loopback adapter (Local Area Connection 2). 

7.11). Select Internet Protocol (TCP/IP) -> Click on Properties.

7.12). Select Use the following IP address radio button and enter IP address and Subnet Mask details.

Click ok to save these settings to create a static IP and check the connection status.

Now you can start to install OBIEE 11g.

8). Install OBIEE 11g. Extract Setup Files.

8.1) Execute the setup from the disk1    

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

8.3) Click Next on Welcome screen.        

8.4) Skip the installation software updates screen.         

8.5). Select the “Installation Type” as ‘Simple’ and click on next button. This is easiest and recommended for first try .All the parameters will be set by default.   

A. Simple Install:- which is what most developers testing out the software will require, installs a basic OBIEE 11gR1 system along with WebLogic Server, using default values for things like domain names, port numbers and the like.

B. Enterprise Install:-  gives you a few more options than a Simple Install, letting you customize the name of the WebLogic domain, the WebLogic Managed Server, the ports that are used and so on. If you need to vary away from the defaults, or “scale out” an existing installation, choose this option (but for most developers, Simple Install will be fine)

C. Software Only Install :- will install the OBIEE 11gR1 software (but not WebLogic Server, you need to have this already installed), but doesn’t set up any “instances” of OBIEE, a similar situation to when you install the Oracle Database binaries but don’t configure a database instance.

Selecting the  Simple Install option will move you on to the next page for the installer, which then prompts you to select a “middleware home” directory for installation. 

8.6) Installer Prerequisites checks automatically.

8.7). Create a Middleware home directory. 

All of the OBIEE 11g installation will go into this directory (there are no longer OracleBI, or OracleBIData directories they will store separately from Middleware home directory), including the binaries and the “OBIEE instance” files, creating a separation in 11gR1 between those files that are static – the binaries and configuration file templates – and those that change over time, which include the configuration files, repositories, XML files and web catalog.

8.8) Enter credential for weblogic Server.

Enter a username and password for the WebLogic Server. In 11gR1 there is no longer the concept of an Administrator user, and instead you create an administrator user here that becomes the default admin login into OBIEE (and the various WebLogic Server administration tools). 

8.9). Configuring the components. Select all components if they will not appear selected by default.  

8.10). Enter Database and connection Details.

Enter connection details to the database in which you set up the DEV_BIPLATFORM schema. Look back to the connection details which are used for the RCU and enter these details as shown in screen shot. 

8.11) Enter connection details to the database in which you set up the DEV_MDS schema. Look back to the connection details which are used for the RCU and enter these details as shown in screen shot.

8.12) Specify the security updates or you can skip as you wish -> Click next and press yes on message.

8.13).  Finalize the installation. Click on installation button to start the installation. The installation process then begins, and starts by installing the supporting WebLogic Server files required for the infrastructure layer.

8.14).  It will ask you for disk change then use browse button to change the disk and again installation will start.

It proceeds to install what in 11gR1 are called the “System Components”, which in this release are still C++ applications but are managed now by WebLogic. 

Installation will ask for other disks between processing in sequence like disk4-> disk 5 -> disk 2 -> disk3 -> disk4 -> disk5.

8.15). Once installation has finished, it creates install log files automatically, start execution of post install scripts and apply one off patches.

(Installation will finish at 98%).

 8.16) Few seconds after installation configuration will start automatically

On the same screen, installation success message will appear.The configuration process starts with the next screen. Initially, this is concerned with instantiating the WebLogic domain and managed server, together with supporting technologies such as Enterprise Manager and Oracle Web Services Manager.

8.17) Within configuration process the BI Server, BI Presentation Server and other system components are registered within the WebLogic Server managed server, and OPMN is configured so that it can stop, start and monitor them (more on this in future blog posts).  

If any component gets fails to configure during configuration then click on retry to start configure again. 

8.18) Verify the configuration 100% and green check sign over BI configuration.

8.19). Next screen will show Complete message.  Once check out the configuration, click on save button to generate summary details file then click on Finish to finish the installation and configuration of OBIEE 11g.

 8.20) After finish Analytics will start automatically in default browser -> Login with weblogic credential and check for reports. 

Select any default report to make sure installation is done successfully. 

9). Post install check. Restart the machine.

9.1).Start the BI Administration Tool to open the sample repositories -> Select a repository in offline  mode

Enter default password Admin123 as password to open the repository.

Have a look of repository (rpd) into BI Administration Tool.

9.2). Go to Start Menu and select All Programs -> Oracle Business Intelligence -> Start BI Services. 

Once you run the Windows Start Menu entry, a DOS box opens up which can ask you to type in the WebLogic Server admin username and password, which you set earlier on in the install process, or start without asking for username and password.

9.3). Once this is entered, a WebLogic Server script then starts the admin server, then the managed server, the OPMN service any other components, and about five minutes later you should be able to log into OBIEE 11g, again using the WebLogic Server admin username and password, Oracle Business Intelligence instance. 


9.4) check out with below links to validate the other components with installation using weblogic credential.     
A). For Web Logic Console

B). For Business Intelligence Publisher
C). Oracle Enterprise Manager

D). Real-Time Decisions (Microsoft Internet Explorer version 7 and 8 are the only currently supported browsers for Real Time Decisions)

Type your server name (System/ Computer name) or local host in place of BI.  


  1. Thank you very much for your good information.
    As I noted in the ... given information is very usefull to every student who ever want to learn about
    Excellent DataStage Online Training

  2. Thank you very much for your good information.
    As I noted in the ... given information is very usefull to every student who ever want to learn about
    best obiee Online Training

  3. really good piece of information, I had come to know about your site from my friend shubodh, kolkatta,i have read atleast nine posts of yours by now, and let me tell you, your site gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a lot once again, Regards,obiee online training

  4. Appreciation for nice Updates, I found something new and folks can get useful info about BEST obiee ONLINE TRAINING

  5. wonderful information, I had come to know about your blog from my friend nandu , hyderabad,i have read atleast 7 posts of yours by now, and let me tell you, your website gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a ton once again, Regards,
    obiee training in hyderebad

  6. Thank you provide valuable informations and iam seacrching same informations,and saved my time OBIEE Online Training

  7. Nice information. Our institute Is the Leading online institute in

    Hyderabad, India to provide OBIEE online trainings with the real

    time experts and certified professionals. alot

    Obiee Online Training.

  8. Thanks for InformationFlax IT online training began online training for Software program and SAP courses. Online training is the better option to study software products as well as programs, which are SAP modules, like SAP HR, SAP FSCM, SAP BASIS, SAP ABAP, SAP BW, SAP ED ADMIN, SAP SECURITY, SAP SRM, SAP SCM, SAP GRC etc., and Software Courses like JAVA-J2EE, PeopleSoft, Tibco courses, Microsoft Courses, Network and System Admin, Oracle Courses, SAS, Testingtools, PMP, Cognos, AB Initio, ORACLE and Database etc..

  9. I have been following you for a couple of months now but this is my first time commenting on a blog post. Thank you for sharing your knowledge and experience with us. Keep up the good work. Already bookmarked for future reference.
    Hadoop Training in Chennai
    Hadoop Training
    Best Hadoop Training in Chennai
    Best Hadoop Training Institute in Chennai

  10. Wonderful bloggers like yourself who would positively reply encouraged me to be more open and engaging in commenting.So know it's helpful.

    digital marketing company in india

  11. This post is really nice and informative. The explanation given is really comprehensive and informative.. android Training in Chennai

  12. Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.

    Dotnet Training in Chennai

  13. I am regular visitor of this blog .I am working as blog reviewer in a private press and I saw many useful posts here. Sure, I will give best ratings for this blog .Keep posting best posts like this to get top reviews and ratings from blog reviewers and people .And I am thankful for this valuable post.
    Nautical Science Colleges in Chennai | Mechanical Colleges in Chennai | ECE Colleges in Chennai

  14. I have read your blog its very attractive and impressive. I like it your blog.

    Java Online Training Java EE Online Training Java EE Online Training Java 8 online training Core Java 8 online training

    Java Online Training from India Java Online Training from India Java Online Training

  15. I have read your blog its very attractive and impressive. I like it your blog.

    ES6 Online Training JavaScript Training Courses JavaScript Training Courses | Angular 4 Online Training Angular 4 Online Training


  16. Its very useful to me. Wonderful blog.. Thanks for sharing informative Post.

    Installment loans
    Payday loans
    Title loans


  17. Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much

    Personal Installment Loans
    Title Car loan
    Cash Advance Loan

  18. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
    rpa training in chennai
    rpa training in bangalore
    rpa course in bangalore
    best rpa training in bangalore
    rpa online training


  19. Hello! This is my first visit to your blog! We are a team of volunteers and starting a new initiative in a community in the same niche. Your blog provided us useful information to work on. You have done an outstanding job.
    Advanced AWS Training in Marathahalli |No.1 AWS Training in Marathahalli
    Best AWS Amazon Web Services Training Institute in Chennai | No.1 AWS Training Institutes for Solution Architect in Chennai | Advanced AWS Certification Training in Chennai