Saturday, July 12, 2014

RCU for BIAPPS and ODI


BI APPS 11.8 Installation[CREATING RCU for ODI and BIAPP]part -3

In this Part 3 of Bi Apps Installation we will  have the Practice of Installing the RCU for BI APPS and ODI
for Running the Rcu we need to download the  software and unzip in the database server temp folder 
 
CREATING RCU FOR BIAPPS

Step 1
Navigate to the /home/oracle/rcu/bin-- rcu is the staging directory where we unzip the V44918-01.zip 
run ./rcu to invoke the installer 


Step 2
Click create Button to create the RCU for BIAPPS

Step 3
Provide the data warehouse database details 
Host name      :=data warehouse database host name
Port               :=  Database Port
ServiceName  :=Data warehouse database service Name
Username       :=SYS
Password       :=Password of SYS user


Once the Prerequisite check completes fine then click ok and proceed to next step

Step 3
Create the Prefix as BIAPPS
and select the Oracle Business Analytic Warehouse-- it will create only the BI apps repository and we will create the ODI repository later

Step 4 

Provide the password for the BIAPPS schema user

Step 5
we need to provide the dump file location .. there are three dump file available and two of  ODI and one for BIAPPS

[oracle@biapp schema]$ pwd
/home/oracle/rcu/rcu/integration/biapps/schema
[oracle@biapp schema]$ ls
-rwxrwxr-x. 1 oracle oinstall 379461632 Apr 18 18:43 obia_comp.dmp
-rwxrwxr-x. 1 oracle oinstall 125952000 Apr 18 18:43 obia.dmp
-rwxrwxr-x. 1 oracle oinstall 857681920 Apr 18 18:42 obia_odi.dmp
-rwxrwxr-x. 1 oracle oinstall                70 Apr18 18:43 dmplabel.txt
[oracle@biapp schema]$
if you are installing the BI rcu from the different server then we need to keep this three files in the DW database server tmp directory and we need to mention the location in the value column


Step 6

Check the table space the will be create for the new schema

Increase the size of the  table space according to the requirement



Step 7
Check the summary and proceed with the installation of RCU

Step 8
Check the summary and click finish for complete the RCU

CREATING RCU FOR ODI

Step 1

Run the ./rcu from the /home/oracle/rcu/bin  /home/oracle/ruc is the staging directory where the ruc software had been unzipped 

Step 2
Click create to create the new RCU


Step 3
Host name    Data Warehouse  database host name
Port              Database port
Service         Database Port
User Name  SYS
Password    OMsys123
check ok after the prerequisite check's had been completed successfully

Step 4
Create the prefix for the ODI Scheme's
select the components show in screen  to create the ODI schema

Step 5
[oracle@biapp schema]$ pwd
/home/oracle/rcu/rcu/integration/biapps/schema
[oracle@biapp schema]$ ls
-rwxrwxr-x. 1 oracle oinstall 379461632 Apr 18 18:43 obia_comp.dmp
-rwxrwxr-x. 1 oracle oinstall 125952000 Apr 18 18:43 obia.dmp
-rwxrwxr-x. 1 oracle oinstall 857681920 Apr 18 18:42 obia_odi.dmp
-rwxrwxr-x. 1 oracle oinstall                70 Apr18 18:43 dmplabel.txt
[oracle@biapp schema]$
provide the path in the value

Step 6


Step 7
Check the summary 


2 comments:

  1. I am very impressed with the article I have just read, so nice.. We are also providing the best services click on below links to visit our website.

    Oracle Fusion HCM Training
    Workday Training
    Okta Training
    Palo Alto Training
    Adobe Analytics Training

    ReplyDelete