MD120_R12Installation_Instructions Doc. Ref : MD120

02/11/2009

AIM

MD.120 Installation Instructions – R12.1 Install

National Factory for Glass Bottles (ERP) Project

Author : Venu Vishnumahanti

Creation Date : October 29, 2009

Last Updated : November 1, 2009

Document Ref : MD-120

Version : Ver 1A

Note:  Title, Subject, Last Updated Date, Reference Number, and Version are marked by a Word Bookmark so that they can be easily reproduced in the header and footer of documents. When you change any of these values, be careful not to accidentally delete the bookmark. You can make bookmarks visible by selecting Tools->Options…View and checking the Bookmarks option in the Show region.

Approvals:

Approver 1 / Mr. Prasanna Lal
Approver 2 / Mr. Satyanarayana Sarma
Approver 3 / Mr. Nazeeb

Note:  To add additional approval lines, press [Tab] from the last cell in the table above.

Copy Number _____

Note:  You can delete any elements of this cover page that you do not need for your document. For example, Copy Number is only required if this is a controlled document and you need to track each copy that you distribute.

Document Control

Change Record

Date / Author / Version / Change Reference /
29-Oct-2009 / Venu Vishnumahanti / Ver 1A / First version

Reviewers

Name / Position /
Mr. Prasanna Lal / Offshore Lead DBA
Mr. Satyanarayana Sarma / Project Manager

Distribution

Copy No. / Name / Location /
1  / Library Master / Project Library
2  / Project Manager

Note:  The copy numbers referenced above should be written into the Copy Number space on the cover of each distributed copy. If the document is not controlled, you can delete this table, the Note To Holders, and the Copy Number label from the cover page.

Note To Holders:

If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes.

If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.

Contents

Document Control 2

Contents 3

Introduction 4

1. Pre-Installation Steps 5

1.1. Space Requirements 5

1.2. Operating System Requirements 5

1.3. Required Packages 6

1.5. Kernel Settings 7

1.6. Domain Name System (DNS) Resolver Parameters 8

1.7. Verifying Host Names 8

1.8. Modifying the Number of Open File Descriptors 8

1.9. Oracle HTTP Server Patch (RHEL 5) 8

1.10 Link to Motif library for Oracle Application Server 10.1.2 (RHEL 5) 9

1.11. Create Operating System User accounts and starting vncserver 9

2. Installation Steps 9

3. HealthCheck of the Instance 21

Open and Closed Issues for this Deliverable 23

Open Issues 23

Closed Issues 23

Introduction

This document explains in detail all the steps required to install a R12.1.1 Oracle E-Business Suite with the standard Oracle database version. This is a Single node installation

Overviews of the major tasks that are performed as part of this activity are listed below.

1.  Stage the software

2.  Check for Operating System pre-requisites for R12.1.1

3.  Invoke Rapidwiz and follow the wizard instructions.

4.  Complete the installation and perform post Install tasks.

The following are the server details which are used for this installation.

Environment Name: VIS
Domain Name : erp.com
Database Node : vis
Application Node : vis

1.  Pre-Installation Steps

1.1.  Space Requirements

The following table lists down the space requirements for all the participating nodes in the environment.

Please note that this is only the space requirement specific to Oracle Applications and all other Operating system space requirements are not in scope of this document.

On vis.erp.com(10.0.0.4)

Node / Mount Points / Locations / Size / OS Owner/Group / NOTE /
Database Tier (vis) / / / /oravis / 220GB / oravis:dba / This is for Oracle Home & datafiles
Application Tier (vis) / / / /applvis / 40GB / applvis:dba / This is Application tier
Staging / /stage / /stage/R1211_software/StageR12 / 50GB / This is Stage of Oracle Apps R12
Temp / /tmp / /tmp / 5GB / root:root / This is used for temporary files

1.2.  Operating System Requirements

Operating System Name / Supported Version
RHEL (32 bit) / 5.3


1.3.  Required Packages

List of required packages with minimum required versions for RHEL5.3 (32-bit).

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 RHEL 5.3 and installed manually:

·  openmotif21-2.1.30-11.EL5.i386

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

·  binutils-2.17.50.0.6-9.0.1.i386

The following i386 packages must be installed from the 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-12
·  glibc-common-2.5-12
·  glibc-devel-2.5-12
·  libgcc-4.1.2-14.el5
·  libstdc++-devel-4.1.2-14.el5
·  libstdc++-4.1.2-14.el5
·  make-3.81-1.1
·  gdbm-1.8.0-26.2.1
·  libXp-1.0.0-8.1.el5
·  libaio-0.3.106-3.2
·  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
Additionally, the following RPMs are required for an 11gR1 Database (which is bundled with the 12.1.1 release) on the database tier:

·  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

1.4. Software Requirements

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++

·  ld

·  ksh

·  make

·  X Display Server

·  unzip

1.5. Kernel Settings

Edit the /etc/sysctl.conf file to configure your kernel settings. After editing the file, use the "sysctl -p" command or restart the system to invoke the new settings.

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

The following table lists the kernel settings for Red Hat Enterprise Linux AS/ES 5:

Parameter / Value
kernel.semmsl / 256*
kernel.semmns / 32000*
kernel.semopm / 100*
kernel.semmni / 142*
kernel.shmall / 2097152
kernel.shmmax / Half the size of the physical memory (in bytes), and at least 2147483648
kernel.shmmni / 4096
kernel.msgmax / 8192
kernel.msgmnb / 65535
kernel.msgmni / 2878
fs.file-max / 131072
net.ipv4.ip_local_port_range / 10000 65000**
net.core.rmem_default / 262144
net.core.rmem_max / 4194304
net.core.wmem_default / 262144
net.core.wmem_max / 262144

*: set using the following entry in the /etc/sysctl.conf file: kernel.sem = 256 32000 100 142
**: values recommended for the local port range may need to be adjusted according to the specific needs of the user's environment in order to avoid port conflicts.

1.6. 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

1.7. Verifying Host Names

Use the following to verify host name settings:

For Red Hat Enterprise Linux AS/ES 5:

·  Verify that the /etc/hosts file is formatted as follows:

127.0.0.1 localhost.localdomain localhost

10.0.0.4 vis.erp.com vis

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

HOSTNAME=vis.erp.com

·  If the /etc/sysconfig/networking/profiles/default/network file exists, remove it.

Note: If you changed any files in the previous steps, restart the system.

1.8. 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.

* hard nofile 65535

* soft nofile 4096

* hard nproc 16384

* soft nproc 2047

1.9. Oracle HTTP Server Patch (RHEL 5)

Download and apply the patch 6078836 from OracleMetaLink to fix an issue with the Oracle HTTP Server bundled with the E-Business Suite technology stack.
Downloaded the patch 6078836 from metalink and performed the steps as per readme of this patch.

Steps performed

As the super-user, copy libdb.so.2 to /usr/lib

#

# mv /usr/lib/libdb.so.2 /usr/lib/libdb.so.2.6078836 (if libdb.so.2 exist already in /usr/lib)

# cp libdb.so.2 /usr/lib

1.10 Link to Motif library for Oracle Application Server 10.1.2 (RHEL 5)

Perform the following command (as root on your system) to update a required link to a Motif library prior to relinking or patching the 10.1.2 Application Server Oracle Home:

# unlink /usr/lib/libXtst.so.6
# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

Without this updated link, you may see the following errors during a relink of the 10.1.2 Oracle Home:

/usr/lib/libXtst.so.6: undefined reference to `'
/usr/lib/libXtst.so.6: undefined reference to `'
/usr/lib/libXtst.so.6: undefined reference to `'

Since the ldconfig command overrides this link, the above link command (ln) will have to be re-issued after running the ldconfig command.

1.11. Create Operating System User accounts and starting vncserver

On the server, create the user group (dba) & user accounts for oracle database file system (oravis) and application file system (applvis).

2.  Installation Steps

2.1. Creating the Stage Area Directory

Follow these steps to set up a stage area installation:

1. Log in as the operating system user with sufficient privileges to mount, unmount, and eject the DVD. This user must also have write privileges to the stage area that you set up.

2. Insert the Start Here disk in the DVD-ROM drive.

3. Mount the DVD

# mount –t iso9660 /dev/cdrom /mnt/cdrom

4. Verify software version (perl).

You must have perl 5.0053 or higher installed, and it must be in your PATH. Use the following commands to identify the perl version and its location.

perl -v

If perl is not installed, you may download it from http://www.perl.com.

5. Run the adautostg.pl script.

# cd

# perl /mnt/cdrom/Disk1/rapidwiz/adautostg.pl

The stage script message informs you that you may either stage all the Rapid Install Components or selected components only.

5.1. Set up the stage area directory.

At the prompt for the stage directory, enter the name of the system top-level directory. The Rapid wizard StageR12 directory will be created in this path.

/stage/R1211_software/StageR12.

5.2. Indicate the components to be staged.

The script prompts you to choose the components that you want to stage:

1. Complete Oracle Apps Env (11g Database, 10.1.2, 10.1.3, APPL & COMM)

2. Database technology stack only (11g)

3. Database Only (Vision or Fresh)

4. Applications technology stack Only (10.1.2, 10.1.3)

5. APPL_TOP & COMMON_TOP Only

Choose 1 (the default), all the main components will be staged.

Creating the Stage Area

6. Insert the Rapid Install DVD.

Insert the relevant DVD, as required in the prompt. The system message lists the

files it has copied and their location in the stage area directory.

For unmount of DVD, use below command

# umount /mnt/cdrom

Stage Area Directory Structure

The stage area created by adautostg.pl looks like this: a top-level directory StageR12, with principal subdirectories startCD, oraApps, oraDB, oraAS, and oraAppDB.

The number of DVDs (and hence further subdirectories) varies from component to component.

2.2. Starting the Rapid Install

Once the Stage Directory is created, start Rapid Install in the X Manager session which is started as the root user

# cd /stage/R1211_software/StageR12/startCD/Disk1/rapidwiz

# ./rapidwiz

Below Welcome screen lists the components that are included in, or supported by, this release of Oracle Applications.

This Welcome screen shows the information about the components it is going to be install.

Click Next to continue.

Choose Install Oracle Applications Release 12.1.1 and click Next.

This action sets up a new, fully configured system, with Fresh/Vision Database.

Ignore this screen and click on Next to continue the Rapid Install run.

Choose Create a new configuration, then click Next to continue.

If you choose Create a new configuration, Rapid Install saves the configuration

Parameters you enter on the wizard screens in the Applications database, and in a

Configuration file (conf_VIS.txt), which is stored in your system temporary

Directory until the installation is completed.

Specify the port pool which is free and click next. We have selected port pool as 3.

Choose Vision Demo Database and enter the base locations where the Oracle Applications Database has to be implemented. Make sure that user has the read & write privileges on that file system.

Specify the primary Apps node information in the above screen. These are stored in cofig_VIS.txt file and will be used while installation is performed on that particular node.

Enable the services which need to be run on that particular Apps node. Enable all the services as we have only one node for all the application services.

In the Next screen System will perform Pre – Install checks like port availability, space requirements, etc…

Following screen will be displayed with all the Passes and Fails. If any fails, try to resolve them before going to next screen.

In Next screen it shows the components installation review

Rapid Install displays the following warning when you click Next. Click Yes to continue

Below screen shows the progress of installation

Above screen appears when installation is complete and it displays the post install checks. Check for any errors and resolve them before start using the applications.