Sunday, 19 January 2014

Oracle R12.1.3 Installation on OEL 6.4 64 bit

This document would give detailed practical steps to install R12111 on OEL 6.4 for testing purpose.

There is no direct installation of 12.1.3 , first you need to install R1211 and then need to apply R1213 MP or future MP(Maintenance Packs).

Its a two node install where Oracle RDBMS is on one node apps1 and all application services on other node apps2.You install Oracle Applications using Rapid Install utility (rapidwiz) using root user after creating two users like "oracle" for RDBMS and "applmgr" for application tech stack and need to keep the users under "dba" group , before installation starts.

Total space required for Vision Instance.

1) Stage area - 48 GB

2) Application tier
 INST_TOP - 250MB
 APPL_TOP - 22 GB
 COMMON_TOP - 4GB
 IAS_ORACLE_HOME (10.1.3 for web OJC4J) - 2.4GB
 ORACLE_HOME(10.1.2 for Forms,Report)  - 2.4GB
Total Application Space around 31 GB, but allocate at-least 40 GB.

On safer side allocate at-least 40 GB for future patching or requests out/log files.

2) DB Tier
 ORACLE_HOME (11.2.0.3 upgraded after install which comes with 11.1.0.7) - 6GB
 DATA files - 200 GB (Vision database)
Total db tier 206 GB.

On safer side allocate at-least 250 GB for future db growth.
--------------
Thus to install mimimum would be requiring at-least 240 GB.

Please try to keep data and application in separate file system and separate I/O.

---------------
[root@apps1 home]# du -sk StageR12/
48170892    StageR12/

2) Verify the /etc/hosts entries-----
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.244   apps1.dba.com apps1
192.168.1.245   apps2.dba.com apps2

-----------
Verify OS rpms and settings and make sure unzip utility version is correct.


1) RPM's list and sequence in which you need to install. Need to install it from the same media from which you installed the OS.

To check for rpm packages installation status, can use below command.

rpm -qa --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" | grep gcc
q = query
a = all
OR use below simple command.
rpm -qa | grep gcc


Only below two rpm's need to be downloaded from the Oracle site as below, You don't need to login to download them.

    openmotif21-2.1.30-11.EL6.i686 (32-bit)
    xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386 (32-bit)

http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/) for Oracle Linux 6 and installed manually:

Once you download above two Oracle specific rpms, you need to strictly follow below sequence or you would get error on dependencies. Please note below RPM's are of 32 bit, you would see 64 bit versions of them already installed, but you need to install 32 bit versions also.

libuuid-2.17.2-12.9.el6.i686.rpm
libSM-1.2.1-2.el6.i686.rpm
libICE-1.0.6-1.el6.i686.rpm
libXau-1.0.6-4.el6.i686.rpm
libxcb-1.8.1-1.el6.i686.rpm
libX11-1.5.0-4.el6.i686.rpm
libXext-1.3.1-2.el6.i686.rpm
libXp-1.0.0-15.1.el6.i686.rpm
libXt-1.1.3-1.el6.i686.rpm
openmotif21-2.1.30-11.EL6.i686.rpm
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm
libXi-1.6.1-3.el6.i686.rpm
libXtst-1.2.1-2.el6.i686.rpm
dos2unix-3.1-37.el6.x86_64.rpm

libtool-ltdl-2.2.6-15.5.el6.i686.rpm
ncurses-libs-5.7-3.20090208.el6.i686.rpm
ncurses-devel-5.7-3.20090208.el6.i686.rpm
readline-6.0-4.el6.i686.rpm
unixODBC-2.2.14-12.el6_3.i686.rpm
unixODBC-devel-2.2.14-12.el6_3.i686.rpm
unixODBC-devel-2.2.14-12.el6_3.x86_64.rpm
db4-4.7.25-17.el6.i686.rpm

-----
Create this softlink.

cd /usr/lib
ls -ltr libXtst.so*
ln -s /usr/X11R6/lib/libXtst.so.6 libXtst.so.6


Without installing above RPM's , you would recieve lots of error as like below.

[root@oravdba rapidwiz]# ./RapidWizVersion
Exception in thread "main" java.lang.UnsatisfiedLinkError: /disk2/1211_64linux/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary0(Unknown Source)
        at java.lang.ClassLoader.loadLibrary(Unknown Source)
        at java.lang.Runtime.load0(Unknown Source)
        at java.lang.System.load(Unknown Source)
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary0(Unknown Source)
        at java.lang.ClassLoader.loadLibrary(Unknown Source)
        at java.lang.Runtime.loadLibrary0(Unknown Source)
        at java.lang.System.loadLibrary(Unknown Source)
        at sun.security.action.LoadLibraryAction.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
        at sun.awt.DebugHelper.<clinit>(Unknown Source)
        at java.awt.Component.<clinit>(Unknown Source)

 2) Make sure unzip binary version is 5.50 before starting rapidwiz, by default version is 6.00 in OEL6.4, thus need to copy it from stage area to /usr/bin.
From root user
#which unzip
(Would give /usr/bin/unzip)
#unzip -
(Would give by default UnZip 6.00 of 20 April 2009, by Info-ZIP..)
#cd /usr/bin
#mv unzip unzip-ver6bkp

Copy the  unzip binary from the startCD
#cd /usr/bin
#cp  /StageR12/startCD/Disk1/rapidwiz/unzip .
Verify the unzip version
#unzip -v
(Should give UnZip 5.50 of 17 February 2002, by Info-ZIP...)

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

Create stage area directory structure as below.
Download R1211 media from  http://edelivery.oracle.com

For Rapid Install (rapidwiz) , please download all the zip files belonging to the following parts:

    Rapid Install Start Here
    Rapid Install RDBMS
    Rapid Install Databases
    Rapid Install Tools
    Rapid Install APPL_TOP


        #cd /downloadplaceofthezipfiles

        #unzip -d /home/StageR12 <ZipFile> 

 ------------------
1211 stage area size - 48 GB.

# du -sk StageR1211_64bit
48404992    StageR1211_64bit
# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.4 (Santiago)



1) Make sure stage area is not corrupt and size as below using md5sum

Do md5 checksum of the media as per DOC - 802195.1

As per this document you would be downloading the OS specific md5sum text file.
For Linux 64 , download > md5sum_Linux64.txt and md5sum_startCD_121113.txt
Follow below steps :-
[root@oravdba rapidwiz]# which md5sum
/usr/bin/md5sum

[root@oravdba 1211_64linux]# pwd
/disk2/1211_64linux
[root@oravdba 1211_64linux]# cp /disk2/md5-checksum-R12.1.1/md5sum_Linux64.txt .
[root@oravdba 1211_64linux]# cp /disk2/md5-checksum-R12.1.1/md5sum_startCD_121113.txt .

->Do md5sum check.

[root@oravdba 1211_64linux]# md5sum --check md5sum_Linux64.txt > md5sum_result_vij.txt

[root@oravdba 1211_64linux]# grep -i FAILED md5sum_result_vij.txt

No FAILED one, so media is good.
->Checking for md5sum_startCD_121113.txt
To avoid below error
--------------------------------
startCD/autorun.inf^M: FAILED open or read
startCD/component.label^M: FAILED open or read
startCD/Disk1/doc/1211concepts.pdf^M: FAILED open or read
startCD/Disk1/doc/1211install.pdf^M: FAILED open or read
----------------------------------
First do $dos2unix md5sum_startCD_121113.txt md5sum_startCD_121113.txt

[root@oravdba 1211_64linux]# dos2unix
bash: dos2unix: command not found
This is already been installed above rpm list, if missed install it.

->Install dos2unix-3.1-37.el6.x86_64.rpm

[root@oravdba 1211_64linux]# dos2unix md5sum_startCD_121113.txt md5sum_startCD_121113.txt
dos2unix: converting file md5sum_startCD_121113.txt to UNIX format ...
dos2unix: converting file md5sum_startCD_121113.txt to UNIX format ...


[root@oravdba 1211_64linux]# md5sum --check md5sum_startCD_121113.txt > md5sum_startCD_121113_vij1.txt

No FAILED..all well....

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

[root@apps1 StageR12]# pwd
/home/StageR12
[root@apps1 StageR12]# du -sk *
34066288    oraAppDB
7472932    oraApps
1562460    oraAS
3769848    oraDB
1299360    startCD

As a further check to verify the media you have is of 64 bit, go to any Disk1 and check the file disk.label
Example : cd /StageR12/oraDB/Disk1
vi disk.label
It should have something like below and confirm that its of 64 bit OS OS=LINUX_X86-64and not of 32 bit OS.
-------------
[General]

Label=Oracle Applications Rapid Install - RDBMS
Number=1
OS=LINUX_X86-64
------------
Make sure to have latest startCD patch installed , before starting the installation
Download the patch  p11072566_R12_GENERIC.zip from Oracle Support (old Metalink).
$cd /StageArea
Copy this patch zip file to this directory
$unzip -o p11072566_R12_GENERIC.zip

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

rapidwiz Version should be 12.1.1.13

[root@apps1 rapidwiz]# ./RapidWizVersion

Oracle Applications Rapid Install Wizard

Version 12.1.1.13
------------


SQL Shared Area - BIND MISMATCH