Multi-Node Installation of Oracle EBS (Apps) R12 on Linux

Installation of an Oracle EBS 12.1.1 on Linux5.5(32bit).

  Single  user Multi Node installation steps.
 
Prepare 2 system with same configuration.
All prerequisite done on both system.
 
 

Software preparation:-

 

Once you click on the link “Oracle E-Business Suite Release 12.1.1 Media Pack for Linux x86”, you have a lot of file to download. Not all of them are necessary for the installation of EBS. 

 
Check Free space:-
[root@sujeet ~]# df -h
 
[root@sujeet ~]# free
 
   
 Check Physical Memory. 
[root@sujeet ~]# grep MemTotal /proc/meminfoMemTotal:      
 2059516 kB/* At least 2GB of physical Memory (RAM) is required.
  In my case I have 2GB.*/ 
 
 Check Swap Space. 
[root@sujeet ~]# grep SwapTotal /proc/meminfoSwapTotal:      
     3148732 kB
 
 
1.Check Selinux
 
System>>Administration>>Security level & Firewell
  click on SElinux tab
  check SElinux--Disable.....
 
2.Now setup User that we will use as sujeet owner and the 
groups that it will need for installing and managing Oracle.
 GUI Mode:-
Create User,Group and assign group to user. 
System>>Administration>>User & Group create...
  (user-sujeet....group-dba)
 
 COMMAND LINE:- 
 Create User,Group and assign group to user.
[root@sujeet ~]# useradd -g dba -m sujeet 
[root@sujeet ~]# passwd sujeet 
Changing password for user oracle.
 New UNIX password: BAD PASSWORD: 
 Retype new UNIX password: 
 passwd: all authentication tokens updated successfully.
 
 
 3.create Base directory and give full permission RWX..
 
[root@r0146 /]# mkdir r12
[root@r0146 /]# chown -R sujeet:dba /r12
[root@r0146 /]# chmod -R 777 r12/
[root@r0146 /]# ll
 
4.Enter Hostname and IP Address in Host file.
 
[root@r0146 /]# vi /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 loca:lhost6
172.16.3.142    sujeet.sonu.com sujeet
 
5.Check hostname in Network file 
 
[root@r0146 ~]# cat /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=sujeet.sonu.com
 
6. Ping hostname and IP 

[root@r0146 ~]# ping 172.16.3.142
[root@r0146 ~]# ping sujeet
 
7.Install RPM 
 
[root@r0146 /]# cd R12-SETUP/
[root@r0146 R12-SETUP]# ls
rpms  stageR12_32bit
[root@r0146 R12-SETUP]# cd rpms/
[root@r0146 rpms]# ls
6078836
compat-glibc-2.3.4-2.26.i386.rpm
compat-glibc-headers-2.3.4-2.26.i386.rpm
extra.repo
libaio-0.3.106-3.2.i386.rpm
libaio-devel-0.3.106-3.2.i386.rpm
libXp-1.0.0-8.1.el5.i386.rpm
openmotif21-2.1.30-11.EL5.i386.rpm
p6078836_101330_LINUX.zip
pr
rhel54_x86.repo
sysstat-7.0.2-3.el5.i386.rpm
unixODBC-2.2.11-7.1.i386.rpm
unixODBC-devel-2.2.11-7.1.i386.rpm
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm
 install RPM command:-
[root@r0146 rpms]# rpm -ivh compat-glibc-2.3.4-2.26.i386.rpm
[root@r0146 rpms]# rpm Uvh compat-glibc-2.3.4-2.26.i386.rpm

 
 Check RPM install or not through this command:-
[root@r0146 rpms]# rpm -qa|grep unixODBC
 
Edit Limit.conf file :- 
[root@panora03 ~]# vi /etc/security/limits.conf
hard      nofile         65535  soft       nofile         4096 hard      nproc         16384 soft       nproc         2047
 
  
8.check kernel parameter:-
 
[root@r0146 ~]# vi /etc/sysctl.conf
[root@r0146 ~]# cd /
 Go to location of sysctl.conf file:-
 
[root@r0146 /]# mv R12-SETUP/stageR12_32bit/pre_req/sysctl.conf 
 /etc/sysctl.conf
mv: overwrite `/etc/sysctl.conf'? yes
 
[root@r0146 /]# cat /etc/sysctl.conf
 
# Kernel sysctl configuration file for Red Hat Linux
 
check kernel parameter:-
[root@r0146 ~]# /sbin/sysctl -p
kernel.shmall = 2097152
kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 5000

net.core.rmem_default=4194304

net.core.wmem_default=262144

net.core.rmem_max=4194304

net.core.wmem_max=262144

 
Restart system:- 
[root@r0146 ~]# init 6
 
LOGIN AS sujeet(new user)
 
[sujeet@sujeet ~]$ cd /R12-SETUP/stageR12_32bit/startCD/Disk1/rapidwiz/
 
[sujeet@sujeet ~]$  ./rapidwiz 
 
Open window>>>>>>>>>>>>>>



Select the Oracle Applications Release 12.1.1
 

Select suitable option if you need to download updates





Select [New Configuration]
 


Select the port pool, I have chosen the default i.e. 0, for my env.
 




Enter DB host info along with user and group
 



Select [Suite Licensing]

 

 Install the languages if you need multi-lingual support



Enter Application Node info along with owner and group
 

Review the info you entered for hosts. You can also add Additional Nodes here for Application tier file system
 
 Now the OUI will perform the pre-checks before the actual installation kicks in



Review the Validation Report. check the failed ones and click on Retry.

Installation will kick in, keep an eye on it. It will usually take around couple of hours depending on the speed of your machine.


 Once installation completes, the post install validation box will reappear. Make sure everything is green before going further



 At the end, click on Finish to end the installation of DB tier.


Next step is to install the application tier on appsnode host.

Before you start the install of the App tier you need to copy the config file from DB tier to apps tier.

To do this there are two ways

    1. Copy <sid>_<host>.xml file aka context file to appsnode
    2. start the install by issuing ./rapidwiz and provide the DB details to copy the config from DB


One can copy context file as follows





 [oracle@appsdbnode appsutil]$ cd /u01/app/oracle/visr12/db/tech_st/11.1.0/appsutil
[oracle@appsdbnode appsutil]$ scp conf_visr12.txt  appsnode:/home/oracle/

conf_visr12.txt   



 click on [Saved configuration] option, and enter the path copied context file 


check the validation report to make sure everything is healthy.


 Click on [Next]

Review the progress of the installation

Review the progress of the installation






After install was finished, my post install checks failed as my HTTP server failed to start hence all other dependencies failed





Cause - 

After a bit of research I found out that the start failed due to the fact it failed to locate on library component and fix is the create the link for that missing component 



Solution -

[root@appsnode ~]# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2



[oracle@appsnode scripts]$ adstrtal.sh  apps/apps



[oracle@appsnode scripts]$ adopmnctl.sh status

You are running adopmnctl.sh version 120.6

Checking status of OPMN managed processes...

Processes in Instance: visr12_appsnode.appsnode.localdomain

---------------------------------+--------------------+---------+----------------------

ias-component                              | process-type       |  pid         | status

---------------------------------+--------------------+---------+----------------------

OC4JGroup:default_group          | OC4J:oafm           |   31135 | Alive

OC4JGroup:default_group          | OC4J:forms          |   31070 | Alive

OC4JGroup:default_group          | OC4J:oacore        |   30984 | Alive

HTTP_Server                                   | HTTP_Server        |   30933 | Alive



After manually start the opmn stack, I click on [Retry] on validation page of installer and there you go. Everything came up







 

 Click on connect to Oracle application Release 12.1.1 link.

Login page open.

Post install, I tried to login to Apps console using following URL>>http://<hostname.domain>:<port_pool_no>


URL - http://appsnode.localdomain:8000

use default credentials - sysadmin/sysadmin to login console

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...