Oracle E-Business Suite Installation 12.2.6


Reference Document: Oracle E-Business Suite Installation and Upgrade Notes Release 12 ( 12.2 ) for Linux x86-64 ( Doc ID 1330701.1 )

Environment :

OS : OEL 605 64 BIT.

Prerequisites

Swap Space :

Recommended 16 GB or more.
To check available swap space : # grepSwapTotal  /proc/meminfo

Host file format

Verify that the   /etc/hosts file is formatted as follows:
127.0.0.1 localhost.localdomain localhost
[ip_addresss ]  [node_name].[domain_name]  [node_name]

Tip : Keep your hostname short, to avoid issues while creating the instance name ( EBS_web_SID_hostname), which should not be more than 30 char.

[ root@labDesktop] # cat  /etc/hosts
127.0.0.1    localhost localhost.localdomain localhost4 localhost4.localdomain4
::    localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.11 lab.oraclehub.com lab

Disable SELINUX and shutdown iptables, ip6tables services

[ root@labs] #   vim    /etc/selinux/config
( change SELINUX = enforcing to SELINUX = disabled )

[ root@labs] #   service iptables stop

[ root@labs] #   service ip6tables stop

[ root@labs] #   chkconfig ‐‐level 0123456 ip6tables off

[ root@labs] #   chkconfig ‐‐level 0123456 iptables off

Install the following package using Yum tool

binutils -2.20.51.0.2-5.20.e16.x86_64
compat – libstdc++-296-2.96-144.e16.i686
compat – libstdc++-33-3.2.3-69.e16.i686
      gcc-4.4.5-6.e16.x86_64
gcc-c++-4.4.5-6.e16.x86_64
      glibc-2.12-1.7.e16.i686 ( 32-bit )
      glibc-2.12-1.7.e16.x86_64
      glibc-common-2.12-1.7.e16.x86_64
      glibc-devel-2.12-1.7.e16.i686 ( 32-bit )
      glibc-devel-2.12-1.7.e16.x86_64
      libgcc-devel-4.4-13.e16.i686
      libgcc-devel-4.4-13.e16.x86_64
libstdc++-devel -4.4.4-13.e16.i686
libstdc++-devel -4.4.4-13.e16.x86_64
libstdc++-4.4.4-13.e16.i686
libstdc++-4.4.4-13.e16.x86_64
      libXi-1.3-3.e16.i686
      libXp-1.0-0-15.1.e16.i686
      libXp-1.0-0-15.1.e16.x86_64
      libXtst-1.0.99.2-3.e16.i686
      libaio-0.3-107-10.e16.i686
      libaio-0.3.107-10.e16.x86_64
      libgomp-4.4.4-13.e16.x86_64
      make-3.81-19.e16.x86_64
      gdbm-1.8.0-36.e16.i686
      gdbm-1.8.0-36.e16.x86_64
      redhat-lsb-4.0-3.0.1.e16.x86_64
      sysstat-9.0.4-11.e16.x86_64
      util-linux-ng-2.17.2-e16.x86_64

Additionally, the following RPMs are required for the database tier :

      compact-libcap1-1.10-1.x86_64
      compact-libstdc++-33-3.2.3-69.e16.x86_64
      elfutils-libelf-devel-0.148.1-e16.x86_64
      libaio-devel-0.3.107-10.e16.i686
      libaio-devel-0.3.107-10.e16.x86_64
      unixODBC-2.2.14-11.e16.i686
      unixODBC-devel-2.2.14-11.e16.i686
      xorg-x11-utils-7.4.-8.e16.x86_64

Install the preinstall rpms for EBS 12.2 and RDBMS 12C provided by oracle

yum install -y oracle-rdbms-server-12cR1-preinstall

yum install -y oracle-ebs-server-R12-preinstall

It performs the following tasks :

  • It downloads and installs all software package versions and dependencies required for installing E-Business Suite R12
  • Creates the users oracle and applmgr for use as owners of the database and application tires respectively, while setting hard and soft shell resource limits in   /etc/security/limits.conf for oracle Linux 5 and in   /etc/security/limits.d/oracle-ebs-server-R12-preinstall.conf for Oracle Linux 6 and 7
  • updating kernal parameters in   /etc/sysctl.conf to recommended values
  • sets DNS resolver paramerers in   /etc/resolv.conf to minimum recommended values
  • sets ' numa=off' in the kernal commandline
  • disables ' Transparent Huge Pages ( THP ) 'for Oracle Linux 6 and 7 if it is enabled

Install openmotif21-2.1.30 and xorg-x11-libs-compat

[root@lab  s]#  wgethttps: // oss.oracle.com/projects/compat-oracle/dist/files/Enterprise_Linux/xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpmhttps: // oss.oracle.com/projects/compat-oracle/dist/files/Enterprise_Linux/openmotif21-2.1.30-11.EL6.i686.rpm
[root@labs]#  rpm -Uvh openmotif21-2.1.30-11.EL6.i686.rpm  xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

Preparing….      ################ [100 % ]
1 : xorg-x11-libs-compat      ################ [50 % ]
2 : openmotif21.      ################ [100 % ]

Check all rpms

rpm –qa ––qf " % { n } – % { r }.% { arch } \ n " | grep openmotif21

rpm –qa ––qf " % { n } – % { r }.% { arch } \ n " | greplibgcc

After packages installation, unlink and create a new link for libXtst.so.6

[root@labs] #    unlink  /usr/lib/libXtst.so.6
[root@labs] #    ln  -s  /usr/X11R6/lib/libXtst.so.6
libXtst.so.6  libXtst.so.6.1
[root@labs] #    ln  -s  /usr/X11R6/lib/libXtst.so.6 /usr/lib/libXtst.so.6

Relink all symbolic libraries
[root@labs] #    ldconfig  –v

Maintenance tools

The following maintenance tools must be installed on all machines, and their locations specified both in the PATH of the account that runs Rapid Install and in the PATH of the accounts that will own the database tier and application tier file systems.

ar
gcc
        g++
ksh
ld
        linux32
        make
        X Display Server

Download the following files from edelivery.oracle.com required files for installation :
( Tip : search for oracle financials to find ebs media )

For Start CD

V100052‐01_1of3.zip
V100052‐01_2of3.zip
V100053‐01_3of3.zip

For Staring

V35802‐01.zip
V35803‐01_1of3.zip
V35803‐01_2of3.zip
V35803‐01_3of3.zip
V35804‐01_1of2.zip
V35804‐01_2of2.zip
V46095‐01_1of2.zip
V46095‐01_2of2.zip
V100059‐01_1of2.zip
V100059‐01_2of2.zip
V100060‐01_1of3.zip
V100060‐01_2of3.zip
V100060‐01_3of3.zip
V100053‐01_1of2.zip
V100053‐01_2of2.zip
V100054‐01.zip
V100055‐01.zip
V100056‐01.zip
V100057‐01.zip
V100058‐01.zip
V100061‐01.zip
V100102‐01.zip
V75792‐01.zip
V29856‐01.zip

Tip :

  • Use the download manager facility provided in the download page
  • Once downloaded, open each file with winrar and press Ctrl + T to test & verify the integrity of the downloaded file
  • If the files are downloaded in windows,copy it to the Linux VM.

Staging

R12.2 : How To Create the Stage In Preparation For Installation ( Doc ID 1596433.1 )

Tip

Create the Stage area only inside the linux.

[root@labbin] #    pwd  /u01/Stage122/startCD/Disk1/rapidwiz/bin

[root@labbin] #    . /buildStage.sh

g1

g2

g3

g4

g5

g6

g7

g8

g9

g10

g11

g12

g13

g14

Once Stage area creation completed, verify it using md5sum.
Download the digest file as per your startcd version and OS, using oracle note id :
      MD5 Checksums for R12.2 Rapid Install Media ( Doc ID 1505510.1 )
For us it is StartCD51-Linux_x86-64.txt. Copy it inside the Stage folder.

g15

[root@lab Stage122] #    md5sum  ‐‐check StartCD51 ‐Linux_x86‐64.txt > res.txt
If you get the following error :
: No such file or directoryier/17339725/p17339725_R12_LINUX.zip
: No such file or directoryier/12949905/p12949905_10105_LINUX.zip
md5sm : WARNING : 11716 of 11716 listed files could not be read

Install, dos2unix and convert the windows downloaded StartCD51‐Linux_x86‐64.txt to unix format.

[root@lab Stage122]    Yum -y install dos2unix.

Once installed convert the txt file in to unix format as shown below

[root@lab Stage122]    dos2unix StartCD51‐Linux_x86‐64.txt

Using the converted txt file, run the md5sum again.

[root@lab Stage122]#    md5sum  ‐‐check StartCD51‐Linux_x86‐64.txt > res.txt
( Now It should not return any error messages. )

Cross check the result file of md5sum
[root@lab Stage122]#    ps  ‐ef  |  grep FAILED res.txt
( Nothing found ). So Stage area verified successfully.

Create oraInventory file as shown below and provide appropriate privileges.

[oracle@labdatabase]$  cat  /etc/oraInst.loc
inventory_loc=/u01/app/oracle/oraInventory
inst_group=oinstall

Start EBS 12.2.6 installation

[root@labrapidwiz]#   pwd
/u01/Stage122/startCD/Disk1/rapidwiz
[root@labrapidwiz]#   ./rapidwiz

Rapid Install Wizard is validating your file system……
CMDDIR=/U01/Stage122/startCD/Disk1/rapidwiz
Rapid Install Wizard will now launch the Java Interface…

g16

g17

g18

g19

g20

g21

g22

g23

g24

g25

g26

g27

g28

g29

g30

g31

g32

Clean up Failed Oracle E-Business suite R12.2 Installation.

Oracle E-Business suite R12.2 has many pre-requisite steps for its Installation. If these per-requisites are not completed/missed before then there are chances that installation may fail. If the Installation is aborted by human or non humancause then also its considered as failed installation.

rapidwiz from oracle E-Business suite R12.2 doesn’t have ability to restart/resume the failed installation. What we need to do is to clear the failed Installation and start the new Installation from scratch.

To clear off the R12.2 installation files after failure.

1  ‐ Kill &stop all processes related to Application and Database

[root@oraerp1 ˜ ]# ps  ‐ef  |  grep  ‐c  applmgr
5
[root@oraerp1 ˜ ]# ps  ‐ef  |  grep  ‐c  oracle
26
[root@oraerp1 ˜ ]#
[root@oraerp1 rapidwiz ]#  kill  ‐9  2260  3570
[root@oraerp1 rapidwiz ]#ps  ‐ef  |  grepapplmgr
root 3491 3183 0 11:09 pts/1 00:00:00 grep ‐‐color=auto applmgr
root 25717 5364 0 07:41 pts/4 00:00:00 su ‐applmgr
applmgr 25718 25717 0 07:41 pts/4 00:00:00 ‐bash
[root@oraerp1 rapidwiz ]#

‐ If dbTier installation and configuration completed successfully then we should stop database and listener
[oracle@lab12.1.0]$ pwd
/u01/oracle/VIS/12.1.0
[oracle@lab12.1.0]$  .  VIS_lab.env
[oracle@lab12.1.0]$sqlplus / as sysdba

Shut immediate

[oracle@lab12.1.0]$ lsnrctl stop

2 ‐Delete top level directories for appsTier and dbTier

3 ‐ Clean up inventory and /tmp directory

[oracle@labVIS]$  cat /etc/oraInst.loc
inventory_loc=/u01/app/oracle/oraInventory
inst_group=oinstall
[oracle@labVIS]$  cd  /u01/app/oracle/oraInventory
[oracle@laboraInventory]$rm  ‐rf *

[oracle@laboraInventory]$ cd /tmp
[oracle@labtmp]$rm  ‐rf *

After you perform all these its is recommended to reboot the server once to clear up all actions. But it is not mandatory.

Startup Procedure

  • Login as db user =>su   ‐  oracle
  • Run the env file =>.   /u01/oracle/VIS/12.1.0/VIS_lab.env run
  • Start listener => lsnrctl start
  • Start db => sqlplus   /as sysdba
    • Startup
  • Login as apps user =>su   ‐  applmgr
  • Run the env file =>.   /u01/oracle/VIS/fs1/EBSapps/app1/APPSVIS_lab.env run
  • Start the appl tier=>.   /u01/oracle/VIS/fs1/inst/apps/VIS_lab/admin/scripts/adstrtal.sh   apps/apps
    supply the weblogic password when asked.

Shutdown Procedure

Login as apps user =>su  ‐ applmgr
Run the env file =>.  /u01/oracle/VIS/fs1/EBSapps/app1/APPSVIS_lab.env run
Stop the appl tier =>  /u01/oracle/VIS/fs1/inst/apps/VIS_lab/admin/scripts/adstpal.sh

  • Login as db user => su  ‐ oracle
  • Shut db => sqlplus /as sysdba
  • Shut normal
    Stop listener => lsnrctl stop

    Open the apps using the link
    http://lab.oraclehub.com:8000/OA_HTML/AppsLogin

    Default password : sysadmin / sysadmin

    g33

    Oaj2se.exe issue

    If you get the following error while opening the forms in mozillafirefox,

    g34

    Solution :

    [root@labDesktop] # ln‐s  /u01/oracle/VIS/12.1.0/jdk/jre/lib/amd64/libnpjp2.so  /usr/lib64/mozilla/plugins

    Error :

    g35

    Solution :

    1. Run the ALTER command against the APPS and APPLSYS users in sqlplus to change back to the old passwords :

    sql>ALTER USER APPLSYS IDENTIFIED BY XXX;

    sql>ALTER USER APPS IDENTIFIED BY XXX;

    2. Afterwards run FNDCPASS :

    FNDCPASS apps/  0  Y   system/SYSTEM APPLSYS
    Ex: $FNDCPASS apps/  0  Y   system/SYSTEM APPLSYS NEWPASSWORD

    Note: Changing the APPLSYS password automatically changes the APPS password to match as these two must always agree.