Fusion Applications bare metal provisioning series Part V: Installing a Transaction Database

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

Screen Shot 2013-11-07 at 19.09.01 PM
Choose the directory for Provisioning software location:
Screen Shot 2013-11-07 at 19.09.22 PMFinally start the installation and make sure it completes successfully:
Screen Shot 2013-11-07 at 19.09.42 PMOnce this has been done, we can now run the Provisioning Wizard to install Transaction database.

cd /u01/provisioning/provisioning/bin
./provisioningWizard.sh

Screen Shot 2014-07-03 at 09.42.46 amChoose to install an Applications Transactional Database and enter configuration details as below:
Screen Shot 2013-11-07 at 19.21.04 PMMake sure the Prerequisite section completes without any warning and proceed with Database installation:
Screen Shot 2013-11-07 at 19.33.53 PMMake sure all the stages of Database installation has been completed successfully. Note that in PostConfigure phase required patches are applied:
Screen Shot 2013-11-07 at 21.18.32 PMOnce 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

Screen Shot 2013-11-07 at 22.14.47 PM Enter your database information and click Next: Screen Shot 2013-11-07 at 22.15.15 PM Make sure that Prerequsite checks complete successfully and choose all the Fusion Applications components to be loaded: Screen Shot 2013-11-07 at 22.16.13 PM Next enter the values for asked variables. You can pick any directory for log variables that suits your architecture outline: Screen Shot 2013-11-07 at 22.21.09 PM Leave the default tablespaces intact or change them according to your needs: Screen Shot 2013-11-07 at 22.21.22 PM Make sure that tablespaces are successfully created and after crosschecking the summary page, proceed with loading the schemas into database: Screen Shot 2013-11-08 at 10.36.52 AM 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.

About these ads

11 thoughts on “Fusion Applications bare metal provisioning series Part V: Installing a Transaction Database

  1. Greetings from Ohio! I’m bored to tears at work
    so I decided to check out your site on my iphone during lunch break.

    I really like the information you present
    here and can’t wait to take a look when I get home. I’m surprised at how quick your
    blog loaded on my cell phone .. I’m not even using WIFI, just 3G ..
    Anyhow, good site!

  2. Anyone who is familiar with the laws of DUI dui attorney or
    dui lawyer offenses are very austerely imposed.
    In case you are caught drunk driving for the dismissal of the country aand nno one
    betrer than less when making an event journal.
    This could mean to ypur case will progress to a blood alcohol test to maake
    sure you appoint one in the past forr vehicular homicide.
    Often times, dui attorney or dui lawyer you may alpso be a criminal act and you
    may be revoked.

  3. Hello there I am so grateful I found your webpage, I really found you by error,
    while I was searching on Askjeeve for something else, Regardless I am here
    now and would just like to say many thanks for a incredible post and a all round thrilling blog (I also love the theme/design), I
    don’t have time to read it all at the moment but I have bookmarked it
    and also included your RSS feeds, so when I have time I will be back to read more, Please do keep up the great b.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s