Create Fusion Applications Schema using RCU : fusion & otbi
This is sixth post in series “Learn Oracle Fusion Applications with onlineAppsDBA.com” and covers steps to create/load Fusion Applications Schema’s in Transactional Database. For first five posts check
- Oracle Fusion Applications Concepts
- Install Oracle Fusion Applications in 10 Steps
- FA Provisioning Framework Overview
- Install FA Provisioning Framework
- Create Transactional Database for Fusion Applications
.
Steps to load/create Fusion Applications Schema
1. Create below directories under $ORACLE_BASE (These directories can be anywhere on database server) of Oracle Database provisioned in earlier post here
a) $ORACLE_BASE/FADP (This directory contains dump files for fusion applications used during schema creation)
b) $ORACLE_BASE/applcp (Used by Oracle Enterprise Scheduler (similar Concurrent Manager in 11i/R12) to store the log and output files)
c) $ORACLE_BASE/appllog (Used to store PL/SQL log file from Oracle Fusion Applications PL/SQL procedures)
d) $ORACLE_BASE/keyflexcombfilter (Filter XMLSchema, used for re-loading in case of a patch)
e) $ORACLE_BASE/otbi (This directory contains dump files for business intelligence used during schema creation)
2. Extract and copy the dump files
a) cd $fusion_software/installer/apps_rcu/linux/rcu/integration/fusionapps
b) unzip export_fusionapps_dbinstall.zip
c) cp *.dmp $ORACLE_BASE/FADP
d) cd $fusion_software/installer/apps_rcu/linux/rcu/integration/biapps/schema/otbi.dmp $ORACLE_BASE/otbi
3.Start Fusion RCU installation from $fusion_software/installers/apps_rcu/linux/bin/rcu
4. Select “Create” and click “Next”
5. On “Database Connection Details screen” Fill Database details created during Database provisioning in earlier post at here
username : sys (or user with sysdba priviliges)
6. On “Select Components” screen, select “Fusion Applications” as shown in below image
.
7. On custom variable screen, provide full path to directory created in step 1 above . (Make that that *.dmp files are copied from fusion_software in to $ORACLE_BASE/FADP & $ORACLE_BASE/otbi as explained in step 2 above)
.
.
8. On summary screen click “Create” (depending on CPU and memory available this process may take couple of hours)
Finally you should see status as “Success” against all components as shown below
For any issues check RCU logs under $fusion_software/installers/apps_rcu/linux/rcu/log/logdir.YYYY-MM-DD_HH-MM/*.log
Next step for Fusion Applications installation is to install, Identity and Access Management components (OID, OVD, OAM) coming soon ….