Oracle Fusion Applications: Creating Fusion applications database RCU

Creating the repository in fusion applications database [RCU]

The repository creation utility is used to create the Fusion schema's in the bare Mattel database before Installing the fusion applications we need to install the separate database which holds the data's of the fusion applications and two other database's for IDM

The fusion applications database which holds the schema for all the modules of the fusion applications ...there are some special init Parameter's for the Fusion applications database we need to specify refer to the release notes or EDG for init parameters which suites your environment

For starting the RCU screens we need go to the location where the binaries are unzipped /fashared/rup3/installers/apps_rcu/linux
you will find a zip file called rcuHome_fusionapps_linux.zip
unzip the rcuHome_fusionapps_linux.zip in the /tmp directory
copy the bi component from rcu/integration/biapps/schema and place it in the unzipped directory /tmp/rcu

Step1

Run the RCU

Step 2
Select the create to create the RCU in the database

Step 3

We need to Specify the database connection

Host name :fully qualified host name
Port :database port
service name :database service name
Username :sys
Role :sysdba

Step4

Rcu will check the prerequisites to create the repository

Step5

We need to select the Fusion applications ,secure Enterprise search to create the fusion applications repository

Step6

Click Ok when all the prerequisites are fulfilled

Step 7

Provide the necessary password for all the schema

Step8

Provide the values in the boxes

Directory on the database machine : /tmp/rcu we have unzipped the rcu from the installers in the /tmp/rcu
APPLCP_FILE_LOG =$ORACLE_HOME/log
APPLLOG_DIR =$ORACLE_HOME/log
OBIEE backup dir /tmp/rcu
KEYFLEXCOMPFIELTER /tmp/rcu
Advanced compression option N [if you have advanced compression options in you db environment then you can give Y]
partitioning Y [ oracle partitioning ]
Master repository 501
Work repository D == provide the value D not provide the value R ...
Work repository ID 501
Work repository_Name Fusionapps_WREP
Oracle transactional BI /tmp/rcu
Activity Graph and analysis Y

Step9

Create the necessary table spaces