An Oracle Fusion Applications environment requires a transaction database. You can install a single-instance Oracle Database Enterprise Edition by using the Provisioning Wizard, or you can install Oracle Real Application Clusters (Oracle RAC) by using the standard installation instructions. The database templates shipped with Oracle Fusion Applications describe the structure and features of the database, but do not contain any data. You can place the Transaction database either on IdM database server host or Fusion Applications node, however, it is strongly recommended to separate it from other components. We will install the database using Provisioning Wizard since it also automatically applies all the required patches.
Prepare your server as you would do for any other standard Oracle database installation. Means you have to apply all the prerequisite rpm’s, create users, perform server configuration, etc. The fastest way you can achieve it by using yum and Oracle RDBMS Server 11gR2 Pre-Install RPM.
Then, we have to install Fusion Applications Provisioning wizard software on the database host where we are going to provision Transaction database. The wizard is similar to the one we’ve used for IdM part. Browse to our installation stage directory and run installer:
cd /fusion_media/installers/faprov/Disk1 export JAVA_HOME=/fusion_media/jdk6 export DISPLAY=:01 ./runInstaller
Choose the directory for Provisioning software location:
Finally start the installation and make sure it completes successfully:
Once this has been done, we can now run the Provisioning Wizard to install Transaction database.
cd /u01/provisioning/provisioning/bin ./provisioningWizard.sh
Choose to install an Applications Transactional Database and enter configuration details as below:
Make sure the Prerequisite section completes without any warning and proceed with Database installation:
Make sure all the stages of Database installation has been completed successfully. Note that in PostConfigure phase required patches are applied:
Once the database installation is complete, make sure you are able to connect to it via listener and database is up and running normally. If that is the case, proceed with loading schemas into the database using Fusion Applications Repository creation utility.
– Unzip the rcu software:
cd /u01 unzip /fusion_media/installers/apps_rcu/linux/rcuHome_fusionapps_linux.zip
– Create directory for Data Pump required for importing data into the database and unzip required dump files to that directory. This is a mandatory step for RCU:
cd /u01/apps_rcu mkdir dp_dir cd dp_dir unzip /u01/apps_rcu/rcu/integration/fusionapps/export_fusionapps_dbinstall.zip cp /u01/apps_rcu/rcu/integration/biapps/schema/otbi.dmp ./</pre>
– Launch Repository Creation Utility:
cd /u01/apps_rcu/bin/ ./rcu
Enter your database information and click Next: Make sure that Prerequsite checks complete successfully and choose all the Fusion Applications components to be loaded: Next enter the values for asked variables. You can pick any directory for log variables that suits your architecture outline: Leave the default tablespaces intact or change them according to your needs: Make sure that tablespaces are successfully created and after crosschecking the summary page, proceed with loading the schemas into database: Once the process is finished, double-check again that Database is fully available and there were no errors during schema load. We are now ready for response file creation for Fusion Applications provisioning.