ORATraining Blog

Oracle Fusion Applications Installation: Running Fusion Applications Repository Creation Utility (Apps RCU)

Previous: Installing Oracle 11g Database (Applications Transactional Database)

Create a directory on physical partition and call it APPS_RCU_HOME

[oracle@fusion linux]$ mkdir /app/fusion/provisioning/apps_rcu

 

Go to repository_location/installers/apps_rcu and locate the rcuHome_fusionapps_dbinstall.zip file. This file was staged when you created the installer repository.

 

Extract the contents of rcuHome_fusionapps_dbinstall.zip to a directory (APPS_RCU_HOME) on the database server. All dependent components that Applications RCU needs are included in this zipped file.

 

[oracle@fusion apps_rcu]$ cd /app/fusion/provisioning/apps_rcu

[oracle@fusion apps_rcu]$ unzip /mnt/fusion/installers/apps_rcu/linux/rcuHome_fusionapps_linux.zip

 

Create a temporary directory on the database server. Make a note of the location.

You will need to enter this location when you specify a value for FUSIONAPPS_DBINSTALL_DP_DIR

 

[oracle@fusion apps_rcu]$ mkdir /app/fusion/provisioning/apps_rcu/dp_dir

 

Locate and copy APPS_RCU_HOME/rcu/integration/fusionapps/export_

fusionapps_dbinstall.zip to the directory you specified for FUSIONAPPS_

DBINSTALL_DP_DIR.

 

Unzip export_fusionapps_dbinstall.zip to FUSIONAPPS_DBINSTALL_DP_DIR.

 

[oracle@fusion dp_dir]$ cd /app/fusion/provisioning/apps_rcu/dp_dir

[oracle@fusion dp_dir]$ unzip /app/fusion/provisioning/apps_rcu/rcu/integration/fusionapps/export_fusionapps_dbinstall.zip

 

Go to APPS_RCU_HOME/rcu/integration/biapps/schema and locate the

otbi.dmp file.

Copy otbi.dmp to FUSIONAPPS_DBINSTALL_DP_DIR (where you unzipped the

contents of export_fusionapps_dbinstall.zip).

 

[oracle@fusion dp_dir]$ cp -p ../rcu/integration/biapps/schema/otbi.dmp /app/fusion/provisioning/apps_rcu/dp_dir/

 

Launch Repository Creation Utility (RCU)

 

[oracle@fusion bin]$ cd /app/fusion/provisioning/apps_rcu/bin

[oracle@fusion bin]$ ./rcu

Click Next

Click Next

Enter same details as entered while creating the database in previous step. Click Next

This screen will check pre-requisites. Click Ok once successful.

Select all components in this Window.

It will look as above when you collapse all parent values. Click Next

 

Important Note: If you had reduced SGA and PGA size after DB installation then this prerequisites check may fail with following error.

RCU-6083:Failed – Check prerequisites requirement for selected component:FUSIONAPPS

RCU-6107:DB Init Param Prerequisite failure for: pga_aggregate_target

Current Value is 2147483648. It should be greater than or equal to 4294967296.

RCU-6107:DB Init Param Prerequisite failure for: sga_target

Current Value is 2147483648. It should be greater than or equal to 9663676416.

 

To fix this issue, we need to modify the minimum requirement of SGA and PGA in installer pre-requisite config file located at /app/fusion/provisioning/apps_rcu/rcu/integration/fusionapps/fusionapps.xml

 

Change these values as follows.

<DBPrerequisite COMPARE_OPERATOR=”GE” DATA_TYPE=”NUMBER” PREREQ_TYPE=”InitParameter”>

<ValidIf DBTYPE=”ORACLE”/>

<PrereqIdentifier>sga_target</PrereqIdentifier>

<PrereqValue>2147483648</PrereqValue>

</DBPrerequisite>

…

<DBPrerequisite COMPARE_OPERATOR=”GE” DATA_TYPE=”NUMBER” PREREQ_TYPE=”InitParameter”>

<ValidIf DBTYPE=”ORACLE”/>

<PrereqIdentifier>pga_aggregate_target</PrereqIdentifier>

<PrereqValue>2147483648</PrereqValue>

</DBPrerequisite>

 

The prerequisites check should finish successfully. Click Ok

 

Enter same password for keeping it simplefor now. Click Next

 

Open another terminal window. Create following directories for custom environment variables.

[oracle@fusion database]$ mkdir /app/fusion/database/applcp

[oracle@fusion database]$ mkdir /app/fusion/database/appllog

[oracle@fusion database]$ mkdir /app/fusion/database/keyflexcombfilter

[oracle@fusion database]$ mkdir /app/fusion/database/obieebkp

 

Specify these following values in the same screen under Fusion Applications Component (expect first value which is the temporary DP directory created before /app/fusion/provisioning/apps_rcu/dp_dir)

 

Supervisor Password: You must enter the same password you set up as ODI SUPERVISOR in Applications RCU. Since we kept all passwords as oracle123, nothing much to remember. Enter the same password.

Work Repository Password: Default = None. You must enter the same password set up as ODI SUPERVISOR in Applications RCU.

Oracle Transactional BI

Directory on the database server where Oracle Transactional Business Intelligence import and export files are stored. Enter /app/fusion/provisioning/apps_rcu/dp_dir again.

Change nothing in this page. Click Next

 

Click OK

 

 

Now it will create the required tablespaces. Click OK

Once Tablespaces are created, next Summary screen will appear for creating the required Schemas. Click Create

It may take a couple of hours or even more based on the available memory and CPU for the VM and host machine.

 

 

 

Once finished, a completion summary screen will appear. It will show details for each components and completion states. Click Close

Next: Running Repository Creation Utility (RCU) for Oracle Identity Management components

Installing Oracle Fusion Applications – steps

1. Installing Fusion Applications Provisioning Framework
   
2. Installing Oracle 11g Database (Applications Transactional Database)
   
3. Running Oracle Fusion Applications Repository Creation Utility (Applications RCU)
   
4. Creating another database for Oracle  Identity Management Infrastructure (optional)
   
5. Running Repository Creation Utility (RCU) for Oracle Identity Management components
6. Installing Oracle Identity and Access Management Components
   
7. Configuring Oracle Identity and Access Management components
   
8. Preparing Identity and Policy Stores
   
9. Creating a New Provisioning Plan
   
10. Provisioning an Applications Environment

Oracle Fusion Applications Installation: Installing Transactional Database

Previous: Installing Fusion Applications Provisioning Framework

To install Applications Transactional Database we need to run Oracle Fusion Applications Provisioning Wizard from <framework_location>/provisioning/bin

<framework_location> is same what we mentioned in previous post. i.e. /app/fusion

[oracle@fusion $ cd /app/fusion/provisioning/bin

We need to temporarily set JAVA_HOME to jdk6 directory shipped with the installation media

[oracle@fusion bin]$ export JAVA_HOME=/mnt/fusion/jdk6

[oracle@fusion bin]$ ./provisioningWizard.sh

Click Next

Click Next

Deselect security updates notification. Click Next

Provide database listener port (default is 1521, if you change this port please note to enter the new port in future screens where we have mentioned 1521)

Installer directory location will be the same as you created the stage setup or provisioning repository.

Provide a location for Oracle Base. Press TAB, next values should automatically be populated, if not, go back and click next again.

Enter dba as OSDBA group.

We have specified “fusiondb” as our database name. please note that if you are using any other name then don’t forget to change it in further screens whenever we have mentioned fusiondb.

You can keep simple password like “oracle” also but try to keep something like “oracle123” for all passwords so that it will follow requirements for all further passwords and it will be easier for you to remember all passwords in further installations.

Next it will finish the pre-requisite checks. Click Next

On next page, you can Save the summary. Click Install to start the installation.

Note: This will install the software as well as create a database named “fusiondb” which we provided earlier.

At this point it will prompt for running root.sh as root user.

 

Do not press Ok until run the following as root user in separate terminal window. Once following is executed, press Ok to continue.

 

[root@fusion ~]# /app/fusion/database/product/11.2.0/dbhome_1/root.sh

Check /app/fusion/database/product/11.2.0/dbhome_1/install/root_fusion_2012-01-1 5_12-29-28.log for the output of root script

[root@fusion ~]# tail -f /app/fusion/database/product/11.2.0/dbhome_1/install/root_fusion_2012-01-15_12-29-28.log

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /app/fusion/database/product/11.2.0/dbhome_1

 

Creating /etc/oratab file…

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

 

It may take a few hours (at least on a non-high end host machine) and then installation will finish.

Important Note: After installation is finished we reduced the SGA and PGA (from 10GB to 2GB). We are doing this since we are running on a VM and have allocated total 2.5 or 3 GB RAM only. This is not recommended for production installation but since this is only a demo/development installation, you can safely do this. If you wish to keep it 10GB you can do it but this will increase the swap usage exponentially.

Since we are reducing the size of SGA and PGA, next step (RCU) may fail in pre-requisite check. So we will need to change the pre-req check xml file to look for lower value. We will explain this in next post.

Next:  Running Oracle Fusion Applications Repository Creation Utility (Applications RCU)

Installing Oracle Fusion Applications – steps

1. Installing Fusion Applications Provisioning Framework
   
2. Installing Oracle 11g Database (Applications Transactional Database)
   
3. Running Oracle Fusion Applications Repository Creation Utility (Applications RCU)
   
4. Creating another database for Oracle  Identity Management Infrastructure (optional)
   
5. Running Repository Creation Utility (RCU) for Oracle Identity Management components
6. Installing Oracle Identity and Access Management Components
   
7. Configuring Oracle Identity and Access Management components
   
8. Preparing Identity and Policy Stores
   
9. Creating a New Provisioning Plan
   
10. Provisioning an Applications Environment

Installing Fusion Applications Provisioning Framework

Previous: Creating Oracle VirtualBox Virtual Machine with Oracle Linux

Start the installer from <repository_location>/installers/faprov/Disk1 directory

[oracle@fusion]$ cd /mnt/fusion/installers/faprov/Disk1

[oracle@fusion Disk1]$ ./runInstaller

Starting Oracle Universal Installer…

…

 

This screen will prompt for inventory location for all Oracle products. Keep values as above. Click Ok

 

A message will pop-up asking to run /home/oracle/oraInventory/createCenterInventory.sh

Run the same in another terminal window. Once complete, press Ok

Above is output for createCenterInventory.sh execution as root user.

 

Click Next

Make sure all Prerequisite Checks complete successfully. Click Next once successful.

 

Meanwhile in another terminal window create a directory named /app and assign it to “oracle” user.

[root@fusion ~]# mkdir /app

[root@fusion ~]# chown oracle:dba /app/

Enter /app/fusion as base location for installing Provisioning Framework.

Next it will show Installation Summary screen. You can save the summary for future reference. Click Install.

Installation will finish in a few minutes. Click Next

Last screen will show installation completion screen with summary. Click Finish

Next: Installing Oracle 11g Database (Applications Transactional Database)

Installing Oracle Fusion Applications – steps

1. Installing Fusion Applications Provisioning Framework
   
2. Installing Oracle 11g Database (Applications Transactional Database)
   
3. Running Oracle Fusion Applications Repository Creation Utility (Applications RCU)
   
4. Creating another database for Oracle  Identity Management Infrastructure (optional)
   
5. Running Repository Creation Utility (RCU) for Oracle Identity Management components
6. Installing Oracle Identity and Access Management Components
   
7. Configuring Oracle Identity and Access Management components
   
8. Preparing Identity and Policy Stores
   
9. Creating a New Provisioning Plan
   
10. Provisioning an Applications Environment

Previous: Oracle Fusion Applications Installation – Steps

Creating Oracle VirtualBox Virtual Machine with Oracle Linux

Before we begin first download the required software.

1. Download and install Oracle VirtualBox Software from https://www.virtualbox.org/wiki/Downloads
2. Download Oracle Linux from http://edelivery.oracle.com/linux

Select “Oracle Linux” and “x86 64 bit“. Click Go

 

Download Oracle Linux Release 5 Update 7

 

If you are installing on your Windows machine then download the software for Windows.

Important Note: We are using Linux 5 because somehow Oracle Linux 6 (update 2) is not working with VirtualBox for us as it was not able to launch GUI mode. The whole installation was going in text mode and later also it was not able to shift to GUI mode. The error is as follows.

 

Click on New

Click Next

Provide any name for this VM and select Linux/Oracle (64 bit) for the OS Type. Click Next

In Memory screen, select at least 2 GB memory. I have selected 2.5 GB (2560 MB). Click Next.

Select “Startup Disk” and “Create new hard disk“. Click Next

Since we want our VM Disks to be compatible with VMWare as well, we will use VMDK file type.

Next screen we will select “Dynamically allocated” storage. This will allow us to keep the VM disk size according to the actual usage. Click Next

Note: This of course makes VM a bit slower initially during the installation (compared to Fixed size) since in this case the VM needs to keep on increasing the disk size as we move with the installation. So we have to choose between the trade-offs.

Provide a location with at least 300 GB available space. Select size as 300 GB. Click Next

On Summary screen click on “Create” to create the Virtual Disk.

On next Summary screen click on “Create” to create the Virtual Machine.

Click on Settings

Click on Network. Select “Host-only Adapter“. We will explain this later while assigning IP in Linux. Click OK

Make sure to have Operating System CD (Here Oracle Linux 5) in the CD drive. Click on Start

Note: You can optionally use Virtual CD drive software (for example Daemon tools-lite) to mount an ISO image to a virtual CD.

Click Next

Select the drive / virtual drive containing OS installation CD/DVD. Click Next

Click on Start to begin installation of Linux

In the next section we will coner Installing Linux on Physical or Virtual Machine (VMWare or VirtualBox) .

Note: This is a generic guide which can be used for installation on Physical or Virtual machine.

 

Installing Linux Operating System

Press Enter to continue with Graphical mode installation

At this moment we can ignore this message if it appears since graphics is already available. Once we install Virtualbox Guest Additions (Explained later)

Use TAB to select between options. Select “Skip” and press Enter

 

Click Next

Keep default “English (English)” Click Next

Keep default “US English” Click Next

Since our disk is blank and not yet formatted to Linux File System, click “Yes” to erase all data.

Select “Remove all partitions on selected drive and create default layout” and click Next

Manually assign host name. We are using “fusion” as our hostname. We will assign IP later.

Important note: We will use the hostname “fusion” throughout this installation. If you are planning to change the host name then make sure that you enter the new name everywhere during the installation wherever we have mentioned “fusion”

Select Customize now and click Next

Make sure to include following while selecting.

Now select Base System from the left pane and check System Tools from the right pane. Click on Optional packages. In the list of packages select oracle-validated package. This package will create a Linux user oracle and will create necessary Linux groups. This package will also set Linux kernel parameters needed for Oracle installations.

Click Next to finish the installation and reboot the OS.

After first boot, above welcome screen appears. Click Forward

Select Yes and click Forward

Select Disabled and click Forward

Select Disabled in this screen and click Forward.

Please note that if this is kept Enforcing then at one point the installation will fail to start the services.

Click Forward

Select correct date and time and click Forward

We can skip this page since we will create users later if required. Just click Forward

Click Forward

Click Finish. On the login screen, login as root

Now let us check what is the IP range for our VM network. Open command prompt on your host windows OS.

C:\>ipconfig

Windows IP Configuration

Ethernet adapter VirtualBox Host-Only Network:

Connection-specific DNS Suffix . :

IP Address. . . . . . . . . . . . : 192.168.56.1

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . :

In the ipconfig output look for VirtualBox Host-Only Network. We can see that the IP address is 192.168.56.1. This is our gateway for VM. Since the Subnet mask is 255.255.255.0, we can change the last octet and assign any IP in that range for our VM. Let us select 192.168.56.101 as our VM IP.

 

Click on System->Administration->Network

 

Click on Edit.

 

Enter manual IP address as follows.

IP: 192.168.56.101

Subnet mask: 255.255.255.0

Gateway: 192.168.56.1

Click on File->Save and click Activate. Now on shell prompt run following command as root to restart network services.

service network restart

Make an entry for this IP for the host in /etc/hosts file. Also comment out IPv6 entry (localhost6). Also create an additional alias fusion.localdomain (we will use this later)

[root@fusion ~]# cat /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1       localhost.localdomain localhost

#::1            localhost6.localdomain6 localhost6

192.168.56.101  fusion fusion.localdomain

Now we must install Guest Additions to smoothly use the VM along with the host windows. We can have higher resolution and also easier mouse movements between VM and host Windows after this.

Click Devices-> Install Guest Additions in the VirtualBox menu. This will automatically mount a CD on the VM CD drive.

Then run following commands. Make sure you are logged in as root

cd /media/VBOXADDITIONS_4.1.8_75467

./VBoxLinuxAdditions.run

This will install the Guest Additions. Reboot the VM. Now we can change the resolution to higher value.

Click on System -> Preferences -> Screen Resolution

Change the resolution to 1024×768. Click Apply. On next reboot the system will show higher resolution.

Now we will mount the already created Stage directory/Provisioning Repository in the Linux VM.

In the VirtualBox window, click on Settings

 

Click on Shared Folders -> Add shared folder

Browse for the directory where we staged the installation files. We will mount it as “Read-only” because we do not want to make any changes in the source folder.

It will look as above. Click OK

 

Now we will mount it in the VM. Login as root and run following commands.

[root@fusion ~]# mkdir /mnt/fusion

[root@fusion ~]# chown oracle:dba /mnt/fusion/

[root@fusion ~]# mount -t vboxsf FusionStage /mnt/fusion/

[root@fusion ~]# ls -l /mnt/fusion/

drwxrwxrwx 1 root root 0 Sep 7 08:02 appspatches

drwxrwxrwx 1 root root 0 Jan 8 15:35 installers

drwxrwxrwx 1 root root 0 Sep 7 02:28 jdk6

 

Please note that since the installation involves graphical interface, you can either run it directly by opening a terminal window from the Virtual Machine GUI or we can use putty on windows to connect to the virtual machine. When you use putty from windows then you must use tools like XManager to view output on host.

Also please make sure that sufficient swap memory is available by using “free –m” command. It least double the amount of RAM should be available as swap space. If not manually add swap files.

 

For example, adding 4 GB swap space.

[root@fusion fusiondb]# dd if=/dev/zero of=/swapfile1 bs=1024 count=4194304

4194304+0 records in

4194304+0 records out

4294967296 bytes (4.3 GB) copied, 112.697 seconds, 38.1 MB/s

[root@fusion fusiondb]# mkswap /swapfile1

Setting up swapspace version 1, size = 4294963 kB

[root@fusion fusiondb]# swapon /swapfile1

[root@fusion fusiondb]# free -m

total       used       free     shared    buffers     cached

Mem:          2506       2386        119          0          9       1871

-/+ buffers/cache:        505       2000

Swap:         5605        152       5452

 

Next: Installing Fusion Applications Provisioning Framework

Installing Oracle Fusion Applications – steps

1. Installing Fusion Applications Provisioning Framework
   
2. Installing Oracle 11g Database (Applications Transactional Database)
   
3. Running Oracle Fusion Applications Repository Creation Utility (Applications RCU)
   
4. Creating another database for Oracle  Identity Management Infrastructure (optional)
   
5. Running Repository Creation Utility (RCU) for Oracle Identity Management components
6. Installing Oracle Identity and Access Management Components
   
7. Configuring Oracle Identity and Access Management components
   
8. Preparing Identity and Policy Stores
   
9. Creating a New Provisioning Plan
   
10. Provisioning an Applications Environment

Oracle Fusion Applications installation – Step by step guide

Fusion Applications 11.1.1.5.1 installation is not straightforward unlike E-Business Suite 11i/R12 installation. So we need to divide the installation into following main steps. Please note that we have changed the default order since we are going to host both RCU in one database which is fine since both have different schemas. This will save us a lot of Memory for the VM. Please note that we will be performing single node installation so all components will be installed on single node.

Preparing for Oracle Fusion Applications installation

1. Downloading Oracle Fusion Applications media
   
2. Creating Oracle VirtualBox Virtual Machine with Oracle Linux
   

   OR
   

   Installing Oracle Linux 5 (Update 7) on a Physical machine
   

3. Staging/Creating Oracle Fusion Applications provisioning repository
   

Installing Oracle Fusion Applications – steps

1. Installing Fusion Applications Provisioning Framework
   
2. Installing Oracle 11g Database (Applications Transactional Database)
   
3. Running Oracle Fusion Applications Repository Creation Utility (Applications RCU)
   
4. Creating another database for Oracle  Identity Management Infrastructure (optional)
   
5. Running Repository Creation Utility (RCU) for Oracle Identity Management components
6. Installing Oracle Identity and Access Management Components
   
7. Configuring Oracle Identity and Access Management components
   
8. Preparing Identity and Policy Stores
   
9. Creating a New Provisioning Plan
   
10. Provisioning an Applications Environment

We are going to install Fusion Applications 11.1.1.5.1 for Linux x86-64 Operating system.

So we will download the installation media for Oracle Fusion Applications 11.1.1.5.1 for Linux x86-64 from http://edelivery.oracle.com

Login first to access following screen.

Select “Oracle Fusion Applications” and “Linux x86-64” from the list. Click Go

Download the first 13 media files. We will not need rest of the media for this installation.

Unzip all these files into one Stage directory.

Important Note: Since some of the files have very long directory path (very close to 255 characters), please unzip these files into <Drive>:\stage folder only to keep short name. At least 2 files have very long path so let us try to avoid this.

At the end of this exercise you will have following directory structure.

We will mount this directory in Linux later.

Next, we must have Linux x86-64 OS installed either on physical or a virtual machine. We will use Oracle (Sun) VirtualBox to host our virtual machine and Oracle Linux 5 (update 7) as base operating system. In short we will use Oracle products only during this installation.

Note: We can also use VMWare to host the Virtual Machine. We will post another guide on setting up VMWare virtual machine. But the good thing is that the virtual machine/disks which we create in VirtualBox, same we can use in VMWare as well since we will create .vmdk format disks. This will add flexibility for you to use it anywhere later.

Next: Creating Oracle VirtualBox Virtual Machine with Oracle Linux