Hiren Patel 2015-08-24 Technical obiee obiee 11g BI Business Intelligence Reporting tool 31 comments
OBIEE 11g RCU InstallationDatabase Installation and Configuration:
If you installed database already on your machine, you can skip to 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 or standard edition to take full advantage of database for datatypes like spatial data or features like OLAP.
• Min of 4GB RAM required.
• Minimum of 10GB hard disk memory required.
• not use any directory name with space while installing/working with Oracle
DB and BI11g.
BI 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 BI11g installation files and RCU installation files. Please make sure all the zipped files have downloaded correctly and unzipped into a single folder.
We can download the software from below Download page:
Now we will start the installation of metadata schema using RCU.
From unzipped folder for RCU, run rcu.bat file to start the utility: rcu.bat file is located under rcuHome\BIN directory.
RCU utility will launch the GUI based wizard to guide you through the steps. Click Next to continue.
In the below step Make sure database type is Oracle Database and enter following information to continue.
Host Name: localhost
Service Name: ORCL
From the below window select appropriate schemas which we need to install.
I have selected only two which is showing in the screenshot
Click 'Next' from the above screen to create schema and the click 'OK' once RCU shows schema creation prerequisites check completed.
Now RCU will create required schema objects within the tablespace just created. So Click 'Create' with next step and continue
Remember the password which we have given for all the users/schemas 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 schemas located and what is the password to connect to the schema. Now we can login to the oracle database and can whether that two schems (DEV_BIPLATFORM, DEV_MDS) is available.