Pages

Friday, May 3, 2013

Install OBIEE 11g application with RCU using Oracle Database Express Edition 11g

Overview

The following information is for anyone that would like step by step instructions for setting up OBIEE 11.1.1.7 on a single machine for demo purposes. This includes the steps for setting up an RCU database using Oracle Database Express Edition 11g on the same machine.  Therefore, you don't necessarily need to get a dba involved.  Oracle SQL Developer 3.2.2 client is needed so you can setup the BI and MDS database account/schemas that RCU will need.

Steps
  1. Download Oracle Database Express Edition 11g 
  2. Download Oracle SQL Developer 3.2.2 
  3. Download Oracle Business Intelligence Enterprise Edition files 
  4. Download Oracle Fusion Middleware Repository Creation Utility 11g (11.1.1.7) 
  5. Install Oracle Database Express Edition using defaults 
  6. Open SQL Developer (no install required) client, connect to XE database, and create DEV4_BI and DEV4_MDS (names can be anything you want). Grant these accounts full access. 
  7. Initiate RCU by running RCU.bat file. This will create and load component schemas into the database. In this example, selected only Oracle Business Intelligence Platform, and the install forced the selection of Metadata Services.
  8. Initiate OBIEE 11G install by running setup.exe file. Used the simple install as no load balancing is required. This type of install will not use as many resources, and will allow faster start and stopping of the system. 
  9. Validate WebLogic Console is running. 
  10. Validate Fusion Middleware EM is running. 
  11. Validate OBIEE is running, which will be using the default "sample" rpd. 


Step Screenshots























































1 comment:

  1. Hi,

    Thanks for your post.

    I have a query, we are providing database sys user/password while installing rcu, hence suppose application team wants to install obiee and sysdba credential is necessary for this installment then aren't we compromising the db by sharing sys password with application users.

    Do we have any other workaround to solve this issue?

    Because I have seen in many Oracle application installation it requires to enter sys credentials for the connecting database, I am not sure how to solve this issue.

    Kindly suggest

    Regards
    Saurabh
    mail2saurav.gupt@gmail.com

    ReplyDelete