Saturday 9 November 2013

OBIEE 11.1.1.7.0 RCU Installation

If you have installed database already on your system, you can simply skip this section.

Before we starting the installation of RCU, we need to choose that which database we are going to use in our application. Here I am giving how to run RCU in Oracle database on our local machine. It is good to install Oracle Database Enterprise Edition to take full advantage of database for data types like spatial data or features like OLAP.

Installation Prerequisites:

Here I am giving the installation steps that how I have installed RCU in windows 64-bit Operating system.
  • Minimum of 4 GB RAM required, 3 GB RAM would work but, system would be slow.
  • Minimum of 50 GB hard disk memory required.
Do not use any directory name with space while installing/working with Oracle DB and OBIEE.

Installing Oracle Database with the following settings:

  • System Class : Server Class
  • Grid Installation Options : Single instance database installation
  • Select Install Type : Advanced Install
  • Select Database Edition : Enterprise Edition
  • Select Configuration Type : Data Warehousing
  • Specify Configuration Options : Character Sets > Use Unicode (AL32UTF8)
  • Specify Configuration Options : Security > Un-check Assert all new security settings
  • Specify Schema Passwords : Use the same password for all accounts ("Welcome1")

Installing RCU:

OBIEE 11g is now standardized with Oracle fusion middleware and hence leverage database for metadata storage just like any other middleware product. So here we are going to install BI11g metadata schema on oracle database you just installed and configured. Same process can be leveraged to install metadata schema on other supported databases as well.
If you have not done already, please download RCU installation files from below URL:

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1923016.html

Locate Required Additional Software's: 

Please make sure all the zipped files have downloaded correctly and unzipped into a single folder.

1) Now we will start the installation of metadata schema using Repository Creation Utility (RCU).

2) From unzipped folder for RCU, run rcu.bat file to start the Repository Creation Utility: 
For this practice, rcu.bat file is located under E:\Softwares\OBIEE-11.1.1.7.0\rcuHome\BIN directory.

Please make sure that, there are no any spaces in the folder path where setup files are located.

3)  RCU utility will launch the GUI based wizard to guide you through the steps. Click Next to continue.

4) Select Create from the below screen and click Next.

5) In the below step Make sure database type is Oracle Database and enter following information to continue.

6) Since we are using oracle database, RCU will show a warning message that you can just ignore and can continue the installation.

7)  Click OK to continue once RCU validates and initializes database configuration.

8) In the next step it will ask for the prefix to create the metadata schema. By default it is showing 'DEV'. If we want to change the prefix we can  change it. From the below window select appropriate schema which we need to install. I have selected only two which is showing in the screenshot.

9) Click 'Next' from the above screen to create schema and the click 'OK' once RCU shows schema creation prerequisites check completed.

10) In the next step, Enter password for both the schema as you like with the password conditions (such as alphabet, numeric and with special character) and click 'Next' to continue.

11) Click 'Next' with the above step to have RCU create the selected schema.

12) Click 'OK' to continue creation of tablespace.

13) Once tablespace created, click 'OK' to continue.

14) Now RCU will create required schema objects within the tablespace just created. So Click 'Create' with next step and continue.

15) Click 'Close' to finish RCU wizard once schema are created successfully.

With the above step the installation of RCU is completed.

Note:
Remember the password which we have given for all the  users/schema so far and we will continue to use the same password. We will need this password for BI installation as well to let BI installer knows where the metadata schema located and what is the password to connect to the schema. Now we can log-in to the oracle database and can whether that two schema (DEV_BIPLATFORM, DEV_MDS) is available.

After completing this session, you can refer the following link to go ahead with the installation of OBIEE 11.1.1.1.x version.

http://obieenow.blogspot.in/2014/01/OBIEE-11.1.1.7.0-Step-By-Step-Installation-on-Windows-x86-64.html

Happy blogging..!! :-)


No comments:

Post a Comment