Tuesday, February 2, 2010

Installation Oracle Apps R12.0.4 on SUSE Linux Enterprise Server 9 - x86_64

Introduction
This document describes the installation for Oracle EBS R12.0.4 and includes information about:
1.Instructions for Installing this Release
2.List of all the configurations and access details
These instructions include information about:
1.System Requirements
2.Preparing for Installation
3.Pre-requisite Checks
4.Preparing the EBS R12 software for installation
5.Stage area creation
6.Installation using Rapidwiz
Oracle EBS R12 Architecture Introduction
This section describes the Oracle Applications architecture and some of the features that this architecture supports. The following topics are included:
• Overview
• The Desktop Tier
• The Application Tier
• The Database Tier
• The Oracle Applications Technology Layer
The Oracle Applications Architecture is a framework for multi-tiered, distributed computing that supports Oracle Applications products. In this model, various servers or services are distributed among three levels, or tiers.
A server (or services) is a process or group of processes that runs on a single machine and provides a particular functionality. For example, For example, Web services process
HTTP requests and Forms services process requests for activities related to Oracle Forms. The Concurrent Processing server supports data-intensive programs that run in the background.
Important: The term server, in the sense of a single process, is less appropriate in the Release 12 architecture. Where applicable, replacement terms such as services are used.
A tier is a logical grouping of services, potentially spread across more than one physical machine. The three-tier architecture that comprises an Oracle E-Business Suite installation is made up of the database tier, which supports and manages the Oracle database; the application tier, which supports and manages the various Applications components, and is sometimes known as the middle tier; and the desktop tier, which provides the user interface via an add-on component to a standard web browser.

Single node R12 Vision implementation was done in CESERP server, where the database tier and application tier are on the same node i.e. same machine - CESERP

System Requirement
Software Requirements
For release 12.0.4, Oracle EBS on Suse Linux 64 bit, download the software from Oracle E-delivery website located @ edelivery.oracle.com
1. Go to edelivery.oracle.com
2. Press Continue
3. Input Full Name, Company name, E-mail address, Select country
4. Tick two check boxes to accept Trial License and Export Licesnse Tems. Press Continue...
5. Select Product Pack as "E-Business Suite" , Select platform as "Linux Intel 64-bit" . Press "Go"
6. Select "Oracle E-Business Suite Applications Release 12.0.4 Media Pack for Linux x86-64-bit"
7. Press Continue
The following are other software requirements.
Install 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
Use the following command to check the operating system version:
$ uname -r
Required Patches and Packages

Apply patch 4198954 for installing RPM packages on OS

Note: - RPM's can be downloaded from www.rpm.pbone.net

Apply all the required Packages (RPM’s)

apply all RPM's
rpm -Uvh .rpm
&
Check the Package version
rpm -q .rpm

To check RPM is installed or not
Rpm –qa

Required RPM packages on Suse Linux x86_64 bit
binutils-2.15.90.0.1.1-32.10.x86_64.rpm
binutils-32bit-9-200505232206.x86_64.rpm
compat-2004.7.1-1.2.x86_64.rpm
compat-32bit-9-200407011229.x86_64.rpm
compat-sles8-1.3-93.3.x86_64.rpm
db-32bit-9-200407011229.x86_64.rpm
db1-32bit-9-200407011229.x86_64.rpm
gcc-3.3.3-43.41.x86_64.rpm
gcc-c++-3.3.3-43.41.x86_64.rpm
glibc-2.3.3-98.61.x86_64.rpm
glibc-32bit-9-200512100800.x86_64.rpm
glibc-devel-32bit-9-200512100801.x86_64.rpm
gnome-libs-1.4.1.7-671.1.x86_64.rpm
gnome-libs-32bit-9-200407011229.x86_64.rpm
gnome-libs-devel-1.4.1.7-671.1.x86_64.rpm
libaio-devel-32bit-9-200407011229.x86_64.rpm
libgcc-3.3.3-43.41.x86-64.rpm
libstdc++-3.3.3-43.41.x86_64.rpm
libstdc++-devel-3.3.3-43.41.x86_64.rpm
libstdc++-devel-32bit-9-200407011229.x86_64.rpm
linux32-1.0-341.1.x86_64.rpm
make-3.80-184.1.x86_64.rpm
pdksh-5.2.14-780.7.x86_64.rpm
sysstat-5.0.1-35.7.x86_64.rpm
XFree86-devel-32bit-9-200512021458.x86_64.rpm
xscreensaver-4.16-2.6.x86_64.rpm
openmotif21-libs-32-bit-9-200511172351.x86_64.rpm
libaio-0.3.102-1.2.x86_64.rpm
libaio-devel-32bit-9-200502241149.x86_64.rpm (32-bit)
libaio-32bit-9-200502241149.x86_64.rpm (32-bit)
libaio-devel-0.3.102-1.2.x86_64.rpm

For installing these packages run ldconfig –v located in /sbin


For Oracle Enterprise Linux 4.0 and Red Hat 4.0, the openmotif version must be 2.1.30, and the package name must be in the following format: openmotif21-2.1.30.xxx. For example, openmotif-2.2.3.10.RHEL4.5 is not supported.

JDK 5.0 Requirements
The JDK version included in Oracle Applications Release 12 is JDK 5.0.04. The latest JDK 5.0 fixes a memory leak issue found on JDK 5.0.04. See Using Latest Update of JDK 5.0 with Oracle E-Business Suite Release 12 (OracleMetaLink Doc ID: 384249.1) for instructions on how to deploy the latest update of JDK 5.0 with your Oracle Applications Release 12 environment..
The following are other requirements for on OS
ulimit Value Settings
Verify that the owner of the Oracle Application Server and Oracle Database server file systems have the following 'ulimit' values:
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 73728
virtual memory (kbytes, -v) unlimited
Use the following command to check the ulimit settings:
$ ulimit –a

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
Kernel Settings
Edit the /etc/sysctl.conf file to configure your kernel settings. following table lists the kernel settings for SUSE Linux Enterprise Server 9.0

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
65536
net.ipv4.ip_local_port_range
1024 65000
net.core.rmem_default
262144
net.core.rmem_max
262144
net.core.wmem_default
262144
net.core.wmem_max
disable_cap_mlock =
262144
1

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

Host Names Settings
Verify that the /etc/hosts file is formatted as follows:
127.0.0.1 Localhost.localdomain localhost

.


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

* Hard nofile 65535
* Soft nofile 4096
* Hard nproc 16384
* Soft nproc 2047.

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
Following setting to be done in /home/oracle/.profile file
umask 022
export LD_ASSUME_KERNEL=2.6.5-7.244-smp
export ORACLE_HOME=/u01/oracle/orar12/db/tech_st/10.2.0
export ORACLE_SID=PPLVIS
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
Preparing for Installation
R12 EBS software
User creation
Oracle – Oracle user for Vision install
Applmgr - Application user for Vision install
Provide appropriate permissions (provide chmod 777 to the software directory).
Install Unzip (if the Unix m/c doesn’t have one)
1.Login as root
2.mkdir
$ cd /home
$ mkdir applmgr
$ mkdir oracle

3.useradd -p -g -d
make two users oracle,applmgr

useradd applmgr –p applmgr -g dba -d /home/applmgr
useradd oracle –p oracle -g dba -d /home/oracle

change owner --- chown –R :
(for both users)

chown -R applmgr : dba applmgr
chown -R oracle : dba oracle
FTP the files to the UNIX server CESERP to the software location.
For Rapid Install you need to 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
Unzip utility for Linux server can be downloaded from the below url http://updates.oracle.com/unzips/unzips.html
Instructions to install UnZip on UNIX platforms
1.Download the file and transfer it to the UNIX machine in binary mode.
2.Uncompress the file:
% uncompress unzip_
3.Put the file in a directory that is included in your PATH, typically /usr/bin or
/usr/local/bin.
4.Make sure that the file has execution permissions set. If not, run:
% chmod 751 unzip_
5.To unzip a file using this executable, just run:
% unzip_os
Creation of stage area
Do the staging using adautostg.pl and choose the option1.

It will ask for the CD Distributions. Enter the Disks as per the Distribution.
If the Release 12 installation is performed with the Rapid Install wizard. Before Installing ensure you have the latest Rapid Install patch
For R12.0.4 latest rapid install patch is 6796703
unzip the patch, this will create a folder ( startCD ). Copy this folder and paste it in the Stage area i.e., Overwrite the existing ( startCD ).
Create a new directory stage12 under /software with 777 permissions.
oracle@CESERP:~/software $ls -la
total 20
drwxrwxrwx 7 oracle dba 1024 May 26 16:25 stage12
Unzip every 12.0 Rapid Install zip files you downloaded, in the top-level Stage12 directory that you created earlier:
After unzipping all the files, validate that the stage area has a top-level directory stage12, with subdirectories startCD, oraApps, oraDB, oraAS, and oraAppDB.
oracle@CESERP:~/software/stage12 $ls -la
drwxrwxrwx 7 root root 232 2008-05-29 15:40 oraDB
drwxrwxrwx 50 root root 1264 2008-05-29 15:59 oraAppDB
drwxrwxrwx 5 root root 184 2008-05-29 16:00 oraAS
drwxrwxrwx 11 root root 328 2008-05-29 16:02 oraApps
drwxrwxrwx 7 root root 360 2008-05-29 16:27 startCD


We are all set to start the EBS installation using Rapidwiz.

Oracle EBS R12 Installation using Rapidwiz
1.Logging in to the System as root
CESERP:~ # who -am
root + pts/0 Jun 4 11:07 . 15827 (192.168.0.25)
CESERP:~ # export DISPLAY=192.168.0.25:0
CESERP:~ # xclock
2.Checking X Windows Console



If you are not able to set X Windows Console. Installation can be done through
X manager software. Installation screen can be visible through this software in desktop.
3.Launching the rapidwiz tool for installing the Oracle EBS R12
cd /Stage/R12/startCD/Disk1/rapidwiz # ./rapidwiz


Vision Database Requirements


The Vision Demo database provides a sample set of transaction data for a fictitious
Company (Vision Corporation). It uses most Oracle Applications products and is
Configured for multi-node systems. It is installed with the UTF8 (universal) character set
To maximize the number of supported languages.
A-8 Oracle Applications Installation Guide: Using Rapid Install
The init.ora file for the database is in the $ORACLE_HOME/dbs directory, and is called
init.ora.
Note: The sizes shown in the table are approximate, and may vary from
Platform to platform.
Vision Demo Database Tablespaces

APPS_TS_ARCHIVE Tables that contain archived
purge-related data
APPS_TS_INTERFACE Interface and temporary data and
Indexes
APPS_TS_MEDIA Multimedia objects, such as text, video,
sound, graphics, and spatial data
APPS_TS_NOLOGGING Materialized views not used for
summary management and temporary objects
APPS_TS_QUEUES Advanced Queuing and dependent
tables and indexes

APPS_TS_SEED Reference and setup data and indexes
APPS_TS_SUMMARY Summary management objects, such as
materialized views, fact tables, and other objects that record summary
information
APPS_TS_TOOLS Tools tablespace
APPS_TS_TX_DATA Tables that contain transactional data.
APPS_TS_TX_IDX Indexes on transaction tables
APPS_UNDOTS1 Automatic Undo Management (AUM) table space. UNDO segments are identical to ROLLBACK segments when AUM is enabled

Tablespace Description

CTXSYS Oracle interMedia
PORTAL Single Sign-On SDK
ODM_DATA Oracle Data Mining
OWAPUB Oracle Application Server
SYNCSERVER Mobile Server
SYSTEM System tablespace used by the Oracle database
TEMP Temporary tablespace 2000
The Vision Demo database uses the Multiple Organizations feature. The following table shows the operating units in the database. Responsibilities connect to one of these
operating units.

Vision Demo Database Operating Units
Operating Unit Username/Password
Vision Operations APPS/APPS
Vision Corporation APPS/APPS
Vision Industries APPS/APPS
Vision Services APPS/APPS
Vision Project Manufacturing APPS/APPS
Vision ADB APPS/APPS

Welcome Page URL:

http://host.domain:8000


References:


Oracle Applications Release Notes Release 12 –Metalink Doc id: 405293.1
Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Linux (64-bit) -- Metalink Doc id: 416305.1
Release 12 New Installation –Metalink Doc id: 414701.1
R12 installation document Part No. B31295-05 (120oaig.pdf) lists "Disk Space Requirements"

No comments:

Post a Comment