Installing Oracle Fusion Apps 11.1.7 for testing purpose

I start reading the Fusion Application documentation, and what I can say it that ALL Oracle technologies stack are used to build this fusion application solution. As a Solution Architect, this is really a good opportunity to start working on this Oracle Solution, as it provides me some technical and functional challenges for the next couples of years. I don’t pretend to have all the skillets on Oracle’s technologies, but for people who knows me, i like dirty/practical hands-on and I never give up against technologies 🙂

What I tried to achieve is the installation of the following Fusion Accounting Hub Basic Topology on my own environment:
What is Fusion Accounting Hub? Check this link: http://davidhaimes.wordpress.com/2013/10/11/what-is-fusion-accounting-hub/
Oracle Fusion Accounting Hub Basic Topology

Update 08/01/2014: After the FusionAccounting Hub installation, here is what we get for IDMHost Domain:
Oracle Fusion Accounting Hub IDMHost Domain

Update 08/01/2014: After the FusionAccounting Hub installation, here is what we get for FAHost Domain:
Oracle Fusion Accounting Hub FAHost Domains

I hope that Oracle will provide soon some Oracle VM Template in order for the customer who are interested in this solution to install and test the Oracle Fusion Apps.

The technical challenge is huge and the first showstopper is the hardware material where you need a powerful machine in terms of CPU & RAM. The documentation state that you need at least 128Gb of RAM in order to have a running fusion instance. Of course, at home, I do not have this amount of ram; but i can use Oracle VM server to recycle of my old machines and laptops. At the end, I have around 96Gb of RAM available on my VM server. The difficulty here will be :How can I check/consolidate all logs file from the different Application Managed Server (ams), Middleware managed server (mms) into one single place ?. I will post a solution once I have implemented it, using either what we have in house or using open source solution.
Update 31/12/2013: Can’t wait to integrate ? and the award winners are: logstash + ElasticSearch + Kibana
Nothing more to say about this topic as it is perfectly documented here: http://logstash.net/docs/1.3.2/tutorials/getting-started-centralized. What I like is the simplicity of the installation process, compare to what i’m trying to do in the next following steps 😉

Disclaimer: the purpose of this post is to have a running fusion App on my environment for testing purpose. If you need to deploy Fusion Apps in production, please contact Oracle Support Document 1379929.1 (Fusion Applications – How to get Sizing Requirement?) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1379929.1

Here are the list of challenges I have encountered when I start digging into the Fusion Apps installation:
– Some Linux Administration skills to install patches & missing RPMs, manage LVM, connect to NFS server
– Setting up a proper Oracle VM server, and configure a proper environment in order to take some clone/snapshot in order to redo the installation when the installers failed due to missing OS patches, misconfigured software, missing RAM, network issues…
– Some Oracle Database Administration skills when install and provision Oracle Database instance
– Read the tons of logs generated by the fusion installer and weblogic managed server intances to solve some installations issues
– and a lot of patience & perseverance to make this all happened. I took me at least 6 full days and some of my week-ends to setup the Fusion Apps for my testing purpose.

Day1: Getting the Oracle Fusion Apps binaries
* Step1 : download the Oracle Fusion Apps from https://edelivery.oracle.com/
It is +60Gb zip files to download for a Linux Platorm. Use checksum to validate the downloaded binaries.
* Step2 : Extract all the zip in a mounted NFS shared server into a stage folder (+70Gb)
* Step3 : Define the topology that matches your needs. For the sake of simplicity, I have splitted my fusion apps into two host
** one host for IDM (idmhost) and its related database instance
** one host for FusionApps (fahost) and its related database instance
Like this, I can clone my VM before provisionning an Applications Environment and create templates to install the Fusion Apps module i’m interested in :
* Fusion Accounting Hub : http://www.oracle.com/us/products/applications/fusion/financial-management/accounting-hub/overview/index.html
* Fusion Distributed Order Orchestration : http://www.oracle.com/us/products/applications/fusion/supply-chain-management/distributed-order-orchestration/overview/index.html

Day2: Setting up an Oracle VM Server to handle the Fusion Apps installation
I have 4TB (4x 1Tb) of disk to handle all my VM and backups. I order to save times, for each success full steps in Fusion Apps installation (which can takes few hours (+4h)), i always take a clone of my VM in order to revert back the modifications done by Fusion Installer. It is very helpful when errors happened due to some misconfiguration, missing libraries, to revert back to a previous state.

For better scalability and if you want to move your Oracle DB instance out of IDMhost/FAHost, you can use host file to specify idmdbhost and fadbhost as below:

192.168.2.200  idmhost.home.fr idmhost
192.168.2.201 fahost.home.fr fahost

Make sure that your two node can communicate, and de-activate the firewall service as a root user with

service iptables stop

Day3: idmhost.home.fr: Setting up Identity and Access Management Node and its database related instance
* All theses steps went fine without any errors
* Step1 : Install Fusion Applications Provisioning Framework : TODO
* Step2 : Install Identity management Database Oracle 11g : TODO
* Step3 : Run Repository Creation Utility for Oracle Identity Management components : TODO
* Step4 : Install Identity Management Provisioning Wizard : TODO
* Step5 : Create IDM provisioning Response File : TODO
* Step6 : Provision Identity Management (~5 hours): the installations logs file can be found here : TODO
** IDMProvisioning Installation Log File location : /app/oracle/config/provisioning/logs/idmhost.home.fr
** runIDMProvisioning.sh Phase 1 : preverify : elapsed time: Total time: 30 seconds
** runIDMProvisioning.sh Phase 2 : install : elapsed time: Total time: 138 minutes 28 seconds
** runIDMProvisioning.sh Phase 3 : preconfigure : elapsed time: Total time: 43 minutes 5 seconds
** runIDMProvisioning.sh Phase 4 : configure : elapsed time: Total time: 18 minutes 43 seconds
** runIDMProvisioning.sh Phase 5 : configure-secondary : elapsed time: Total time: 3 minutes 51 seconds
** runIDMProvisioning.sh Phase 6 : postconfigure : elapsed time: Total time: 26 minutes 50 seconds
** runIDMProvisioning.sh Phase 7 : startup : elapsed time: Total time: 21 minutes 16 seconds
** runIDMProvisioning.sh Phase 8 : validate : elapsed time: Total time: 1 minute 24 seconds
* Step7 : Take a clone of this host for future re-use : TODO

Day4: fahost.home.fr : Setting up an Fusion Apps Node its database related instance
* Step1 : Install Fusion Applications Provisioning Framework : TODO
* Step2 : Install Fusion Apps Database Oracle 11g : TODO
* Step3 : Run Repository Creation Utility for Fusion Apps : TODO
* Step4 : Fusion Applications Provisioning – Module FAH – Install Fusion Accounting Hub : TODO
** Physical Architecture : 5 Admin Servers, 12 Application Managed Servers, 14 Middleware Managed Server
** IDMProvisioning Installation Log File location : /app/oracle/logs/provisioning/plan1387961116212/fahost.home.fr/
** runProvisioning.sh Phase 1 – Prerequisite Check : preverify (warning about RAM): elapsed time: Total time: 5 minutes 52 seconds
** runProvisioning.sh Phase 2 – Installation : install (no errors with ZRAM): elapsed time: Total time: 127 minutes 59 seconds
** runProvisioning.sh Phase 3 – Preconfigure : preconfigure (with ZRAM): elapsed time: Total time: 4 hours to solve all issues encountered (TODO)
** runProvisioning.sh Phase 4 – Configure : configure : elapsed time: Total time: 2 days to solve all issues encountered (TODO)
**** Parallel Builds: Functional setup, Business Intelligence, Financials, Human Capital Management, Customer RelationShip Management
**** Missing files ; unzip JAR file; update host file, redo operation multiple time …
**** Check log file : /app/oracle/logs/provisioning/plan1387961116212/fahost.home.fr/techpatch_x.log
** runProvisioning.sh Phase 5 – Configure Primary / Secondary : configure-secondary (no errors): elapsed time: Total time: Total time: 22 minutes 5 seconds
** runProvisioning.sh Phase 6 – Post Configure : postconfigure : elapsed time:
** runProvisioning.sh Phase 7 – Startup : startup : elapsed time:
** runProvisioning.sh Phase 8 – Validation : validate : elapsed time:

* Step4bis : Take a clone of this host for future re-use : TODO
* Step5 : Create Fusion Applications Response File : TODO

Day5: Provisionning an Applications Environment & Administration scripts
* Step1 : Startup/Shutdown script for IDM components : TODO
* Step2 : Provision an Applications Environment : TODO
* Step3 : Startup/Shutdown script for Fusion Apps components : TODO

I will provided the links, the estimated time for each steps and logs files of my installation once the final installation process will end up.

Update 26/01/2014:
I finally finished the installation of Fusion Apps with all modules on my labs environment.
Please refer to : Fusion Application 11.1.1.7 Installation : Provisionning time for all fusion module
to get rough estimate of provisionning time.