Oracle E-Business Suite (R12.2) Installation

By -

This post is a step-by-step for Installing Oracle E-business suite R12.2.0 on Oracle Enterprise Linux 7.5 (64-bit).

Pre-Installation Tasks

Software Requirement

·       Oracle Virtual Box

·       Oracle Enterprise Linux 7.5 (64-bit)

·       Oracle E-Business suite R12.2 for LinuxX86-64-bit

High Level Installation Steps

·       Hardware requirements.

·       Operating System pre-requisites.

·       Prepare Stage Area.

·       Install Oracle EBS R12.2 software.

·       Verify Installation

Download the Oracle E-Business Suite Software

Download the software from http://edelivery.oracle.com. It comes in zip format.


 

NETWORKING

Please add the below format foe the /etc/host file

<IP address>  <hostname>.<domainname>  <hostname>

HARDWARE REQUIREMENTS

It is recommended to use 4GB of memory for the database and 6GB for the application (0 -10 users). So, for a single node installation in PRODUCTION, a minimum of 10g RAM is recommended.

The table below shows the recommended hardware requirements based on the number of users.


OS User and Group Creation

# groupadd dba

# useradd -g dba oracle

# useradd -g dba applmgr

# passwd oracle

Directory Creation

# mkdir -p /u01/oracle

# mkdir -p /u01/applmgr

# chmod -R 775 /u01/*

# chown -R oracle:dba /u01/oracle

# chown -R applmgr:dba /u01/applmgr

RPM Installation:

The following packages must be installed from the Oracle Linux 7 distribution media on both the application and database tiers.

binutils-2.23.52.0.1-16.el7.x86_642

compat-libstdc++-33-3.2.3-71.el7.i686

gcc-4.8.2-16.el7.x86_64

gcc-c++-4.8.2-16.el7.x86_64

gdbm-1.10-8.el7.i686

gdbm-1.10-8.el7.x86_64

glibc-2.17-55.el7.i686

glibc-2.17-55.el7.x86_64

glibc-common-2.17-55.el7.x86_64

glibc-devel-2.17-55.el7.i686

glibc-devel-2.17-55.el7.x86_64

libgcc-4.8.2-16.el7.i686

libgcc-4.8.2-16.el7.x86_64

libstdc++-devel-4.8.2-16.el7.i686

libstdc++-devel-4.8.2-16.el7.x86_64

libstdc++-4.8.2-16.el7.i686

libstdc++-4.8.2-16.el7.x86_64

libXi-1.7.2-2.1.el7.i686

libXp-1.0.2-2.1.el7.i686

libXp-1.0.2-2.1.el7.x86_64

libXtst-1.2.2-2.1.el7.i686

libaio-0.3.109-12.el7.i686

libaio-0.3.109-12.el7.x86_64

libgomp-4.8.2-16.el7.x86_64

make-3.82-21.el7.x86_64

redhat-lsb-4.1-24.0.1.el7.x86_64

sysstat-10.1.5-4.el7.x86_64

util-linux-2.23.2-16.el7.x86_64

 

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

compat-libcap1-1.10-7.el7.x86_64

compat-libstdc++-33-3.2.3-71.el7.x86_64

elfutils-libelf-devel-0.158-3.el7.x86_64

libaio-devel-0.3.109-12.el7.i686

libaio-devel-0.3.109-12.el7.x86_64

xorg-x11-utils-7.5-13.1.el7.x86_64

 

If it is a multinode installation, the following packages must be installed manually on the application tier which are not part of the OS distribution media.

compat-libstdc++-296-2.96-144.0.2.el7.i686

openmotif21-2.1.30-11.EL7.i6861

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

 

Additionally, the following rpms need to be installed from the Oracle Linux 7 distribution media on the application tier.

libXrender-0.9.8-2.1.el7.i686

perl-File-CheckTree-4.42-3.el7.noarch

 

Check & compare each package using the following linux command.

If you find any of the package file is missing or the version is prior, compared to the mentioned packages then download the relevant packages accordingly.

# rpm -qa <PackageName>

To determine whether the required packages are installed, enter commands similar to the following.

# rpm -q <Package_Name>

YUM Installation

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

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

·       ksh

·       ld

·       linux32

·       make

·       X Display Server

We can use the “WHICH” command to test the above installed path

JAVA REQUIREMENTS

Oracle E-Business Suite delivers the following Java SE Development Kit (JDK) versions for use by the Oracle E-Business Suite

·       Java SE Development Kit (JDK) Version 6.0 on the application tier

·       Java SE Runtime Environment (JRE) Version 6.0 on the database tier (for AutoConfig)

KERNEL SETTINGS

Edit the /etc/sysctl.conf file to configure your kernel settings to the minimum values. After editing the file, restart the system to invoke the new settings.

kernel.semmsl =256

kernel.semmns =32000

kernel.semopm =100

kernel.semmni =142

kernel.shmall =2097152

kernel.shmmax =5368709120

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.ipv4.tcp_tw_recycle =0

net.core.rmem_default =262144

net.core.rmem_max =4194304

net.core.wmem_default =262144

net.core.wmem_max =262144

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.

# vi /etc/resolv.conf

options attempts:5

options timeout:15

VERIFYING HOST NAMES

1. vi /etc/hosts

2. vi /etc/sysconfig/network

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

4. vi /etc/security/limits.conf  - file and change the existing values for "hard" and "soft" parameters.

* hard nofile 65535

* soft nofile 4096

* hard nproc 16384

* soft nproc 2047


Create the oraInventory 

# cd /etc

# vi oraInst.loc

inventory_loc=/u01/oraInventory

inst_group=dba

 

PREPARING STAGE AREA

Download all required Parts

Unzip startCD for getting buildStage.sh

Execute bulildStage.sh script for creating Stage


Installation steps

PREPARING STAGE AREA

Download all required Parts

Unzip startCD for getting buildStage.sh

Execute bulildStage.sh script for creating Stage


Unzip startCD for getting buildStage.sh

Create directory for R12 Stage.

# mkdir Net_stage


unzip parts of StartCD in R12 Staging directory.

# unzip V100052-01_1of3.zip

# unzip V100052-01_2of3.zip

# unzip V100052-01_3of3.zip

After unzipping all three parts it will create directory startCD.

Execute bulildStage.sh script for creating Stage

This script will be located under “startCD > Disk1> rapidwiz > bin”

[root@dbtest ~]# cd /u01/startCD/Disk1/rapidwiz/bin







Place the location where the stage files has been installed.






Ensure the privileges to stage directory (755 or 775)

INSTALL ORACLE E-BUSINESS SUITE R12.2

# cd /u01/startCD/Disk1/rapidwiz

# ./rapidwiz







This is a new option in R12.2 that allows you to select different ports on two different file systems.


The RAC option was added in R12.2







Choose two different locations for the database and application file systems (New option R12.2)

Database File system      - /u01/oracle/PROD (DB Base Dir)

Application File system - /u01/apps (APPS Base Dir)


You can enter the required password for all listed users here. I've selected to use default password. (R12.2 is a new option).








The installation process has been successful.



CHECK THE INSTALLATION





Weblogic Console




 
EBS R12.2 Installation FAQ

Can you explain EBS Installation high level steps?

 

  • Down the software from the oracle e-delivery site.
  • Creating the staging area using buildStage.sh script.
  • Check the Disk,Memory size
  • Install the RPM Packages using  yum install oracle-ebs-server-R12-preinstall  -y
  • Check the kernel parameters
  • Create OS/User group for apps(applmgr)&DB(Oracle)
  • Install EBS R12.2.0 using rapidwiz tool.
  • Apply the latest AD&TXK patches
  • Upgrade the environmentR12.2.x to 12.2.11 or 12.2.12

 

Installation Phase

  • Install the oracle database software
  • Create the database using RMAN utlity
  • Install the application tech stack fs1&fs2 file system

 

What is difference between EBS Standard/Express install?

 

Express Install

It's using for demo purpose and its using one OS user for apps and DB

Very limited installation option is available

 

Standard Install

 

Its live production implementation its supporting multi user support

Multi user option is use full for segregate apps & dB tier one team monitoring the apps and another team monitoring the DB

 

 

Difference between fresh database/vision database?

 

Fresh Database

Default option is fresh database its production kind of environment. Its available only default configuration after installation functional team do the functionality setup

Ex:- GL,HR,etc

 

Vision Database

Its mainly using for demo activity. Vision database having some default set is available(Gl,HR)

Its consuming more disk space.

 

If you want to install 19c database in EBS which start CD version you will use?

 

How to check the startCD version?

 

cd /<Staging_Area>/startCD/DISK1/rapidwiz

./RapidWizVersion

 

Inside the stage area what is  EBSInstallMedia,TechInstallMedia and TechPatch folders?

 

EBSInstallMedia:

 

Application Database Install

Apps

Application 10.1.2 server oracle Home

 

TechInstallMedia

 

Database Software

Oracle http software(OHS)

Weblogic server 11g software

 

TechPatch

Database

Middle tier Patching

 

Buildstagr.sh file location?

 

/<Staging_Area>/startCD/DISK1/rapidwiz/bin

 

Rapidwiz file location?

 

/<Staging_Area>/startCD/DISK1/rapidwiz/

 

Installation log file location?

DB

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>.log

 

Apps

$INST_TOP/logs/<MMDDHHMM>.log

Comments

Post a Comment

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

By -
Normally we are getting concurrent program running longer and concurrent request not picking jobs, etc. those are very frequent issue we expected from development team. Collect below basis level of information to development team 1 Oracle seeded program/Custom program? 2 How much time it used earlier? 3 Is there any recent code change done in concurrent program? 4 Is this program fetching higher data compare to last run? 5 Does this job running any specific time/ It can be run any time? 6 Does this job fetching data using DB link? 7 Does the problem happen on both the test and production instance? Once asked above questions to development team in meanwhile we need to start basic sanity check in our environment. 1 Verify the status of the concurrent program Copy select REQUEST_ID,phase_code,status_code,ORACLE_SESSION_ID from apps.fnd_concurrent_requests where request_id=’1234567’; ...
Read more

How to run Gather Schema Statistics in R12.2

By -
Image
What is Gather Schema Statistics? Gather Schema Statistics program generates statistics that quantify the data distribution and storage characteristics of tables, columns, indexes, and partitions. The cost-based optimization (CBO)  uses these statistics to calculate the selectivity of prediction and to estimate the cost of each execution plan. Why Run the Gather Schema Statistics? When Data is update, insert, delete in table of user end Like (Technical User ,Finance User ,Ect) It become necessary to run the Gather Schema Statistics It’s recommended to Run GSS in Weekly Once or twice. How to run Gather Schema Statistics? Login application with sysadmin user Submit Request Window Navigate to: Concurrent > Requests Enter the parameters This can be run for specific schemas by specifying the schema name or enter ‘ALL’ to gather statistics for every schema in the database Submit the Gather Schema Statistics program Parameters: S...
Read more

How to compile forms in R12.2

By -
STEP 1--> Login to app server STEP 2--> Go to  directory $AU_TOP/forms?US STEP 3--> Move to ".fmb" file STEP 4--> Execute the below command to generate ".fmx" frmcmp_batch userid=apps/<apps_pwd> module=<form_name>.fmb output_file=<form_name>.fmx module_type=form batch=no compile_all=special (EX):-   frmcmp_batch userid=apps/apps module=JAINTAXT.fmb output_file=$JA_TOP/forms/US/JAINTAXT.fmx module_type=form batch=no compile_all= special (O/p):   Created form file /oracle/CLONE/apps/fs2/EBSapps/appl/ja/12.0.0/forms/US/ JAINTAXT.fmx Refer: R12: How to Compile a Form in Release 12 (Doc ID 1085928.1)
Read more