Oracle E-Business 12.2 Installation

Oracle E-Business 12.2 Installation

Disk space

Fresh- PROD 180gb
Vision 350gb

Software Required:

Oracle Enterprise Linux 5.7 (64-bit)
Oracle E-Business suite R12.2 for LinuxX86-64-bit

Hardware Requirement:

Databases Node:
Operating System : Oracle Enterprise Linux 5.7 64bit
Memory               : 16 GB
Hostname : delta001db.oracle.com
IP Address           : 192.168.1.110

Applications Node:
Operating System : Oracle Enterprise Linux 5.2 64bit
Memory : 16 GB
Hostname : delta001app.oracle.com
IP Address : 192.168.1.111

Prerequisite Steps:

1.create OS group, user and directories:

groupadd dbaerp
useradd -g dbaerp oracle
useradd -g dbaerp applmgr

Changing password for user oracle and applmgr.
passwd oracle
passwd applmgr

2.create directories and change permissions:

mkdir -p /u01/ora_prod
mkdir -p /u01/appl_prod
chmod -R 775 /u01/*_prod
chown -R oracle:dbaerp /u01/ora_prod
chown -R applmgr:dbaerp /u01/appl_prod

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

#All below kernel parameters are related to oracle EBS - R12.2#################kernel.msgmnb = 65536
kernel.msgmax = 65536
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@delta001 Server]# 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.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

5.Verify and change Domain Name System (DNS) Resolver Parameters

Two Domain Name System (DNS) resolver parameters (timeout and attempts) are set by default to low values when the operating system is installed. These low values may cause attempted network connections to an Oracle database to fail. If this happens, add or update the following entries to these minimum settings in the /etc/resolv.conf file on each server node:

options attempts:5
options timeout:15

6.Modifying the Number of Open File Descriptors open the /etc/security/limits.conf file and change the existing values for "hard" and "soft" parameters as follows. Restart the system after making changes.

Note: If the current value for any parameter is higher than the value listed in this document, then do not change the value of that parameter.

* hardnofile 65535
* softnofile 4096
* hardnproc 16384
* softnproc 2047

7.Make sure all OS packages exists on the system.

To Check the Package is installed
Use:  rpm –q <pkgname>

To Install the required package
Use: rpm –i<pkg file name>

To Erase the package
Use: rpm –e <pkg name>

The following packages should exists on system for a successful Installation.

openmotif21-2.1.30-11.EL5.i3861
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386

8.checking swap memory should be 16GB or more (20GB is configured)

[root@delta001 ~]# grep SwapTotal /proc/meminfo
SwapTotal:      20482864 kB
[root@delta001 ~]#

9.Verify /etc/hosts file. It should be configured with fully qualified domain name

[root@delta001 ~]# 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
192.168.1.100           detlta001.oracle.com delta001

10.create Inventory and grant 775 permission to Inventory directory

[root@delta001 ~]# cat /etc/oraInst.loc
inventory_loc=/u01/ora_prod/oraInventory/
[root@delta001 ~]# mkdir -p /u01/ora_prod/oraInventory/

11.Verify that the /etc/sysconfig/network file is formatted as follows:

[root@delta001 Server]# more /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=detlta001.oracle.com

12.Create soft link for library as below for 10.1.2 Server:

[root@delta001 Server]# ls -lrt /usr/lib/libXtst.so.6
lrwxrwxrwx 1 root root 16 Sep 29 21:48 /usr/lib/libXtst.so.6 -> libXtst.so.6.1.0
[root@delta001 Server]# unlink /usr/lib/libXtst.so.6
[root@delta001 Server]# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6
[root@delta001 Server]# ls -lrt /usr/lib/libXtst.so.6
lrwxrwxrwx 1 root root 29 Sep 29 23:34 /usr/lib/libXtst.so.6 -> /usr/X11R6/lib/libXtst.so.6.1
[root@delta001 Server]#
[root@delta001 etc]# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2
[root@delta001 etc]#

13.Threading model in Linux should be NPTL

[root@delta001 Server]# getconf GNU_LIBPTHREAD_VERSION
NPTL 2.5
[root@delta001 Server]#

14.Prepare Staging Area:

a) Download all required Parts
b) Unzip startHere CD for getting buildStage.sh
c) Execute bulildStage.sh script for creating Stage

15.Unzip startHere CD for getting buildStage.sh

- Create directory for R12 Stage
- unzip parts of StartHere CD in R12 Staging directory

[root@erpnode2 Oracle E-Business Suite 12.2.2]# ls -lrt V35215-*
-rwxrwx--- 1 root vboxsf   85594608 Sep 24 10:13 V35215-01_2of3.zip
-rwxrwx--- 1 root vboxsf  101976210 Sep 24 10:17 V35215-01_3of3.zip
-rwxrwx--- 1 root vboxsf 1409220447 Sep 24 12:55 V35215-01_1of3.zip
[root@erpnode1 Oracle E-Business Suite 12.2.2]# unzip V35215-01_1of3.zip

- After unzipping all three parts it will create directory startCD

c) Execute bulildStage.sh script for creating Stage:

- This script will be located under "startCD > rapidwiz > bin

[root@erpnode2 Disk1]# cd rapidwiz/
[root@erpnode2 rapidwiz]# ls
bin            driver  File    jlib  oui       RapidWiz.cmd  RapidWizVersion      TechInstallers  unzip
ClientWiz.cmd  etc     images  jre   rapidwiz  RapidWiz.ini  RapidWizVersion.cmd  template        Xpatches
[root@erpnode2 rapidwiz]# cd bin
[root@erpnode2 bin]# ls
adaixchk.sh   adgetreg.exe    buildStage.sh  JNLSLib3.dll  orpass.sql         riwipu.sh     riwTDBup.sql  WizOSD.dll
adchkutl.cmd  AFSCJAV8.pls    checkOS.cmd    JNLSTool.dll  perl510.dll        riwperl.pl    riwTXdis.sh   WTPrereqs.cmd
adchkutl.sh   AFSCJAVS.pls    checkOS.sh     launch.exe    perl.exe           riwTDBup.cmd  runWizard.sh  WTPrereqs.sh
addbptchk.sh  buildStage.cmd  filespace.exe  NMAKE.EXE     racvalidations.sh  riwTDBup.sh   syspass.sql
[root@erpnode2 bin]# sh buildStage.sh


                Build Stage Menu

------------------------------------------------------
1.     Create new stage area
2.     Copy new patches to current stage area.
3.     Display existing files in stage TechPatches.
4.     Exit menu
Enter your choice [4]: 1

         Rapid Install Platform Menu

------------------------------------------------------
1.    Oracle Solaris SPARC (64-bit)
2.    Linux x86-64
3.    IBM AIX on Power Systems (64-bit)
4.    HP-UX Itanium
5.    Exit Menu
Enter your choice [5]: 2

/media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../jlib/java oracle.apps.ad.rapidwiz.util.StageBuilder /media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin

Please enter the directory containing the zipped installation media:
/media/sf_Oracle_EBS_12.2.2
Unzipping V29764-01.zip
Unzipping V29856-01.zip
Unzipping V35215-01_1of3.zip
Unzipping V35215-01_2of3.zip
Unzipping V35215-01_3of3.zip
Unzipping V35230-01_1of2.zip
Unzipping V35230-01_2of2.zip
Unzipping V35231-01_1of5.zip
Unzipping V35231-01_2of5.zip
Unzipping V35231-01_3of5.zip
Unzipping V35231-01_4of5.zip
Unzipping V35231-01_5of5.zip
Unzipping V35802-01.zip
Unzipping V35803-01_1of3.zip
Unzipping V35803-01_2of3.zip
Unzipping V35803-01_3of3.zip
Unzipping V35804-01_1of2.zip
Unzipping V35804-01_2of2.zip
Unzipping V35805-01_1of2.zip
Unzipping V35805-01_2of2.zip
Unzipping V35806-01_1of3.zip
Unzipping V35806-01_2of3.zip
Unzipping V35806-01_3of3.zip
Unzipping V35807-01.zip
Unzipping V35808-01.zip
unzipping file V35808-01.zip
Unzipping V35809-01.zip
Unzipping V35810-01.zip
Unzipping V35811-01.zip
Unzipping V35812-01.zip
Unzipping V35813-01.zip
Unzipping V36798-01.zip
Unzipping V37515-01_1of6.zip
Unzipping V37515-01_2of6.zip
Unzipping V37515-01_3of6.zip
Unzipping V37515-01_4of6.zip
Unzipping V37515-01_5of6.zip
Unzipping V37515-01_6of6.zip
Unzipping V39211-01.zip
Unzipping V39571-01.zip
Unzipping V39615-01.zip
Unzipping V39664-01.zip
Applying one-off patches
All files have been unzipped.
Stage area is complete.

Done Unzipping shiphome ...
StageBuilder will now stage the tech patches for Linux_x64...
Copying one-off patches to shiphome
/media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../unzip/Linux_x64/unzip -o /media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip -d /media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches

Archive:  /media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip
creating: /media/sf_Oracle_EBS_12.2.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16303726/

Done Copying additional patches
Verifying stage area...

Directory /media/sf_Oracle_EBS_12.2.2/TechInstallMedia is valid
Directory /media/sf_Oracle_EBS_12.2.2/TechPatches/DB is valid
Directory /media/sf_Oracle_EBS_12.2.2/TechPatches/MiddleTier is valid
Directory /media/sf_Oracle_EBS_12.2.2/EBSInstallMedia/AppDB is valid
Directory /media/sf_Oracle_EBS_12.2.2/EBSInstallMedia/Apps is valid
Directory /media/sf_Oracle_EBS_12.2.2/EBSInstallMedia/AS10.1.2 is valid
Directory /media/sf_Oracle_EBS_12.2.2/TechInstallMedia/database is valid
Directory /media/sf_Oracle_EBS_12.2.2/TechInstallMedia/ohs11116 is valid
Directory /media/sf_Oracle_EBS_12.2.2/TechInstallMedia/wls1036_generic is valid

Stage area verified.

Press enter to continue...

                Build Stage Menu

------------------------------------------------------

1.     Create new stage area
2.     Copy new patches to current stage area.
3.     Display existing files in stage TechPatches.
4.     Exit menu
Enter your choice [4]:     

16.Make sure proper privileges are give to stage directory (755 or 775)

17.Install Oracle E-Business suite R12.2:

- Make sure proper display is configured

18.start the Installation through root user

[root@delta001 rapidwiz]pwd
/u01/Stage/startCD/Disk1/rapidwiz
[root@delta001 rapidwiz]# ./rapidwiz

Default Port Numbers:
node manager         5556
wls admin server 7001
wls oacore port 7201
wls forms 7401
wls oafm         7601
ohs admin 9999
database         1521

Verify Installation:

- Login to Oracle EBS and  verify application access

username=sysadmin
password=sysadmin

Note: after installing the 12.2.2 the default password of sysadmin is sysadmin.

weblogic services:
admin server(admin)

1.forms-c4ws_server1
2.forms_server1
3.oacore_server1
4.oafm_server1