Oracle AppsDBA: Oracle Apps 12.1 Pre Installation Steps

Oracle Applications R12.1.1 Installation (Linux) – Single Node

Install missed packages

Check the rpm’s installed in the server or not using below command

rpm -qa --qf='%{NAME}-%{VERSION}-%{RELEASE}.%{ARCH}.rpm\n'|grep <rpm>

binutils gcc gcc-c++ glibc glibc-common \

libstdc++ libstdc++-devel make sysstat libaio \

libaio-devel glibc-devel libgcc \

gdbm libgomp util-linux xorg-x11-libs-compat \

elfutils-libelf-devel elfutils-libelf-devel-static \

xorg-x11-libs-compat \

unixODBC unixODBC-devel kernel-headers binutils openmotif21 make \

libXp libgomp compat-libstdc++-33-3.2.3 compat-libstdc++-296-2.96 glibcdevel libXi libXt

binutils-2.17.50.0.6-6.el5 (x86_64)

control-center-2.16.0-16.el5 (x86_64)

control-center-2.16.0-16.el5 (i386)

gcc-4.1.2-42.el5 (x86_64)

gcc-c++-4.1.2-42.el5 (x86_64)

glibc-2.5-24 (i686)

glibc-2.5-24 (x86_64)

glibc-common-2.5-24 (x86_64)

libstdc++-4.1.2-42.el5 (x86_64)

libstdc++-4.1.2-42.el5 (i386)

libstdc++-devel-4.1.2-42.el5 (x86_64)

make-3.81-3.el5 (x86_64)

package sysstat is not installed

libaio-0.3.106-3.2 (x86_64)

libaio-0.3.106-3.2 (i386)

package libaio-devel is not installed

package openmotif21 is not installed

glibc-devel-2.5-24 (i386)

glibc-devel-2.5-24 (x86_64)

libgcc-4.1.2-42.el5 (x86_64)

libgcc-4.1.2-42.el5 (i386)

gdbm-1.8.0-26.2.1 (x86_64)

gdbm-1.8.0-26.2.1 (i386)

libgomp-4.1.2-42.el5 (x86_64)

util-linux-2.13-0.47.el5 (x86_64)

package xorg-x11-libs-compat is not installed

elfutils-libelf-devel-0.125-3.el5 (x86_64)

elfutils-libelf-devel-static-0.125-3.el5 (x86_64)

package libaio-devel is not installed

package unixODBC is not installed

package unixODBC-devel is not installed

kernel-headers-2.6.18-92.el5 (x86_64)

binutils-2.17.50.0.6-6.el5 (x86_64)

make-3.81-3.el5 (x86_64)

gdbm-1.8.0-26.2.1 (x86_64)

gdbm-1.8.0-26.2.1 (i386)

package libXp is not installed

libgomp-4.1.2-42.el5 (x86_64)

package xorg-x11-libs-compat is not installed

The following i386 packages are not part of the OS distribution media and must be downloaded separately (from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux for both OEL 5 and RHEL 5) and installed manually:

openmotif21-2.1.30-11.EL5.i3861

xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386

For Update 1 or 2: o binutils-2.17.50.0.6-6.0.1.i3862

For Update 3: o binutils-2.17.50.0.6-9.0.1.i3862

Apply the missing packages

rpm -Uvh sysstat-7.0.2-1.el5.x86_64.rpm

rpm -Uvh libaio-devel-0.3.106-3.2.i386.rpm

rpm -Uvh compat-libstdc++-33-3.2.3-61.x86_64.rpm

rpm -Uvh compat-libstdc++-33-3.2.3-61.i386.rpm

rpm -Uvh xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

rpm -Uvh unixODBC-2.2.11-7.1.i386.rpm

rpm -Uvh unixODBC-devel-2.2.11-7.1.i386.rpm

rpm -Uvh libXp-1.0.0-8.1.el5.i386.rpm

rpm -Uvh openmotif21-2.1.30-11.EL5.i386.rpm

Check the rpm’s installed in the server or not using below command

rpm -qa --qf='%{NAME}-%{VERSION}-%{RELEASE}.%{ARCH}.rpm\n'|grep <rpm>

binutils control-center gcc gcc-c++ glibc glibc-common \

libstdc++ libstdc++-devel make sysstat libaio \

libaio-devel glibc-devel libgcc \

gdbm libgomp util-linux xorg-x11-libs-compat \

elfutils-libelf-devel elfutils-libelf-devel-static \

libaio-devel xorg-x11-libs-compat \

unixODBC unixODBC-devel kernel-headers binutils openmotif21 make gdbm \

libXp libgomp

Shared memory and semaphore setting

echo "kernel.shmmax=2147483648" >> /etc/sysctl.conf

echo "kernel.sem=250 32000 100 128" >> /etc/sysctl.conf

echo "fs.file-max=65536" >> /etc/sysctl.conf

echo "net.ipv4.ip_local_port_range = 2024 65000" >> /etc/sysctl.conf

Modify number of open descriptors

echo "hard nofile 65535" >> /etc/security/limits.conf

echo "soft nofile 4096" >> /etc/security/limits.conf

OS Users and group creation

# Add the group and users

groupadd dba

useradd oracle -g dba

useradd applmgr -g dba

passwd oracle (give the password for oracle)

passwd applmgr (give the password for applmgr)

Permissions are given oracle and applmgr so that they can write to /d01/oracle

chgrp dba /d01/oracle

chmod g+w /d01/oracle

Note: Please check whether oracle and applmgr are able to write to /d01/oracle

Check that the /etc/hosts entries are as follows

127.0.0.1 localhost.localdomain localhost

<ip address> <hostname>.<domainname> hostname

Restart the server or use run to sysctl –p to affect the changes without restarting the server

sysctl –p

Issue after installation with Apache Server

> Apache was not starting

Apache is the problem, once it is fixed you can retry or restart the application tier

vi /d02/oracle/PROD/inst/apps/otm_otm/logs/ora/10.1.3/opmn/HTTP_Server~1.log

/d02/oracle/PROD/inst/apps/otm_otm/ora/10.1.3/Apache/Apache/bin/apachectl startssl:

execing httpd

/d02/oracle/PROD/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading

Shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

Solution –

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

Stop and start the Apache

Oracle Apps R12.1.1 Multi Node Installation on Linux

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

Hosts information for Installation:

HOSTNAME	IP ADDRESS	SERVICES	DISKSPACE
BRITDB	192.168.10.11	DATABASE	155 GB
BRITAPPL1	192.168.10.12	APPLICATION1	40 GB
BRITAPPL2	192.168.10.13	APPLICATION2	40 GB

Perform all operating system per-requisites on all nodes:

BRITDB1

[root@BRITdb1 ~]# groupadd dba
[root@BRITdb1 ~]# useradd -g dba oramgr

[root@BRITdb1 ~]# 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@BRITdb1 ~]# mkdir /u01/oraR12
[root@BRITdb1 ~]# chmod -R 775 /u01/oraR12
[root@BRITdb1 ~]# chown -R oramgr:dba /u01/oraR12/

BRITAPPL1:

[root@BRITappl1 ~]# groupadd dba
[root@BRITappl1 ~]# useradd -g dba applBRIT
[root@BRITappl1 ~]# passwd applBRIT
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@BRITappl1 ~]# chmod -R 775 /u01/applR12/
[root@BRITappl1 ~]# chown -R applmgr:dba /u01/applR12/

BRITAPPL2:

[root@BRITapl2 ~]# groupadd dba
[root@BRITapl2 ~]# useradd -g dba applBRIT
[root@BRITapl2 ~]# passwd applBRIT
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@BRITapl2 ~]# chmod -R 775 /u01/applR12/
[root@BRITapl2 ~]# chown -R applmgr:dba /u01/applR12/

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

These kernel parameters should be configured on all hosts BRITDB1, BRITAPPL1, BRITAPPL2.

#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@oraBRIT1]# 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@oraBRIT1 ~]# 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@oraBRIT1 ~]#

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

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:

Check with the below os command;

rpm -qa --qf='%{NAME}-%{VERSION}-%{RELEASE}.%{ARCH}.rpm\n'|grep <rpm>

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:

Install this patch similarly on all other hosts

>> Connectivity between hosts:

[root@BRITdb1 oraR12]# ping BRITdb1

PING BRITdb1.orasol.com (192.168.1.71) 56(84) bytes of data.

64 bytes from BRITdb1.orasol.com (192.168.1.71): icmp_seq=1 ttl=64 time=0.052 ms

64 bytes from BRITdb1.orasol.com (192.168.1.71): icmp_seq=2 ttl=64 time=0.036 ms



--- BRITdb1.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@BRITdb1 oraR12]# ping BRITappl1

PING BRITappl1.orasol.com (192.168.1.81) 56(84) bytes of data.

64 bytes from BRITappl1.orasol.com (192.168.1.81): icmp_seq=1 ttl=64 time=0.424 ms

64 bytes from BRITappl1.orasol.com (192.168.1.81): icmp_seq=2 ttl=64 time=0.263 ms

64 bytes from BRITappl1.orasol.com (192.168.1.81): icmp_seq=3 ttl=64 time=0.227 ms



--- BRITappl1.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@BRITdb1 oraR12]# ping BRITappl2

PING BRITappl2.orasol.com (192.168.1.82) 56(84) bytes of data.

64 bytes from BRITappl2.orasol.com (192.168.1.82): icmp_seq=1 ttl=64 time=3.50 ms

64 bytes from BRITappl2.orasol.com (192.168.1.82): icmp_seq=2 ttl=64 time=0.369 ms

64 bytes from BRITappl2.orasol.com (192.168.1.82): icmp_seq=3 ttl=64 time=0.375 ms

64 bytes from BRITappl2.orasol.com (192.168.1.82): icmp_seq=4 ttl=64 time=0.398 ms



--- BRITappl2.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 BRITdb1:

[root@BRITdb1 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.11            BRITdb1.orasol.com       BRITdb1

192.168.1.12            BRITappl1.orasol.com     BRITappl1

192.168.1.13            BRITappl2.orasol.com     BRITappl2



[root@BRITdb1 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

oraDB          - copy RDBMS Disk

oraApps         - copy APPL_TOP Disk1, Disk2

oraAS          - copy TOOLS 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.

BRIT Technologies

Plot No 10/B Srinivas Nagar Colony (W), Harsha Mess Lane S.R Nagar -38

+91-40-65540088, +91-9966549974, www.brittechnologies.com

Oracle AppsDBA

Oracle Apps 12.1 Pre Installation Steps

No comments:

Post a Comment