Installation steps to install Oracle Fusion Applications (To host IDM)

The process of installing Oracle Fusion Applications can broadly be classified as follows:

1. Download and stage the Oracle Fusion Applications software and install provisioning framework

2. Install a transaction database.

3. Install and configure SOA, Oracle Identity Management components.

4. Create a provisioning plan for the new environment

5. Provision a new environment

6. Complete required post-installation tasks

Staging & Environment

Oracle Fusion Applications is supported on the following platforms:

• Linux x86-64 (64 bit)

• Oracle Solaris SPARC (64 bit)

• Oracle Solaris x86-64 (64 bit)

• IBM AIX on POWER Systems (64 bit)

• Microsoft Windows x64 (64 bit)

I will be using Oracle Enterprise Linux 5 Update 6 x86_64 as OS

Download the installation files “Oracle Fusion Applications 11g Media Pack for Linux x86-64 Release 11.1.1.5.0”

Unzip the downloaded the files to a stage directory.

It will look like this:

[root@vinod fusion_installers]# pwd

/stage/fusion_installers

[root@vinod fusion_installers]# ls

apps_rcu  idm  jdk soa      weblogic

database  jdev oam wc webtier

fmw_rcu       jdev_extensions      webgate   webtier_patchset

OS     :  Oracle Enterprise Linux x86_64

Host :  vinod.ibizsoft.com 192.168.***.***

Fusion Applications: Installing Oracle Database 11g for Oracle Identity Management

As a prerequisite for Oracle Fusion Applications, Oracle Identitiy Management needs to be installed and configured.Oracle Identity Management is the equivalent of LDAP, except Oracle uses a database  to store its user management.

Now I will install Oracle Database 11.2.0.2 on Oracle Enterprise Linux.

We first have to stage the installation software of Oracle Database 11.2.0.2.

After you copy and unpack the installation files you end up with two directories, Disk1 and patch.

Directory Disk1 contains the installation files for Oracle Database 11.2.0.2. Directory patch contains patches for Oracle Database 11g that are needed for the Oracle Fusion Applications database. It is not mandory to install these patches for IDM. We will install these patches as well, what is needed for Oracle Fusion Applications database, cannot be bad to also use for the IDM database. At least we will end up with two databases (IDM, FAPP) that are at the same patch level.

Pre-Req’s

? Make sure that all these packages are installed.

? Modify the SHMMAX parameter

[root@vinod doc]# cat /etc/sysctl.conf |grep shmmax

kernel.shmmax = 68719476736

? Modify the openfile limit

[root@vinod Downloads]# /usr/sbin/lsof | wc -l

4704

[root@vinod Downloads]# ulimit -n

1024

[root@vinod Downloads]# vi /etc/security/limits.conf

[root@vinod Downloads]# cat /etc/security/limits.conf

* soft nofile 4096

* hard nofile 4096

[root@vinod Downloads]# init 6

[root@vinod ~]# ulimit -n

4096

[root@vinod ~]#

? Enable Unicode support in OS

[root@vinod ~]# echo $LANG

en_US.UTF-8

[root@vinod ~]#

? Set all required kernel parameters

[root@vinod etc]# cat sysctl.conf

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 2

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmmax = 68719476736

kernel.shmall = 4294967296

fs.suid_dumpable = 1

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default=4194304

net.core.rmem_max=4194304

net.core.wmem_default=262144

net.core.wmem_max=1048586

[root@vinod etc]#

[root@vinod etc]# /sbin/sysctl -p

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 2

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmmax = 68719476736

kernel.shmall = 4294967296

fs.suid_dumpable = 1

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

[root@vinod etc]#

[root@vinod etc]# vi /etc/security/limits.conf

[root@vinod etc]# cat /etc/security/limits.conf

* soft nofile 4096

* hard nofile 4096

oracle   soft    nproc   2047

oracle   hard    nproc   16384

oracle    soft    nofile  4096

oracle   hard    nofile  65536

oracle   soft    stack   10240

[root@vinod etc]#

? Create Users,Groups, Set permissions and Environment

Log in as root and issue the following commands

[root@vinod /]# groupadd dba

[root@vinod /]# groupadd oinstall

[root@vinod /]# useradd -g oinstall -G dba oracle

[root@vinod /]# mkdir -p /u01/app/oracle

[root@vinod /]# chown -R oracle:oinstall /u01

[root@vinod /]# chmod -R 775 /u01

[root@vinod /]# passwd oracle

Changing password for user oracle.

New UNIX password:

BAD PASSWORD: it is based on a dictionary word

Retype new UNIX password:

passwd: all authentication tokens updated successfully.

[root@vinod /]#

After this edit the .bash_profile for the oracle user

su – oracle

[oracle@vinod ~]$ cat .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

# Oracle Settings

ORACLE_HOSTNAME=vinod.ibizsoft.com; export ORACLE_HOSTNAME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0.2/db_1; export ORACLE_HOME

ORACLE_SID=FIDM; export ORACLE_SID

ORACLE_TERM=xterm; export ORACLE_TERM

PATH=/usr/sbin:$PATH; export PATH

PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Opatch:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

$ . .bash_profile

? Now we are ready to start the installer. Log in as user oracle and start the installer by starting a terminal session and issue  ./runInstaller

[root@vinod ~]# su – oracle

[oracle@vinod ~]$ cd /stage/fusion_installers/database/Disk1/

[oracle@vinod Disk1]$ ls

doc      readme.html  rpm           sshsetup  welcome.html

install  response     runInstaller  stage

[oracle@vinod Disk1]$ ./runInstaller

Starting Oracle Universal Installer…

Checking Temp space: must be greater than 120 MB.   Actual 115989 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 8189 MB    Passed

Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-08-28_12-38-24PM. Please wait …

[oracle@vinod Disk1]$

 

 

 

 

 

 

Now we have successfully created our database for IDM.

Once Linux and the database are up and running, we need to change some oracle initialization parameters.

Start sqlplus as SYSDBA and issue the following commands in a terminal session.

SQL> alter system set session_cached_cursors=100 scope=spfile;

System altered.

SQL> alter system set aq_tm_processes=1 scope=spfile;

System altered.

SQL> alter system set dml_locks=200 scope=spfile;

System altered.

SQL> alter system set job_queue_processes=10 scope=spfile;

System altered.

SQL> alter system set open_cursors=800 scope=spfile;

System altered.

SQL> alter system set session_max_open_files=50 scope=spfile;

System altered.

SQL> alter system set sessions=500 scope=spfile;

System altered.

SQL> alter system set processes=500 scope=spfile;

System altered.

SQL> alter system set sga_target=512M scope=spfile;

System altered.

SQL> alter system set sga_max_size=800M scope=spfile;

System altered.

SQL> alter system set pga_aggregate_target=100M scope=spfile;

System altered.

Bounce the database.

SQL> shut immediate;

SQL> startup

ORACLE instance started.

Total System Global Area  985481216 bytes

Fixed Size                  2232408 bytes

Variable Size             335548328 bytes

Database Buffers          641728512 bytes

Redo Buffers                5971968 bytes

Database mounted.

Database opened.

SQL> select * from v$version;

BANNER

——————————————————————————–

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production

PL/SQL Release 11.2.0.2.0 – Production

CORE    11.2.0.2.0      Production

TNS for Linux: Version 11.2.0.2.0 – Production

NLSRTL Version 11.2.0.2.0 – Production

? Patching theDatabase.

The database installation files that come with Oracle Fusion Applications software are pre-delivered with some patches.

The following patches are pre-delivered.

[oracle@vinod patch]$ pwd

/stage/fusion_installers/database/patch

[oracle@vinod patch]$ ls

10077191  10220058  10238786  10269193  10419629  11742094  11883804  12329775  12579349  12635488  8223165  9729764  9885553  10142788  10232083  10259620  10412247  11689869  11786272  11930680  12544032  12609146  12686274  9401552  9776940

[oracle@vinod patch]$

To install patches the database should not be running. So shutdown the database now.

Check the pre-patch and post-patch instructions carefully and follow them.

Do this for all the patches.

To install a patch go to the directory with the patch number. On the patch root directory issue the  command  ‘opatch apply’.

Once the Patching is complete, we are done with DB creation part for IDM.

We will continue with running the Repository Creation Utility to create necessary schemas for SOA and IDM.