Saturday, October 30, 2010

R12.1.1 Installation on OEL 5.4 ( x86_64 )

Hi All,

Happy 2 b part of this G-R-O-U-P.

I wish this helps to build GOOD Frndship too bw Us…

I would like to Start>> my Post with R12.1.1 Installation which I've done recently…

Oracle E-Business Suite Installation Release 12 (12.1.1) on OEL 5.4 ( x86_64 )
(Note ID :761564.1 )

Instance Details:

Type of Install : Vision Demo Database

Version : R 12 Applications ( 12.1.1 ) --- MT
11g Database ( 11.1.0.7.0 ) --- DB

Instance Name : VIS

Stage : /stage/R12.1.1/Software/

Users : MT User : applmgr ( home path: /apps/applmgr )
DB User : oracle ( home path: /apps/oracle )

[applmgr@OracleApps01 ~]$ uname -r
2.6.18-164.el5

[applmgr@OracleApps01 ~]$ uname -ms
Linux x86_64

Total Size : DB+MT - 225GB ( Vision Demo Database )
Note: Fresh Demo Database around 85-90 GB

Stage Size : 47G

R12.1.1 Installation basic steps involves:

1) Stage Creation
2) OS Preparation
3) Installtion
4) Post Issues & Fixes

Let's C step '/' step

============================================================
1) Creating Stage
============================================================
4m edelivery.oracle.com

download all the zip archives for

Oracle E-Business Suite Release 12.1.1 Media Pack for Linux x86-64-bit

[root@OracleApps01 R12.1.1_64bit]# ls
Rapid Install APPL TOP Disk-01_1of3.zip Rapid Install Databases Disk-02_2of3.zip Rapid Install Databases Disk-05_3of3.zip Rapid Install Databases Disk-09_1of2.zip
Rapid Install APPL TOP Disk-01_2of3.zip Rapid Install Databases Disk-02_3of3.zip Rapid Install Databases Disk-06_1of3.zip Rapid Install Databases Disk-09_2of2.zip
Rapid Install APPL TOP Disk-01_3of3.zip Rapid Install Databases Disk-03_1of3.zip Rapid Install Databases Disk-06_2of3.zip Rapid Install RDBMS Disk-01_1of3.zip
Rapid Install APPL TOP Disk-02_1of3.zip Rapid Install Databases Disk-03_2of3.zip Rapid Install Databases Disk-06_3of3.zip Rapid Install RDBMS Disk-01_2of3.zip
Rapid Install APPL TOP Disk-02_2of3.zip Rapid Install Databases Disk-03_3of3.zip Rapid Install Databases Disk-07_1of3.zip Rapid Install RDBMS Disk-01_3of3.zip
Rapid Install APPL TOP Disk-02_3of3.zip Rapid Install Databases Disk-04_1of3.zip Rapid Install Databases Disk-07_2of3.zip Rapid Install Start Here-01_1of4.zip
Rapid Install Databases Disk-01_1of3.zip Rapid Install Databases Disk-04_2of3.zip Rapid Install Databases Disk-07_3of3.zip Rapid Install Start Here-01_2of4.zip
Rapid Install Databases Disk-01_2of3.zip Rapid Install Databases Disk-04_3of3.zip Rapid Install Databases Disk-08_1of3.zip Rapid Install Start Here-01_3of4.zip
Rapid Install Databases Disk-01_3of3.zip Rapid Install Databases Disk-05_1of3.zip Rapid Install Databases Disk-08_2of3.zip Rapid Install Start Here-01_4of4.zip
Rapid Install Databases Disk-02_1of3.zip Rapid Install Databases Disk-05_2of3.zip Rapid Install Databases Disk-08_3of3.zip Rapid Install Tools Disk-01.zip

--- Total 40 Zip files

[root@OracleApps01 R12.1.1_64bit]#
[root@OracleApps01 R12.1.1_64bit]# pwd
/stage/R12.1.1/R12.1.1_64bit

[root@OracleApps01 R12.1.1_64bit]# mkdir -p /stage/R12.1.1/Software
[root@OracleApps01 R12.1.1_64bit]# chmod 755 /stage/R12.1.1/Software
[root@OracleApps01 R12.1.1_64bit]#

--- Unzippping all the 40 files to common dir '/stage/R12.1.1/Software'

[root@OracleApps01 R12.1.1_64bit]# unzip "*.zip" -od /stage/R12.1.1/Software
Archive: Rapid Install Databases Disk-08_1of3.zip
inflating: /stage/R12.1.1/Software/oraAppDB/dvd.label
extracting: /stage/R12.1.1/Software/oraAppDB/component.label
creating: /stage/R12.1.1/Software/oraAppDB/Disk57/
creating: /stage/R12.1.1/Software/oraAppDB/Disk57/bin/
creating: /stage/R12.1.1/Software/oraAppDB/Disk57/data/
creating: /stage/R12.1.1/Software/oraAppDB/Disk57/data/bin/
creating: /stage/R12.1.1/Software/oraAppDB/Disk57/data/driver/
.
.
.
.
.
.
.
.
.
extracting: /stage/R12.1.1/Software/oraApps/Disk9/appl/stage/prp1020.zip
extracting: /stage/R12.1.1/Software/oraApps/Disk9/appl/stage/qpr1009.zip
extracting: /stage/R12.1.1/Software/oraApps/Disk9/appl/stage/wsm1011.zip
creating: /stage/R12.1.1/Software/oraApps/Disk9/bin/
inflating: /stage/R12.1.1/Software/oraApps/Disk9/disk.label
creating: /stage/R12.1.1/Software/oraApps/Disk9/driver/

40 archives were successfully processed.
[root@OracleApps01 R12.1.1_64bit]#

============================================================
1) Creating Stage -- Done



============================================================
2) OS Preparation
============================================================

[root@OracleApps01 ~]# groupadd dba
[root@OracleApps01 ~]# useradd applmgr -g dba -d /apps/applmgr
[root@OracleApps01 ~]# useradd oracle -g dba -d /apps/oracle
[root@OracleApps01 ~]# chmod g+w /apps/applmgr/
[root@OracleApps01 ~]# chmod g+w /apps/oracle/
[root@OracleApps01 ~]# ls -ld /apps/applmgr/ /apps/oracle/
drwx-w---- 4 applmgr dba 4096 Oct 11 11:22 /apps/applmgr/
drwx-w---- 4 oracle dba 4096 Oct 11 11:22 /apps/oracle/
[root@OracleApps01 ~]#

Set User Passwords -- Done

[root@OracleApps01 ~]# passwd oracle
[root@OracleApps01 ~]# passwd applmgr

--- Set to default pwds

[root@OracleApps01 ~]# uname -r
2.6.18-164.el5
[root@OracleApps01 ~]# uname -ms
Linux x86_64
[root@OracleApps01 ~]#

[root@OracleApps01 ~]# cp /etc/sysctl.conf /etc/sysctl.conf_Oct11
[root@OracleApps01 ~]# cp /etc/security/limits.conf /etc/security/limits.conf_Oct11
[root@OracleApps01 ~]#

Shared memory and semaphore setting -- Done

[root@OracleApps01 ~]# echo "kernel.shmmax=2147483648" >> /etc/sysctl.conf
[root@OracleApps01 ~]# echo "kernel.sem=250 32000 100 128" >> /etc/sysctl.conf
[root@OracleApps01 ~]# echo "fs.file-max=65536" >> /etc/sysctl.conf
[root@OracleApps01 ~]# echo "net.ipv4.ip_local_port_range = 2024 65000" >> /etc/sysctl.conf

Modify number of open descriptors -- Done

[root@OracleApps01 ~]# echo "hard nofile 65535" >> /etc/security/limits.conf
[root@OracleApps01 ~]# echo "soft nofile 4096" >> /etc/security/limits.conf

-- After I set the above kernal para's did sysctl –p or you can restart the server.

[root@OracleApps01 AdditionalPatches]# sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
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 = 4294967296
kernel.shmmax = 2147483648
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 2024 65000
[root@OracleApps01 AdditionalPatches]#


Entry in hosts file – Done

[root@OracleApps01 ~]# echo "10.20.1.82 OracleApps01.gisi.com OracleApps01">>/etc/hosts


--- Additional Patches/RMP's to apply

[root@OracleApps01 R12.1.1_64bit]# mkdir -p /stage/R12.1.1/AdditionalPatches
[root@OracleApps01 R12.1.1_64bit]# chmod 755 /stage/R12.1.1/AdditionalPatches

--- Here I kept all the required rpm's and additional patches required

- OS Lib Patch

p6078836_101330_LINUX.zip ( OS Library Patch for Oracle HTTP Server (on Oracle Linux 5 and RHEL 5 only) )

- RPM’s

compat-glibc-2.3.4-2.26.i386.rpm
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm
libXp-1.0.0-8.1.el5.i386.rpm
openmotif21-2.1.30-11.EL5.i386.rpm


As per Oracle recommendation

The following i386 packages must be installed from the OEL 5 or RHEL 5 distribution media:

•compat-glibc-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
•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

-- To check the installed packages rpm –qa|grep package-Name
-- To apply RPM rpm –Uvh rmp-name
-- Applied OS Lib Patch like this

OS Library Patch for Oracle HTTP Server (on OEL 5 and RHEL 5 only) --- Done

[root@OracleApps01 AdditionalPatches]# unzip p6078836_101330_LINUX.zip
Archive: p6078836_101330_LINUX.zip
creating: 6078836/
inflating: 6078836/libdb.so.2
inflating: 6078836/README.txt
[root@OracleApps01 AdditionalPatches]#
[root@OracleApps01 6078836]# mv /usr/lib/libdb.so.2 /usr/lib/libdb.so.2.6078836
mv: cannot stat `/usr/lib/libdb.so.2': No such file or directory
[root@OracleApps01 6078836]# cp libdb.so.2 /usr/lib
[root@OracleApps01 6078836]#

-- Link to Motif library for Oracle Application Server 10.1.2 (on Oracle Linux 5 and RHEL 5 only) -- Done

[root@OracleApps01 AdditionalPatches]# unlink /usr/lib/libXtst.so.6
[root@OracleApps01 6078836]# ln -s /usr/X11R6/lib/libXtst.so.6.1.0 /usr/lib/libXtst.so.6
[root@OracleApps01 6078836]#
[root@OracleApps01 6078836]# ls -l /usr/lib/libXtst.so.6
lrwxrwxrwx 1 root root 29 Oct 11 12:55 /usr/lib/libXtst.so.6 -> /usr/X11R6/lib/libXtst.so.6.1.0
[root@OracleApps01 6078836]#

[oracle@OracleApps01 ~]$ grep -i LD .bash_profile;id
LD_ASSUME_KERNEL =2.4.19
export LD_ASSUME_KERNEL
uid=501(oracle) gid=500(dba) groups=500(dba)
[oracle@OracleApps01 ~]$


============================================================
2) OS Preparation -- Done
============================================================

============================================================
3) Installation

Installation --- In Progress

-- in VNC

[root@OracleApps01 rapidwiz]# pwd
/stage/R12.1.1/Software/startCD/Disk1/rapidwiz
[root@OracleApps01 rapidwiz]#
[root@OracleApps01 rapidwiz]# xhost +
access control disabled, clients can connect from any host

[root@OracleApps01 rapidwiz]# ./rapidwiz


--- Port Pool taken – 0

--- Installation Completed

Environment File
-----------------

Database ORACLE_HOME environment file passes instantiated variables test:
File = /apps/oracle/db/tech_st/11.1.0/VIS_oracleapps01.env

Apps ORACLE_HOME environment file passes instantiated variables test:
File = /apps/applmgr/inst/apps/VIS_oracleapps01/ora/10.1.3/VIS_oracleapps01.env

iAS ORACLE_HOME environment file passes instantiated variables test:
File = /apps/applmgr/inst/apps/VIS_oracleapps01/ora/10.1.2/VIS_oracleapps01.env

APPL_TOP environment file passes instantiated variables test:
File = /apps/applmgr/apps/apps_st/appl/VIS_oracleapps01.env

ADOVARS environment file passes instantiated variables test:
File = /apps/applmgr/apps/apps_st/appl/admin/adovars.env

APPSCONFIG passes instantiated variables test:
File = /apps/applmgr/apps/apps_st/appl/admin/adconfig.txt

DBC File
---------

DBC file passes instantiated variables test:
File = /apps/applmgr/inst/apps/VIS_oracleapps01/appl/fnd/12.0.0/secure/VIS.dbc

HTTP
-----

checking URL = http://oracleapps01.gisi.com:8000
HTTP Listener is responding

Help Page
----------

checking URL = http://oracleapps01.gisi.com:8000/OA_HTML/help
Page is responding

Virtual Directory
------------------

checking URL = http://oracleapps01.gisi.com:8000/OA_MEDIA/FNDLOGOL.gif
Page is responding

checking URL = http://oracleapps01.gisi.com:8000/OA_JAVA/oracle/apps/fnd/admin/server/server.xml
Page is responding

checking URL = http://oracleapps01.gisi.com:8000/OA_CGI/FNDWRR.exe
Page is responding

JSP
----

checking URL = http://oracleapps01.gisi.com:8000/OA_HTML/jtfTestCookie.jsp
JSP is responding

Login Page
-----------

checking URL = http://oracleapps01.gisi.com:8000/OA_HTML/AppsLogin
Page is responding

Logs:

Configuration file written to: /apps/applmgr/inst/apps/VIS_oracleapps01/conf_VIS.txt
Configuration file written to: /apps/oracle/db/tech_st/11.1.0/appsutil/conf_VIS.txt
Database logfile - /apps/oracle/db/tech_st/11.1.0/appsutil/log/VIS_oracleapps01/10111442.log
Appltop logfile - /apps/applmgr/inst/apps/VIS_oracleapps01/logs/10111442.log

============================================================
3) Installation -- Completed
============================================================
============================================================
4) Post Issues & Fixes
============================================================
Settings to be done

Note: Below setting has to be made in your desktop to access the application front end.

In

C:\WINDOWS\system32\drivers\etc\hosts

Add entry

10.20.1.82 OracleApps01.gisi.com OracleApps01

Note:

If you are on IE 8 ( you may face “FRM-92050 failed to connect to Server /forms/servlet -1” while launching Forms )

Please do the setting mentioned in below link

http://focusthread.com/blog/oracletraining/funcional/frm-92050-failed-to-connect-to-server-formsservlet-1-applet-forms-not-opening-on-ie8/


Hope this helps all…

Please let me know if you have any queries.

Thanks,
Key + Run :-) Kiran

===================================================

Note : To apply RMP’s you can use this simple shell script ‘apply_rpms.sh’

[root@OracleApps01 Scripts]# cat apply_rpms.sh
for i in `cat /stage/R12.1.1/AdditionalPatches/rpms.apply`
do
cd /stage/R12.1.1/AdditionalPatches
rpm -Uvh $i
done

[root@OracleApps01 Scripts]# cat /stage/R12.1.1/AdditionalPatches/rpms.apply
compat-glibc-2.3.4-2.26.i386.rpm
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm
libXp-1.0.0-8.1.el5.i386.rpm
openmotif21-2.1.30-11.EL5.i386.rpm

Please let me knw any suggestion reg my post.