Skip to main content

Oracle Apps R12.1.1 Multi Node Installation on Linux

This article demonstrate step by step procedure to install oracle Applications R12.1.1 on multiple Nodes.

This article will be helpful for the beginners who want to learn how to Install and configure oracle E-business suite R12.1.1 on multiple nodes using Linux OS platform on their personal computers/laptops and also for those who want to deploy it in Business Enterprise server environment.

Multi Node Installation:

Oracle E-Business suite is a robust software which provide a very good scalability. You can configure multiple nodes for Installation of E-Business Suite hosting different Services on different Hosts.

Such configuration are mainly deploy to balance load and availability.

Steps:

1) prepare all OS ore-requisites
2) prepare stage area
3) Install E-business Suite R12.1.1 Software.


Hosts information for Installation:





Perform all operating system per-requisites on all nodes:




ERPDB1

[root@erpdb1 ~]# groupadd dbaerp
[root@erpdb1 ~]# useradd -g dbaerp oramgr

[root@erpdb1 ~]# passwd oramgr
Changing password for user oramgr.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.

[root@erpdb1 ~]# mkdir /u01/oraR12
[root@erpdb1 ~]# chmod -R 775 /u01/oraR12
[root@erpdb1 ~]# chown -R oramgr:dbaerp /u01/oraR12/


ERPAPPL1:

[root@erpappl1 ~]# groupadd dbaerp
[root@erpappl1 ~]# useradd -g dbaerp applerp
[root@erpappl1 ~]# passwd applerp
Changing password for user applmgr.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.

[root@erpappl1 ~]# chmod -R 775 /u01/applR12/
[root@erpappl1 ~]# chown -R applmgr:dbaerp /u01/applR12/


ERPAPPL2:

[root@erpapl2 ~]# groupadd dbaerp
[root@erpapl2 ~]# useradd -g dbaerp applerp
[root@erpapl2 ~]# passwd applerp
Changing password for user applmgr.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.

[root@erpapl2 ~]# chmod -R 775 /u01/applR12/
[root@erpapl2 ~]# chown -R applmgr:dbaerp /u01/applR12/



>> configure kernel parameters (Edit /etc/sysctl.conf file)


These kernel parameters should be configured on all hosts ERPDB1, ERPAPPL1, ERPAPPL2.



#All below kernel parameters are related to oracle E-biz
#################
kernel.shmall = 268435456
kernel.shmmax = 429496729
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
fs.file-max = 327679
net.ipv4.ip_local_port_range = 10000 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 4194304
:wq


[root@oraerp1]# vi /etc/security/limits.conf
* hard nofile 65536
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047
:wq




>> verify configured kernel parameters on all HOSTS:




[root@oraerp1 ~]# 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 = 4294967295
kernel.shmall = 268435456
kernel.shmmax = 429496729
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
fs.file-max = 327679
net.ipv4.ip_local_port_range = 10000 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 4194304
[root@oraerp1 ~]#




>> Make sure all below rpm's are Installed on all
Host OS:


If you're using Liux 5.6 installed with all default packages the only listed below rpm's are required.




unixODBC-2.2.11-7.1.i386.rpm
unixODBC-devel-2.2.11-7.1.i386.rpm
libXp-1.0.0-8.1.el5.i386.rpm
libXp-devel-1.0.0-8.1.el5.i386.rpm
openmotif22-2.2.3-18.i386.rpm
libaio-devel-0.3.106-5.i386.rpm
sysstat-7.0.2-3.el5_5.1.i386.rpm



If using any prior release of LInux the make sure all rpms below exists:



compat-glibc-2.3.4-2.26
compat-glibc-headers-2.3.4-2.26
gcc-4.1.2-14.el5
gcc-c++-4.1.2-14.el5
glibc-2.5-123
glibc-common-2.5-123
glibc-devel-2.5-12
glibc-headers-2.5-12
kernel-headers-2.6.18-128.el5
libgcc-4.1.2-14.el53
libstdc++-devel-4.1.2-14.el5
libstdc++-4.1.2-14.el53
make-3.81-1.13
gdbm-1.8.0-26.2.13
libXp-1.0.0-8.1.el5
libaio-0.3.106-3.23
libgomp-4.1.2-14.el5
sysstat-7.0.0-3.el5
compat-libstdc++-296-2.96-138
compat-libstdc++-33-3.2.3-61

elfutils-libelf-devel-0.125
elfutils-libelf-devel-static-0.125
libaio-devel-0.3.106
unixODBC-2.2.11
unixODBC-devel-2.2.11
kernel-headers-2.6




>> download and Install patch "6078836" from MOS:



[root@erpdb1 6078836]# pwd
/u01/sw_home/6078836
[root@erpdb1 6078836]# ls
libdb.so.2 README.txt
[root@erpdb1 6078836]# ls -l /usr/lib/libdb.so.2
ls: /usr/lib/libdb.so.2: No such file or directory
[root@erpdb1 6078836]# cp libdb.so.2 /usr/lib/
[root@erpdb1 6078836]# ls -l /usr/lib/libdb.so.2
-rw-r--r-- 1 root root 5825 Nov 27 11:38 /usr/lib/libdb.so.2
[root@erpdb1 6078836]#




Install this patch similarly on all other hosts


>> Connectivity between hosts:



[root@erpdb1 oraR12]# ping erpdb1
PING erpdb1.orasol.com (192.168.1.71) 56(84) bytes of data.
64 bytes from erpdb1.orasol.com (192.168.1.71): icmp_seq=1 ttl=64 time=0.052 ms
64 bytes from erpdb1.orasol.com (192.168.1.71): icmp_seq=2 ttl=64 time=0.036 ms

--- erpdb1.orasol.com ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 999ms
rtt min/avg/max/mdev = 0.036/0.044/0.052/0.008 ms
[root@erpdb1 oraR12]# ping erpappl1
PING erpappl1.orasol.com (192.168.1.81) 56(84) bytes of data.
64 bytes from erpappl1.orasol.com (192.168.1.81): icmp_seq=1 ttl=64 time=0.424 ms
64 bytes from erpappl1.orasol.com (192.168.1.81): icmp_seq=2 ttl=64 time=0.263 ms
64 bytes from erpappl1.orasol.com (192.168.1.81): icmp_seq=3 ttl=64 time=0.227 ms

--- erpappl1.orasol.com ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2001ms
rtt min/avg/max/mdev = 0.227/0.304/0.424/0.087 ms
[root@erpdb1 oraR12]# ping erpappl2
PING erpappl2.orasol.com (192.168.1.82) 56(84) bytes of data.
64 bytes from erpappl2.orasol.com (192.168.1.82): icmp_seq=1 ttl=64 time=3.50 ms
64 bytes from erpappl2.orasol.com (192.168.1.82): icmp_seq=2 ttl=64 time=0.369 ms
64 bytes from erpappl2.orasol.com (192.168.1.82): icmp_seq=3 ttl=64 time=0.375 ms
64 bytes from erpappl2.orasol.com (192.168.1.82): icmp_seq=4 ttl=64 time=0.398 ms

--- erpappl2.orasol.com ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3003ms
rtt min/avg/max/mdev = 0.369/1.161/3.505/1.353 ms



>> /etc/hosts file from erpdb1:



[root@erpdb1 oraR12]# more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.1.71 erpdb1.orasol.com erpdb1 localhost
192.168.1.81 erpappl1.orasol.com erpappl1
192.168.1.82 erpappl2.orasol.com erpappl2

[root@erpdb1 oraR12]#



- All hosts should ping each other and /etc/hosts file configures as shown above accordingly to host.

>> Create stage Area:

If you have media you can create stage using your media and if you've downloaded software from edelivery portal steps are same for creating stage.

There are two ways we can create stage for R12
1. Stage using script adautostage.pl from start here CD
2. Manual stage - create directories and copy media as listed below



startCD - copy Start Here Disk
oraApps - copy APPL_TOP Disk1, Disk2
oraAS - copy TOOLS Disk
oraDB - copy RDBMS Disk
oraAppDB - copy Databases Disk1 to Disk9








I used external drive as my stage area and i have connected to each server when i need to run rapidwiz utility.

As this is three node Installation, so rapidwiz utility need to run on all three hosts from stage area.

>> Running rapidwiz utility:

- first on erpdb1 to install and configure database

* This will install database and create configuration file for all other nodes.

* When we run rapidwiz on other nodes just it will pick the configuration information from node1

- second on erpappl1 to install and configure conc. services

- Third on erpappl2 to install and configure web and form services



> Running rapidwiz on erpdb1:



























- Here just select "batch processing" to enable only concurrent node on erpappl1



- click on add to add another application server




- click on EDIT Services



- select batch processing, other services as disabled and remaining 3 as enabled



















>> Running rapidwiz on node2 (erpappl1) - conc. server:

























- Installation completed on erpappl1

>> Running rapidwiz on erpappl2:



























We've done with three node application R12.1.1 installation on LINUX. These steps are applicable on all platforms only it differs in OS pre-requisites for kernel parameters, OS patches on other OS platforms.

In next article i will show how to upgrade database to 11gR2 and migrate it to RAC.

Any comments/suggestions are appreciated.

If you need help or have queries the i can be reached - zaheer.appsdba@gmail.com

thanks & regards,
Syed Zaheer

Comments

RK Cyber World said…
its AWASAM i m very much satisified with tis post

Thanq u very much
Apps DBA Workshop
Syed Zaheer said…
Thanks for your kind words.

regards,
Syed Zaheer
santosh said…
hi Zaheer,
this document is realy a good one.
It will be great if you can share link of database upgrade.
my email id:san.behera@gmail.com
Thanks,
Santosh
Syed Zaheer said…
Hi santosh,

Thanks for your comment.

I will share the link for sure . :)

thanks,
Syed Zaheer
amit said…
Awesome work man !!!!!!!!!!!!
Syed Zaheer said…
Hi amit,

Thanks for your words.

regards,
Syed Zaheer
Atif said…
Really very very Great post with snaps which is very helpfull for newbie in Appsdba ..Good work Mr,Zaheer ( appreciated)
Syed Zaheer said…
Hi Atif,

Many thanks for your appreciation.

regards,
Syed Zaheer
Raj said…
Good job Syed...Clearly explained with images and very easy to understand...

It would really be very helpful for me if u could do the same multinode on Solaris please.

You can share the link with me at leo_rodney@yahoo.com...many thanks...
Sundar said…
Can you please explain with the other services is always disabled. Other services consists of Load balancing I suppose, just as this is not required for testinstance you did not enable it ? If this is your though that's fine, else please let me know why ?

I really appriciate you work in updating with the snaps of teh installation, I know how hard is to do all this. U r really great Sir !!!

Also, it would be good if you can share about Multi-node cocepts and cloning of multinode instances.
goutham said…
Hi Zaheer

Thanks for your hard work.good explanation step by step which will help for newcomer who wnts install multi node installation for their demo.



thank you
Anonymous said…
Masa'Allah great Zaheer bhai, No words to praise you...!!

I got what i was searching exactly..!!

Thanks.....!!!

Regards,
Ahmed.
Anonymous said…
Can u please share the link for db upgrade to 11gr2?
Great notes on installation.
Syed Zaheer said…
Hi,

please refer my earlier post:
http://appsdbaworkshop.blogspot.com/2012/03/oracle-11gr2-database-upgrade-in-apps.html

regards,
X A H E E R
Harminder said…
Hi zaheer,

We are trying to run Oracle Ebs 12.1.3 on 2 node linux cluster. We have created 1 server for the apps and the other for Db. When the apps server is stopped, then the cluster takes the ownership of the apps to scond server, but the apps does not start.

Can you share any document where 2 node linux cluster on Linux.

my email id is harminder007@gmail.com

thanks
Unknown said…
All documents of ues are very clearly explained with images and very easy to understand.

plz share the oracle Apps EBS R12.2.2 Installation on linux ...

thank u...
Mohit Jain said…
can you please tell me the location where configuration file will be created and that will be used in second and third node.

Regards
Shahid ul Ghani said…
I have given the original source of your link.
Anonymous said…
Nice document
Shaik Basha said…
Hi Zaheer Bhai ,


Thanks for sharing this Article which is soo Beautiful and Rally appreciated for the work you had done here ..
******************************
if possible , Could you Please the document and clear steps of upgrading ORACLE APPLICATIONS from 11.5.10.2 with database 9.2.0.6 to 12.1.3 with database 11.2.0.3
*******************************


Please help us on this ..

Waiting for the valuable reply ..

Thanks and Regards,
Shaik . Basha
Anonymous said…
Hi Xaheer,
Very good article. I am facing an issue when the installation has started on database node.

It cannot unzip the database files. Below is the error in log file:

Unzip Count:153

Processing Disk1....

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

Please make sure you have UnZip 5.X in your path and try again...

Cannot execute Install for database ORACLE_HOME

RW-50010: Error: - script has returned an error: 1
RW-50004: Error code received when running external process. Check log file for details.
Running Database Install Driver for VIS instance


Thanks and Regards
Roshan

Popular posts from this blog

Disable Firewall on Oracle Linux 8

In this blogpost we will see how we can stop/disable the firewall on Oracle Linux 8, the firewall command is same in both linux 7 an linux 8. The below listed is the procedure for stopping and disabling the  firewall on Oracle Linux 8. - Here we can see the firewall deamon in active state - Here when we stop the firewall in previous command, now the firewall daemon is dead - For permanent disabling the firewall on server, we can use "disable" option The following commands will be helpful: #systemctl status firewalld #systemctl stop firewalld #systemctl disable firewalld #systemctl enable firewalld #systemctl start firewalld Hope it helps !! Thanks for reading :) regards, X A H E E R

Enable Desktop on Oracle Solaris 11.4

Oracle Solaris 11 installation has multiple options to choose for installation of an Operating Environment, but mostly Oracle Solaris text install media is used and this installation media doesn't offer the GUI Desktop Environment by default after the installation. This blog post will explain how we can enable the desktop for Oracle Solaris 11.4 operating system, after the completion of installation. We have to install "solaris-desktop" package and reboot the machine and GUI desktop will be enabled for the Operating System. In this blog post my virtual machine is connected to the internet and hence I am able to use available pupblic repository for package installation, if in case internet is not available for the server/machine then we have configure the local/Server  repository for the installation. Follow the below steps for desktop package installation: After installation of dekstop package we are now able to login with GUI desktop environment

Oracle Applications R12.2 Installation on Linux using virtual box

Oracle E-Business suite R12.2 is released a month ago. I received too many requests from my followers to demonstrate this Installation. This is a step by step detailed article for Installing Oracle E-business suite R12,2 on Oracle Enterprise Linux 5.7 (64-bit). I've used oracle virtual box for Installing Linux. Note:  This Installation is demonstrated on virtual machine with 8GB RAM and Installation completed in 7 hours. I am not sure whether this Installation will work with less than this .  My Virtual Machine configuration: CPU    = 1 core RAM   = 8 GB HDD   =  380 GB Software's Required: 1) Oracle Virtual Box 2) Oracle Enterprise Linux 5.7 (64-bit) 3) Oracle E-Business suite R12.2 for LinuxX86-64-bit Installation Steps: Hardware requirements Create virtual machine and Install operating system Operating System pre-requisites Prepare Stage Area Install Oracle EBS R12.2 software Verify Installation 1. Hardware Requirement