Home > OBIEE 11g > OBIEE 11gR1 Step by Step Installation

OBIEE 11gR1 Step by Step Installation

Fusion Middle ware BI 11 G Installation:-

I have been desperately looking for the new release of OBIEE 11g and wanted to see the new feature of OBIEE 11g . It made me little disappointed when I came to know my 2 GB RAM Laptop is not meeting the minimum requirement , but I still decided to install on my laptop DELL Latitude 5400 with below configuration.

Core2 duo 2.4 GHZ ,  2 GB of RAM

After complete installation,  services took little time to start up but once started the performance of presentation services / Dashboard /Reports is awesome.

Note: – It recommends having atleast 4 GB of Ram to start with.

OBIEE 11g software can be downloaded from here –

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html

The install comes in 4 files:

bi_windows_x86_111130_32_disk1_1of2.zip

bi_windows_x86_111130_32_disk1_2of2.zip

bi_windows_x86_111130_32_disk2_1of2.zip

bi_windows_x86_111130_32_disk2_2of2.zip

Optional Software: (RCU –Repository creation Utility)

 

ofm_rcu_win32_11.1.1.3.3_disk1_1of1.zip

Fusion Middle ware BI installation following steps:-

1. Install a database

Note :- I have installed Oracle 11g R1 for this purpose.

2. Use RCU( Repository creation Utility ) to create BIPLATFORM & MDS needed for BI and Oracle Application server during installation.

With this release of 11gr1 ,RCU can be used to create schema for Oracle 9i /10g/11g , MS SQL server or IBM DB2 only.

Note :- I have used Oracle 11gr1 to create DEV_BIPLATFORM and DEV_MDS schema.

3. Kick off Fusion middle ware installation.

Run the BI11g setup to start 11g installation.

Now I will start with the step by step installation of OBIEE 11GR1  :-

Pre installation, I have changed the virtual memory of system with (3000 – 6000) to rum the installer smoothly.Step 1. create BIPLATFORM and MDS schema using RCU(Repository creation utility).

1.Please unzip the optional software downloaded from OTN

ofm_rcu_win32_11.1.1.3.3_disk1_1of1.zip

Now navigate to \rcuHome\BIN and run rcu.bat .

2.In next screen batch file will open a java app with pretty self explanatory screens.

Note:-  you can drop the schema using RCU if in case your installation did not happen successful.

3. Here please provide the Host name , service name , user name and password for the database. You need to have a user created with DBA privilege.

4. Here please select the metadata services (under AS common Schemas) and Business Intelligence Platform (Under Oracle Business Intelligence). Name of schema would be auto configured by RCU.

6. This screen will allow user to select the password for the schema created.

7. Once you provide the password the password for the schema the RCU wizard will create the schema in the database. It will create a table space for the newly created shema . You can also change the table space for the scema.

Once RCU creates the required schema and table spaces in database we are good to go with OBIEE 11g Installion.

2. Installing OBIEE 11g fusion Middle ware.

Now navigate to unzip disk 1 and start the set up

There are 3 type of installation this release comes with.

Simple Install: – install Oracle Business Intelligence Enterprise Edition, Oracle Business Intelligence Publisher, or Oracle Real-Time Decisions with the default settings on a single computer in the minimum number of steps.

Enterprise Install: – install a new Oracle Business Intelligence system for a hosted deployment on one or more computers. When you select the Enterprise Install type for a new installation, Oracle Business Intelligence 11g Installer installs the Oracle Business Intelligence components that you select, such as Oracle Business Intelligence Enterprise Edition, Oracle Business Intelligence Publisher, and Oracle Real-Time Decisions.

 

Software Only Install :- install software binary files in an Oracle home for later configuration as part of a Fusion Middleware deployment.

It is recommended to go for Simple install for Single development machine. I have installed both Simple Install and Enterprise install in two different machine. During installation I figure out that simple install will give you error while configuration but Enterprise install is a clean installation. So I would recommend going for Enterprise installation if you are installing first time.

After selecting Enterprise Install the next screen will prompt for Password for Weblogic. Here we are creating a new BI system with User specified parameters.

Next screen will prompt for Middle ware home . I have selected c:\Middleware for this installation.

Next screen will prompt you which product we want to install.

Next Screen will prompt for DatabaseType , Connection string , BIPLATFORM Schema and Password .

Connection string – Hostname : Port:database

BIPLATFORM Schema User Name – DEV_BIPLATFORM (created by RCU)

BIPLATFORM Schema password – ***** (created by RCU)

Next screen will prompt for configuring port.

  • Port configuration for first time installation

If you are installing OBIEE 11g for the first time without any prior installation then select “Auto port Configuration”

  • Port configuration for existing OBIEE10g machine

if you are installing OBIEE 11g on the same machine where OBIEE 10g is already installed then specify the ports using configuration file.

Note :- For this installation I already had previously installed OBIEE 10.1.3.4 in my machine so I had to provide the configuration file for ports as OBIEE 10g also uses the same port i.e.  9704,9703,9710 etc. If you are not providing the configuration file and going for “Auto port configuration” in existing OBIEE 10g system then there are fair chances of failure of OBIEE 11g installation.

Next screen is the summary of newly creating Oracle BI system.

Now when I click on next the installation and configuration will start and be patient it will take lot of time depending upon the system configuration. It took 113 minutes for me to complete the installation(can be seen in screen shot).

Now once installation 100 % complete please save the install_config log to local drive.

Once you click on finish the next window will open for OBIEE 11g Presentation services.

Please user the username and the password as weblogic (used at installation time) .

Now i could see the flash enabled  exciting OBIEE 11g front end.:)

SO here i have OBIEE 11g with existing OBIEE 10.1.3.4.1

and services look like -

 

 

 

 

 

 

 

 

 

 

 

 

  1. Rahul
    August 22, 2010 at 8:24 am | #1

    Nice Work Thakur :-)

  2. August 22, 2010 at 5:11 pm | #2

    Thanks .. Rahul .

  3. August 23, 2010 at 1:06 am | #3

    Kool Stuff!! Excellent…

  4. August 23, 2010 at 1:11 am | #4

    Thanks @soulmate

  5. August 23, 2010 at 12:22 pm | #5

    too good master of OBIEE..

  6. RaviKM
    August 24, 2010 at 12:42 pm | #6

    Good Article ..buddy..

  7. Anil Golyan
    August 30, 2010 at 4:19 am | #7

    Excellent Work Jyothi. Do you have specs for Linux also?

    • August 30, 2010 at 8:35 am | #8

      Soon I will be installing on Linux . I will update with that.

  8. August 31, 2010 at 1:59 am | #9

    Dear, may i know what all steps to be considered for upgradation/migration of OBIEE 10.1.3.4 to OBIEE 11G? Is there any documentation on this as well??

    • August 31, 2010 at 11:13 am | #10

      I have been too busy in my projects but Yes I will update my blog with the Upgrade / Migrate soon.

  9. Donna Burgess
    January 18, 2011 at 12:12 pm | #11

    Hello!

    I installed obiee 11g on Windows 7 (after installing loopback adapter). I installed simple install, and it works great immediately after the install completes. HOWEVER, when I shut down or restart, I cannot re-open OBIEE, either with FireFOX or IE. I get an error that says that Donna-pc:9704… cannot be accessed.

    Have you experienced this when installing?

    Any information you may be able to provide would be greatly appreciated.

    Donna burgess

    • January 20, 2011 at 9:15 am | #12

      Hi ,

      Are you still experiencing the issue?

      Could you let me know whether all services are up and running. (Please check in Enterprise manager console)

      Jyoti

  10. Manish Gianani
    March 22, 2011 at 2:12 am | #13

    Hi,
    while installing OBIEE Enterprise install,following tools failed:-
    1) Deploying BI Publisher JEE Application
    2) Setting up BI Publisher

    Please help
    Manish

  11. Rajesh Shah
    May 23, 2011 at 11:20 pm | #14

    Jyoti,
    Quick question…

    we just migrated from 10g to 11g (11.1.1.5) and for few reports we are getting following error…any idea or resolution?

    Error Codes: OAMP2OPY:ACIOA5LNAssertion failure: isXsiTypeSqlExpression(rExpr) at line 67 of /scratch/aime1/adestore/views/aime1_dadvfa0112/bifndn/analytics_web/main/project/webreport/exprformulautils.cpp

    Regards,
    Rajesh

  12. Rajesh Shah
    May 23, 2011 at 11:23 pm | #15

    Jyoti,
    Quick question…

    we just migrated from 10g to 11g (11.1.1.5) and for few reports we are getting following error…any idea or resolution?

    Error Codes: OAMP2OPY:ACIOA5LNAssertion failure: isXsiTypeSqlExpression(rExpr) at line 67 of /scratch/aime1/adestore/views/aime1_dadvfa0112/bifndn/analytics_web/main/
    project/webreport/exprformulautils.cpp

    Regards,
    Rajesh

  13. Phani
    August 28, 2011 at 8:42 pm | #16

    Hi Jyoti

    I am getting the same error Donna Burgess (last response) is getting.
    Can you suggest something? All services are running I believe.

    I am new to oracle

    Thank you..

    • August 29, 2011 at 2:20 am | #17

      Hi ,

      Could you please check the windows firewall setting that is trying to block the BI presentation services to run.

      Try to make window firewall off and run the Obiee services.

      Jyoti

  14. Ash
    December 16, 2011 at 1:30 am | #18

    Hi Jyoti…

    Thanks for such a wonderful article. Can you help in resolving an error that I got while running the RCU. The error says : “RCU-6093:Skipping Main operation: Failed in SchemaTablespace step validation” How can I resolve this. Please help…

  15. riceball
    January 30, 2012 at 8:25 pm | #19

    thanks for the detailed help!

  16. August 16, 2012 at 6:37 am | #20

    Hi, I am trying to install OBIEE 11g. In my PC, I have install oracle 10g database. While installing the RCU I am getting below error” .

    “The Database you are connecting is not a supported version. Enter Database with version equal to or higher than 10.2.0.5 in 10g or version equal to or higher than 11.1.0.7.0 in 11g.”

    Can anyone help me?
    Please let me know what I need have to do install the RCU.

    Thanks
    Rakesh Patil
    +91- 9632009328

    • August 16, 2012 at 8:40 am | #21

      Hi Yovraj,

      Usually Oracle supports backward copatibility but Here with OBIEE 11g you need to have database heigher than 10.2.0.5 (10gR2).
      Thanks

      • August 16, 2012 at 8:42 am | #22

        Ok thanks jyoti..So i have to install oracle 11g.

      • August 16, 2012 at 2:03 pm | #23

        yes ..else Oracle 10g R2 .. which ever you get it . But recommended is Oracle 11g.

      • August 16, 2012 at 2:12 pm | #24

        thanks..for reply. Just now RCU install susses-fully. do you have any idea, which OBIEE i have to install in window 7 32bit.i have obiee but while install it saying it saying ” Download the appropriated installer for your operating system”

        if you have any link pls let me know.

      • August 20, 2012 at 5:54 am | #25

        Hi Jyoti,

        while installing the OBIEE i getting the below error,

        creating asinstance failed obiee 11g
        execution opmnstl start coreapplicatin_obiccs1
        execution opmnstl start coreapplicatin_obis1
        execution opmnstl start coreapplicatin_obips
        execution opmnstl start coreapplicatin_obijh1
        execution opmnstl start coreapplicatin_obisch1

        Do you have any idea why i am getting this error..if possible please give me you cell number and also let me know your free time.

        Thanks
        Rakesh Patil.
        09632009328

  17. BalaKiran Munagapati
    February 19, 2013 at 8:23 am | #26

    Hi Jyoti,

    I’m trying to install the OBIEE11g in personal machine, while installing the RCU the getting error like “Please enter valid hostname & Port (or) check if the listner is up and running”. But i have given hostname as “my system name and port as ’1521′”.

    Please guide me on this issue.

    Thanks

  18. Gill Lima
    April 11, 2013 at 2:00 pm | #27

    Hello Guys,

    I have been trying to install this OBIEE for a week now and I always come at some error and ends in an unsuccessful installation.

    It usually starts to give me error at Installation Progress on 97% with:

    common/ODBC/Merant/6.0/ODBC.reg not found
    essbaseserver/bin;essbase_sso.cfg not found

    But I havent been able to find those in the internet after googling my brains off still there’s no result.

    Then I skip it and it “finishes” but at the Configuration Step it AWAYS crashes on Deploying Base Setup
    then from there on its full HELL.

    It never asks me any of the other CDs I downloaded (they are in different folders Disk1, Disk2…5 etc).

    I’m installing on
    - Windows XP Pro,
    - OBIEE 11.1.1.60 with Oracle Database Enterprise 11g,
    - Loopback adaptor (I am on a corporate network so I have a machine_name.domain) with 192.168.1.1 ip address
    - Created the line on the Hosts file pointing the Computer name to the Loopback ip addr

  19. kanthareddy
    July 14, 2013 at 6:10 am | #28

    HOW TO WE KNOW PASSWORD? (step 7 of 13)
    what is RCU password, where will we find it?

  20. Nilesh Kapase
    January 16, 2014 at 5:00 am | #29

    Thanks…. wonderful blog…

  21. Tahir Ishaq
    March 5, 2014 at 4:30 am | #30

    Greate

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: