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
/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
Really very helpful article , Thank you for sharing
ReplyDeleteoracle fusion hcm online training
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.
ReplyDeleteOracle Fusion HCM Training
Workday Training
Okta Training
Palo Alto Training
Adobe Analytics Training