Techie Hub!! : Oracle EBS 12.2.5 installation

Oracle EBS 12.2.5 installation (Single Node)

The Rapidwiz Install Wizard is the only utility that supports the installation of Oracle E-Business Suite 12.2. An installation of the Oracle E-Business Suite should be planned appropriately to avoid any issues during the install phase. Incorrect configuration will lead to a failed installation and will cost time and resources.

Here are the Prerequisite which we need to follow before we go for Rapidwiz.

Note: I have used below configuration for Oracle Linux 5 x86-64 with 16 GB RAM.

Space Requirements

For 12.2.5 application fresh installation you need minimum 300 GB Space.

Stage and patch Area : 55 + 50 GB
Oracle Database (12.1.0.2): 90 DB (fresh DB - without sample schema)
Oracle application dual file system: 75 GB
Post this we need buffer space to make our application operational..

Software Requirements

Oracle EBS application 12.2 supports only 64 bit OS.

Operating System Name	Supported Version
Oracle Linux	5 - Update 5 or higher (64-bit)¹
Oracle Linux	6 - Update 1 or higher (64-bit)¹
Oracle Linux	7 - Update 0 or higher (64-bit)
Red Hat Enterprise Linux	5 - Update 5 or higher (64-bit)¹
Red Hat Enterprise Linux	6 - Update 1 or higher (64-bit)¹
Red Hat Enterprise Linux	7 - Update 0 or higher (64-bit)
SUSE Linux Enterprise Server	10 - SP2 or higher (64-bit)²
SUSE Linux Enterprise Server	11 - SP2 or higher (64-bit)

Software Tools Requirements

Make sure we have below tools.
Linux x86-64 -ar, gcc, g++, ld, ksh, make, X Display Server

Kernel Version

Minimum version of kernel parameter
Oracle Linux 5 2.6.18-194.0.0.0.3.EL5
In our case it was:
[root@ol5-r122-ebs1 ~]# uname -r
2.6.32-300.10.1.el5uek

Operating System Packages

Below are the list of all packages which we need to install for Oracle Linux 5 or RHEL 5

Note: Make sure you install openmotif packages as it is, not its upgraded versions. (for example, openmotif-2.2.3-10.RHEL4.5 is not supported).

openmotif21-2.1.30-11.EL5.i3861
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386

Additionally, the following rpm needs to be installed from the Oracle Linux 5 or RHEL 5 distribution media on the application tier:

libXrender-0.9.1-3.1.i386

If not using the pre-install rpm, the following packages must be installed from the Oracle Linux 5 or RHEL 5 distribution media on both application and database tiers:

compat-libstdc++-296-2.96-138.i386
compat-libstdc++-33-3.2.3-61.i386
gcc-4.1.2-48.el5.x86_64
gcc-c++-4.1.2-48.el5.x86_64
glibc-2.5-49.i686 (32-bit)
glibc-2.5-49.x86_64
glibc-common-2.5-49.x86_64
glibc-devel-2.5-49.i386 (32-bit)
glibc-devel-2.5-49.x86_64
libgcc-4.1.2-48.el5.i386
libgcc-4.1.2-48.el5.x86_64
libstdc++-devel-4.1.2-48.el5.i386
libstdc++-devel-4.1.2-48.el5.x86_64
libstdc++-4.1.2-48.el5.i386
libstdc++-4.1.2-48.el5.x86_64
libXi-1.0.1-4.el5_4.i386
libXp-1.0.0-8.1.el5.i386
libXp-1.0.0-8.1.el5.x86_64
libXtst-1.0.1-3.1.i386
libaio-0.3.106-5.i386
libaio-0.3.106-5.x86_64
libgomp-4.4.0-6.el5.x86_64
make-3.81-3.el5.x86_64
gdbm-1.8.0-26.2.1.i386
gdbm-1.8.0-26.2.1.x86_64
redhat-lsb-3.1-12.3.EL.0.2.x86_64
sysstat-7.0.2-3.el5.x86_64
util-linux-2.13-0.52.el5_4.1.x86_64

Additionally, the following RPMs are required for the database tier:(In our single node case we will install on the same server)

compat-libstdc++-33-3.2.3-61.x86_64
elfutils-libelf-0.137-3.el5.x86_64 (for startCD 50 or earlier)
elfutils-libelf-devel-0.137-3.el5.x86_64 (for startCD 50 or earlier)
elfutils-libelf-devel-static-0.137-3.el5.x86_64 (for startCD 50 or earlier)
libaio-devel-0.3.106-5.i386
libaio-devel-0.3.106-5.x86_64
unixODBC-2.2.11-7.1.i386
unixODBC-devel-2.2.11-7.1.i386

Alternatively on the database tier, users can install the following rpm (available via ULN on http://linux.oracle.com or the Oracle Public yum repository on http://public-yum.oracle.com) on Oracle Linux:

oracle-validated-1.1.0-15.el5.x86_64

The E-Business Suite Pre-Install RPM includes all the above required rpms and dependencies for running the application and database tiers on Oracle Linux - see the 'E-Business Suite Pre-Install RPM' section below for more details.

Update Kernel Paramater as below:

[root@ol5-r122-ebs1 ~] vi /etc/sysctl.conf

net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 2
net.ipv4.conf.default.accept_source_route = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
fs.file-max = 6815744
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb = 65536
kernel.sem = 250 32000 100 142
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.sysrq = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

vm.min_free_kbytes = 51200

Once after changes activate the changes: sysctl -p

Verify the Soft and Hard Shell Limits

[root@ol5-r122-ebs1 ~]# cat /etc/security/limits.conf
# Oracle-Validated setting for nofile soft limit is 131072
oracle soft nofile 4096
applmgr soft nofile 4096
# Oracle-Validated setting for nofile hard limit is 131072
oracle hard nofile 65536
applmgr hard nofile 65536
# Oracle-Validated setting for nproc soft limit is 131072
oracle soft nproc 2047
applmgr soft nproc 2047
# Oracle-Validated setting for nproc hard limit is 131072
oracle hard nproc 16384
applmgr hard nproc 16384
# Oracle-Validated setting for core soft limit is unlimited
oracle soft core unlimited
# Oracle-Validated setting for core hard limit is unlimited
oracle hard core unlimited
# Oracle-Validated setting for memlock soft limit is 50000000
oracle soft memlock 50000000
# Oracle-Validated setting for memlock hard limit is 50000000
oracle hard memlock 50000000
# oracle-ebs-server-R12-pre-install setting for stack soft limit is 10240KB
oracle soft stack 10240
applmgr soft stack 10240
# oracle-ebs-server-R12-pre-install setting for stack hard limit is 32768KB
oracle hard stack 32768
applmgr hard stack 32768

Verify System Configuration Files

The /etc/hosts file should be configured as listed with a loopback address and fully qualified domain name,and you should verify that the hostname and IP address is pinging.
[root@ol5-r122-ebs1 ~]# cat /etc/hosts
127.0.0.1 localhost.localdomain localhost
192.168.0.10 ol5-r122-ebs1.example.com ol5-r122-ebs1

Create Directories and Change Permissions and Ownership

[root@ol5-r122-ebs1 ~]# mkdir -p /u01/app/oracle
[root@ol5-r122-ebs1 ~]# mkdir -p /u01/app/EBSR12
[root@ol5-r122-ebs1 ~]# chmod -R 775 /u01/app/oracle
[root@ol5-r122-ebs1 ~]# chmod -R 775 /u01/app/EBSR12
[root@ol5-r122-ebs1 ~]# chown -R oracle:dba /u01/app/oracle
[root@ol5-r122-ebs1 ~]# chown -R applmgr:oinstall /u01/app/EBSR12

Create Inventory Dirs:

[root@ol5-r122-ebs1 ~]# cat /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall

[root@ol5-r122-ebs1 ~]# mkdir -p /u01/app/oraInventory

[root@ol5-r122-ebs1 ~]# chown -R oracle:dba /u01/app/oraInventory
[root@ol5-r122-ebs1 ~]# chmod -R 777 /u01/app/oraInventory

Preparing the Stage Area:

The stage area is where all software installation binaries will be placed. Usually the stage area will be a single directory location where all the software installation files are located
The software is available for download from the Oracle Software Delivery Cloud (http://edelivery.oracle.com ) under the E-Business Suite section.
Once after downloading the EBS software, unzip the start CD to any dir (/u01/app/StageR122/startCD/).

[root@ol5-r122-ebs1 bin]# cd /u01/app/StageR122/startCD/Disk1/rapidwiz/bin
[root@ol5-r122-ebs1 bin]# sh buildStage.sh
Build Stage Menu
------------------------------------------------------
1. Create new stage area
2. Copy patches to existing stage area
3. List files in TechPatches directory
4. Exit menu

Enter your choice [4]: 1

Rapid Install Platform Menu

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

1. Oracle Solaris SPARC (64-bit)

2. Linux x86 (64-bit)

3. IBM AIX on Power Systems (64-bit)

4. HP-UX Itanium

5. Exit Menu

Enter your choice [5]: 2

Running command:

/u01/app/StageR122/startCD/..............................................................

....................................................................rapidwiz/bin Linux_x64 Linux_x64

Specify the directory containing the zipped installation media:

Single-Node Installation

Make sure you set the DISPLAY variable:
[root@ol5-r122-ebs1 ~]#xclock (should return graphical clock)
Perform below if you still getting issue with clock.
[root@ol5-r122-ebs1 ~]# xhost +

[root@ol5-r122-ebs1 ~]# cd /u01/app/StageR122/startCD/Disk1/rapidwiz
[root@ol5-r122-ebs1 ~]#./rapidwiz

[Welcome Page] Main installation screen that will list the tech stack components that will install Oracle EBS.

[Wizard Operation] Here two options are available, Install and Upgrade. You are performing a Fresh installation here, so you should choose the Install option.

[Oracle Configuration Manager Details]Rapidwiz screen for configuring the Oracle Support credentials, which are required for Oracle Configuration Manager. If you have valid credentials and the server is connected to the Internet, then you should provide these details. Otherwise, you can skip this option and configure them after installation.

[Configuration Choice] This configuration screen has two options: “Create a new configuration” and “Load the following saved configuration.” If you are performing a Fresh install, then you should select the first option for creating a new configuration. “Load the following saved configuration” is required for multinode installations.

[Database Node] “Create a new configuration” will store all the provided configuration settings in a text file, and later it will save this information into a database during the database tier configuration phase. Choose the database type (Fresh or Vision) based on selecting “Vision demo database/Fresh database will be installed.” The Vision database option will install sample business data that can used for evaluating the product and performing Proof of concept (POC). The Fresh database option will not install any business data, and this is the only option that will used for a production implementation.

[Licensing Selection] Below image shows two options: Suite Licensing and Component Licensing . You have to choose an option based on your company’s license agreement. If your organization is entitled to use suite licensing, then by default Rapidwiz will register all products included in the application price bundle.
The Component Licensing option will allow you to choose individual components to license, and you
have to select components based on your organization’s license agreement.

[Licensing Page] Below Image shows display a list of licensed products; the products that are checked and grayed out are licensed as part of suite licensing. On this screen you can license additional products, but these additional products will not be part of the suite licensing bundle. You need to have a separate license for any additional products.

[Country-specific functionalities] This shows of all the available country-specific functionalities, and it will allow you to choose a country specific to your localization. Consider that a company is running in the United States, Australia, and Brazil. The localization rules and labor laws will be different across these countries, so this option will allow the application to accommodate other country-specific functionalities in Oracle E-Business Suite.

[Internationalization Settings] The Internationalization Settings allows you to add any additional language to your Oracle E-Business Suite installation. Based on other languages, you should choose the character set for the database and applications.
You should select the character set type carefully. It is difficult to change the character set after installation, and there are many restriction for character set conversion. For example, you can convert the character set from USASCII7 to AL32UTF8, but you cannot convert the character set from AL32UTF8 to USASCII7. AL32UTF8 supports almost all languages, so it’s recommended that you use AL32UTF8 if there is a chance of using more than two different languages.

[Primary Application Node] The Primary Applications Node configuration allows you to provide inputs for OS user, group, and directory locations for installation. It requires locations for Apps Base Dir and Apps Instance Dir.
Note : Rapidwiz will not allow you to select two different locations for the RUN and PATCH file systems. By default all application services will be enabled on the primary application tier node.

[The Application User Information] it allows you to configure all application superuser passwords. In earlier releases, the superuser password was configured by default, and you had to change these passwords as a post-install step. In my case i kept default password for all application products.

[Node Information] It summarizes the nodes that are used in the EBS installation topology.

[System Checks] Rapidwiz will perform the full pre-install checks that are required to be in place to avoid issues during the installation process. below is the illustration of the Rapidwiz pre-install checks.

[Pre install checks] The Validate System Configuration will perform the prerequisites checks for all the previously listed settings, and all these items should have green check mark to proceed with the installation. If there are any errors or warnings for any of this configuration, then you should fix them before proceeding with the installation.

[Component Installation Review] It list of technology stack components that Rapidwiz will install and the configuration of the language setting that Rapidwiz will perform.Proceed with Installation once you see everything looks okay.

[EBS installation is in progress] Rapidwiz will install different technology stack components in different stages. There are a total of eight steps for installation, and for a successful installation, all these steps should complete successfully.

[Post Installation checks] After all the installation steps are performed, Rapidwiz will perform the post-installation checks to validate the system configuration and services.

[Finish] With this, you are done with the single-node installation process, but you should perform the post-installation steps once the installation is completed.

Post-installation Steps for the Application:

Once after installation validate the file system..

NOTE:

EBS 12.2 is installed as the base release 12.2.0, which is not supported and required to be immediately upgraded to a supported patchset, currently we have 12.2.6 available.

We will Go for the upgrade from 12.2.0 to 12.2.5 in next section..

Link: Upgrade EBS 12.2.0 to 12.2.5

Techie Hub!!

Saturday, 8 April 2017

Oracle EBS 12.2.5 installation