Monday, June 6, 2016

EBS -- EBS 12.2.5 - 12C DB installation on Linux

In this blog post, we will see an example EBS 12.2 installation , which is done on a Linux x86-64 system.
The aim of this installation is to obtain an EBS 12.2.5 instance running on Oracle Linux 6 64-bit.
We will use the latest startCD, so we will have an 12C database in our newly installed EBS 12.2.5 instance. This document involves some post upgrade steps, which may be required or changed according to your needs. The underlying server system used for this installation is based on a single node server environment. However, the steps are quite similar in a multi node system.
The general overview of the process is to install Oracle Linux, install EBS 12.2.0 and upgrade it to EBS 12.2.5.  This blog post is a little different than my earlier post, as it will be like a compilation, but still it will give the valuable filtered information required for EBS 12.2. installations.
Please do not take the configuration values, licensed products as well as the post upgrade steps used in this document as the orders :), because they are only there for giving you the general explanation of the installation process, as they may vary according to your environments and needs.

Let 's see, how we do it.

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

1. Installation Linux 6.5

2. Installing rpms for EBS 12.2 and RDBMS 12C

[root@ermantest yum.repos.d]# wget http://public-yum.oracle.com/public-yum-ol6.repo

Note : use vi editor to open repo and change enable 0 to 1 for addon and latest repositery

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

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

3. Check all rpms

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

4. Run ldconfig –v command to relink all symbolic libraries

5. Disable selinux and shutdown iptables,ip6tables services also on run levels

vi /etc/selinux/config ( change SELINUX=enforcing to SELINUX=disabled )

service iptables stop

service ip6tables stop

chkconfig --level 0123456 ip6tables off

chkconfig --level 0123456 iptables off

6. Check kernel settings for the parameters are correctly set

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.

vi /etc/sysctl.conf

kernel.semmsl 256

kernel.semmns 32000

kernel.semopm 100

kernel.semmni 142

kernel.shmall 20971524

kernel.shmmax Half the size of the physical memory (in bytes), and at least 42949672952

kernel.shmmni 4096

kernel.msgmax 8192

kernel.msgmnb 65535

kernel.msgmni 2878

fs.file-max 6815744

fs.aio-max-nr 1048576

net.ipv4.ip_local_port_range 9000 65500

net.ipv4.tcp_tw_recycle 05

net.core.rmem_default 262144

net.core.rmem_max 4194304

net.core.wmem_default 262144

net.core.wmem_max 1048576

Note : Parameter kernel.sem = 250 32000 100 128 is changed to kernel.sem = 250 32000 100 142

7. Check Domain Name System (DNS) Resolver Parameters , it should be below

options attempts:5
options timeout:15

8. Verifying Host Names

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

127.0.0.1 localhost.localdomain localhost
[ip_address] [node_name].[domain_name] [node_name]

· Verify that the /etc/sysconfig/network file is formatted as follows:
HOSTNAME=[node_name].[domain_name]
or as follows:
HOSTNAME=[node_name]
NISDOMAIN=[domain_name]
· If the /etc/sysconfig/networking/profiles/default/network file exists, remove it.

· If you changed any files in the previous steps, restart the system

9. Modify ulimit settings in limits.conf
vi /etc/security/limits.conf

# oracle-rdbms-server-11gR2-preinstall setting for nofile soft limit is 1024
oracle soft nofile 4096
# oracle-rdbms-server-11gR2-preinstall setting for nofile hard limit is 65536
oracle hard nofile 65536
# oracle-rdbms-server-11gR2-preinstall setting for nproc soft limit is 2047
oracle soft nproc 2047
# oracle-rdbms-server-11gR2-preinstall setting for nproc hard limit is 16384
oracle hard nproc 16384
# oracle-rdbms-server-11gR2-preinstall setting for stack soft limit is 10240KB
oracle soft stack 10240
# oracle-rdbms-server-11gR2-preinstall setting for stack hard limit is 32768KB
oracle hard stack 32768

10. Download EBS Installation Packages, Oracle E-Business Suite (12.2.5)

V100052-01_1of3.zipOracle E-Business Suite Release 12.2.0 Rapid Install Start Here 725.3 MB
V100052-01_2of3.zipOracle E-Business Suite Release 12.2.0 Rapid Install Start Here 81.6 MB
V100052-01_3of3.zipOracle E-Business Suite Release 12.2.0 Rapid Install Start Here 97.3 MB
V100059-01_1of2.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 1 1007.0 MB
V100059-01_2of2.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 1 1.6 GB
V100060-01_1of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 1.6 GB
V100060-01_2of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 1.1 GB
V100060-01_3of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 1.0 GB
V100061-01.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Technology one-off Patches 839.9 MB
V100078-01.zipOracle E-Business Suite Release 12.2 Supplemental Documentation - REVIEW FIRST 21.6 MB
V100079-01.zipOracle E-Business Suite Release 12.2 Supplemental Media 603.2 MB
100102-01.zipOracle Database 12c Release 1 (12.1.0.2.0) EXAMPLES for Linux x86-64 476.1 MB
V77840-01_1of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 514.5 MB
V77840-01_2of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 527.6 MB
V77840-01_3of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 459.4 MB
V77840-01_4of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 530.4 MB
V77840-01_5of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 571.4 MB
V77840-01_6of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 554.9 MB
V77840-01_7of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 526.7 MB
V77840-01_8of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 596.3 MB
V77840-01_9of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 100.5 MB
V77972-01.zipOracle E-Business Suite Release 12.2.5 Documentation Library 730.2 MB

Oracle Database (12.1.0.2.0)

V46095-01_1of2.zipOracle Database 12c Release 1 (12.1.0.2.0) 1.6 GB
V46095-01_2of2.zipOracle Database 12c Release 1 (12.1.0.2.0) 967.5 MB

Oracle E-Business Suite (12.2.0)

V35802-01.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install AS10.1.2 711.6 MB
V35803-01_1of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 1.2 GB
V35803-01_2of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 1022.8 MB
V35803-01_3of3.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 1.3 GB
V35804-01_1of2.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 2 1.2 GB
V35804-01_2of2.zipOracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 2 1.6 GB

Oracle Web Tier (11.1.1.9.0)

V75792-01.zipOracle Fusion Middleware Web Tier Utilities 11g Patch Set 7 (11.1.1.9.0) for Linux x86-64 2.0 GB
Oracle WebLogic Server (10.3.6.0.0)
V29856-01.zipOracle WebLogic Server 11gR1 (10.3.6) Generic and Coherence 1018.5 MB

11. Create Stage

[root@ermantest EBS1225]# cd startCD/Disk1/rapidwiz/bin/

[root@ermantest bin]# ./buildStage.sh

Oracle E-Business Suite Rapid Install
Version 12.2.0

Press Enter to continue...
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:
……………..
Specify the directory containing the zipped installation media:
/ebssetupfiles/EBS1225/

File list:
/ebssetupfiles/EBS1225/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat
The following files are missing from /ebssetupfiles/EBS1225/.
Return to the Oracle Software Delivery Cloud and download them:
====================================================

Part number: V100053-01

Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 1
File name: V100053-01_1of2.zip
====================================================
Part number: V100053-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 1
File name: V100053-01_2of2.zip

====================================================

Part number: V100054-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 2
File name: V100054-01.zip
====================================================

Part number: V100055-01

Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 3
File name: V100055-01.zip

====================================================

Part number: V100056-01

Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 4
File name: V100056-01.zip

====================================================

Part number: V100057-01

Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 5
File name: V100057-01.zip

====================================================

Part number: V100058-01

Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 6
File name: V100058-01.zip

====================================================

WARNING: Some of the required zip files have not yet been downloaded. Do you want to continue, and obtain them later? (Y)/N

Y
Note that: During creation of stage , enter to continue couple of times

12. Start E-Business Installation / EBS 12.2.0 installation

[root@ermantest rapidwiz]# pwd

/ebssetupfiles/EBS1225/startCD/Disk1/rapidwiz
[root@ermantest rapidwiz]# ./rapidwiz

13. Now follow the screens















If we encounter some errors for database pre-install checks and/or for filesystems,  fix them as documented below ;

Open new terminal with root user and run xhost +
Database Pre-installchecks;
Create oraInst.loc file and point it to the inventory location, which can be ORACLE_BASE directory.
ORACLE_HOME==/u01/oracle/TEST/12.1.0
ORACLE_BASE==/u01/oracle/TEST
So the orainventory should be in ora base directory
[oracle@ermanrtest app]$ cat /etc/oraInst.loc 

inventory_loc=/u01/oracle/TEST/oraInventory
inst_group=dba
For filesystem check error ;
chmod –R 777 /u01   (or any appropriate file permissions)






After installation is completed we can connect to the EBS and check the version 12.2.0 and go for next step...




At this point, EBS 12.2.0 installation is complete, so we continue with the EBS 12.2.5 upgrade.

--PREPARING for 12.2.0 to 12.2.5 upgrade--

APPLYING TECHNOLOGY PATCHES FOR 12.2.0 Oracle E-Business Suite Release 12.2.5 Readme (Doc ID 1983050.1) Master Note

1. EBS Technology Codelevel Checker (ETCC) (Doc ID 1594274.1)

Note: This patch verifies the missing bugfixes which is not applied for db and middle tiers. You can apply the patches directly to the related component but I recommend you go for the next steps and crosscheck the output of the log with the table you will see in section 3.2

Download patch 17537119

Upload patch to DB and APP node

For DB Node :

mkdir –p $ORACLE_HOME/appsutil/etcc
copy all files in the patch to the directory “mkdir –p $ORACLE_HOME/appsutil/etcc”
cd $ORACLE_HOME/appsutil/etcc
./checkDBpatch.sh

For APP Node :

cd <patchdirectory>
./checkMTpatch.sh

2. Apply RDBMS (12.1.0.2) Patches

Note: Shutdown database before apply patches


Not included in any startCD
Linux x86-64

21841318

22098146

21286665

21967332
opatch rollback -id 18893947
21387964


3. After applying database patches, ensure the following additional tasks are performed:

Copy $APPL_TOP/admin/adgrants.sql to db node
sqlplus "/ as sysdba" @adgrants.sql apps
sqlplus "/ as sysdba" @$ORACLE_HOME/rdbms/admin/utlrp.sql

4. Apply Consolidated Seed Table Upgrade Patch (Required)

Note: If the Release 12.2.0 Vision or PROD instance (New Installation) was created using startCD 12.2.0.51 (Patch 22066363), you must apply Consolidated Seed Table Upgrade Patch 17204589:12.2.0 by merging with Patch 21900871:12.2.0 on the run file system using adop hotpatch mode.

sh $ADMIN_SCRIPTS_HOME/adstpall.sh “ kill -9 `ps -ef|grep applmgr | awk '{print $2}'` “
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

Note : copy patches to the patch_top directory “/app/oracle/PROD/fs_ne/EBSapps/patch “

adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes

5.   3.1 Path A — Upgrade and New Installation Customers. Run ETCC (1617461.1 )

Note: Applying the AD and TXK Delta 7 release update packs checks for the existence of the ETCC tables. Even if you already have all the required database patches installed, you must execute the latest version of ETCC on your database before proceeding to Section 3.

6. Technology Inventory Utility (Optional )

The Technology Inventory Utility generates a report that lists the installed technology stack components, as well as patches that have been applied. Any patches listed in this section that are not shown in the generated report must be installed. Refer to Oracle E-Business Suite Maintenance Guide for instructions on generating the technology report.

perl $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=apps321 -outfile=$APPLTMP/Report_Inventory.html

7. Apply Oracle Reports and Forms Patches ( 10.1.2.3.0 )

Note : Any configuration file changes suggested in post-install steps can be skipped, as those changes are controlled through technology stack templates initialized by AutoConfig. Any recommendation in any Forms patch readme to redeploy Forms ear file can be skipped as it is automatically deployed by Oracle E-Business Suite service control scripts before starting services. Please regenerate jars from adadmin after applying any of the forms patch, do not opt to force the regeneration of all JAR files. If the patch is being applied in the patch file system then ensure Online Patching prepare phase (adop phase=prepare) has completed successfully first before running adadmin. If the patch is being applied in the run file system, run adadmin after applying the patch

Note: The 10.1.2.3 distribution is 32-bit, even on 64-bit platforms. Download the available patch for your platform.

Linux x86-64
Not included in any startCD
21539521

Default Oracle Home path is already set to 10.1.2 directory but if you need to set or to be make sure use below command

export ORACLE_HOME=/u01/oracle/TEST/fs1/EBSapps/10.1.2
export PATH=$ORACLE_HOME/OPatch:$PATH
opatch lsinventory

[applmgr@ermantest~]$ opatch lsinventory

Oracle Home : /u01/oracle/TEST/fs1/EBSapps/10.1.2
Oracle Home Inventory : /u01/oracle/TEST/fs1/EBSapps/10.1.2/inventory
Central Inventory : /u01/oracle/TEST/oraInventory
from : /etc/oraInst.loc
OUI location : /u01/oracle/TEST/fs1/EBSapps/10.1.2/oui
OUI shared library : /u01/oracle/TEST/fs1/EBSapps/10.1.2/oui/lib/linux/liboraInstaller.so
Java location : /u01/oracle/TEST/fs1/EBSapps/10.1.2/jdk/jre/bin/java

Opatch apply
After apply patch
Run adadmin
Generate jar files ( dont use force )

8. Apply Oracle Home Patch (Version 10.1.0.5.0)

There is no patch to apply if you installed EBS with the latest startCD. Check “Table 3 - Patches and bug numbers for 10.1.0.5.0” in the document.

9. Apply patch for Oracle Fusion Middleware (FMW) webtier 11.1.1.9

Note: When obtaining patches listed in these tables, download and install the 64-bit version of the patches.

Linux x86-64
Not included in any startCD
22107540


Set the ORACLE_HOME environment variable to Webtier home and Opatch version should be 11.1.0.9.0 or higher

export ORACLE_HOME=/u01/oracle/TEST/fs1/FMW_Home/webtier

export PATH=$ORACLE_HOME/OPatch:$PATH
[applmgr@ermantest ContentsXML]$ opatch lsinventory

Oracle Interim Patch Installer version 11.1.0.12.9
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home : /u01/oracle/TEST/fs1/FMW_Home/webtier
Central Inventory : /u01/oracle/TEST/oraInventory
from : /u01/oracle/TEST/fs1/FMW_Home/webtier/oraInst.loc
OPatch version : 11.1.0.12.9
OUI version : 11.1.0.11.0
OPatch detects the Middleware Home as "/u01/oracle/TEST/fs1/FMW_Home"

Installed Top-level Products (1):
Oracle WebTier and Utilities CD 11.1.1.9.0
cd 22107540/
opatch apply -jre $ORACLE_HOME/jdk/jre

10. Apply patch for Oracle Fusion Middleware (FMW) oracle_common 11.1.1.9

Not included in any startCD
Linux x86-64
21366277
21628307


Set the ORACLE_HOME environment variable to oracle_common home and Opatch version should be 11.1.0.9.0 or higher

export ORACLE_HOME=/u01/oracle/TEST/fs1/FMW_Home/oracle_common
export PATH=$ORACLE_HOME/OPatch:$PATH
To be make sure for the oracle home is correctly set. Use opatch lsinventory command

cd <patchdirectory>
opatch apply

11. Apply patch for Oracle Weblogic Server 10.3.6.0

Footnote 1 - This is the 10.3.6.0.12 PSU. When applying a PSU all conflicting patches (including overlays and previous PSUs) would need to be removed. For a list of bug fixes included in this PSU, refer to My Oracle Support Knowledge Document 2030251.1, Oracle WebLogic Server Patch Set Update 10.3.6.0.12 Fixed Bugs List.

Footnote 2 - This overlay patch is specific to 10.3.6.0.12 PSU; apply the PSU Patch 20780171 then this overlay patch.

Footnote 3 - This patch is specific to the Windows Platform.

Footnote 4 - This Oracle WebLogic Server patch is required for Oracle Fusion Middleware 11.1.1.9.

Ensure you have applied R12.TXK.C.Delta.7 (Patch 20784380) and Patch 21846184.

Refer to My Oracle Support Knowledge Document 1617461.1, Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release.

Patch 21846184 includes TXK code that will enable Java Secure Socket Extension (JSSE) within Oracle E-Business Suite Release 12.2 when Oracle Fusion Middleware version is 11.1.1.9.

Follow the instructions in the patch readme, except for the last step (Step 6) in the post-install instructions.
Patch Installation Steps ;

· Copy content of this zip file with the exception of README file to your SmartUpdate cache directory ($FMW_HOME/utils/bsu/cache_dir by default)

· cd $FMW_HOME/utils/bsu

· you will see the oracle smart update interface and below of the screen displays the patches that needs to be apply

· Start to apply patches and follow their readme,footnotes.

· To apply patches, first you have to apply patch number 20780171 but you may have conflict warning with the previous patches which has older PSU patches like 10.3.6.0.7 because 20780171 patch number is PSU 10.3.6.0.12 patch

·we removed the below patches and then run ./checkMTpatch.sh

Y5AP,BLTG,1LRI,VKXF,2GYW,CW9T, FCX7

· According to the output we have to apply the below patches fort he PSU 10.3.6.0.12

12.2.0.51
13964737 (see Footnote 4)
YVDZ
13964737
Not included in any startCD
20780171 (see Footnote 1)
EJUW
20780171
13729611 (see Footnote 2)
L34G
13729611
17319481 (see Footnote 2)
N5FK
17319481
19687084 (see Footnote 2)
8FBW
19687084
22128205 (see Footnote 2)
GK5N
22128205,13337000, 21562338

12. Apply R12.TXK.C.Delta.7 patches


Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

· Run ETCC according to the section “3.1.1 Prerequisite.
· Source the run edition environment file.

. /u01/oracle/TEST/fs1/EBSapps/appl/APPSTEST_ermtest.env

sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start ( It is already started for upgrade patch )

· Start up only Weblogic AdminServer service on the run edition application tier file system

· Apply below patches
Unzip patches and run adgrants
Patch 20745242 (R12.AD.C.Delta.7)
Patch 22123818:R12.AD.C
Patch 20784380 (R12.TXK.C.Delta.7)
Patch 22363475:R12.TXK.C
Patch 22495069:R12.TXK.C

Note : Compare adgrants.sql versions with in the patch directory and $APPL_TOP/admin

vi 20745242/admin/adgrants.sql
vi $APPL_TOP/admin/adgrants.sql

sqlplus / as sysdba @/app/oracle/PROD/fs_ne/EBSapps/patch/20745242/admin/adgrants.sql apps

· Copy all patches to the $PATCH_TOP (/u01/oracle/TEST/fs_ne/EBSapps/patch )

adop phase=apply patches=20745242 hotpatch=yes
sqlplus / as sysdba @/app/oracle/PROD/fs_ne/EBSapps/patch/22123818/admin/adgrants.sql apps

run etcc on db and app nodes

adop phase=apply patches=22123818 hotpatch=yes
adop phase=apply patches=20784380,22363475,22495069 hotpatch=yes merge=yes

After applied the patch with merge parameter. ( applied Delta Patches ) you will see the env file in your system base directory

/u01/oracle/TEST
-rw-r--r-- 1 applmgr oinstall 6467 Mar 10 15:06 EBSapps.env

· Migrate Latest Code to Database Tier
On the Application Tier (as the APPLMGR user):
Run AutoConfig on the run file system.
. /u01/oracle/TEST/EBSapps.env run
cd ADMIN_SCRIPTS_HOME
adautocfg.sh

Create the appsutil.zip file in <INST_TOP>/admin/out.
perl $AD_TOP/bin/admkappsutil.pl
Copy appsutil.zip file to database $ORACLE_HOME

On the Database Tier (as the ORACLE user):
Source the environment variables for RDBMS ORACLE_HOME.
Uncompress appsutil.zip, under <RDBMS ORACLE_HOME>.
cd <ORACLE_HOME>
backup appsutil folder
unzip -o appsutil.zip
cp –pr appsutil_backup/jre appsutil/
perl adbldxml.pl ( there is no Context File in new appsutil directory so regenerate it )
Run AutoConfig on <RDBMS ORACLE_HOME>

13.   Restart app and DB

--UPGRADING EBS FROM 12.2.0 TO 12.2.5--

Oracle E-Business Suite Release 12.2.5 Readme (Doc ID 1983050.1) Section 7 and 8
Path A — Upgrade and New Installation Customers upgrading to Oracle E-Business Suite 12.2.5 Release Update Pack

14.  Source the run edition applications environment.
It is already set in .bash_profile

15. Stop Weblogic AdminServer and Node Manager services.

Applying the patch in downtime mode requires all application tier services to be down. Therefore, Weblogic AdminServer and Node Manager that were started previously when applying the latest Release Update Packs for AD and TXK for Release 12.2 need to be shut down.

sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop

16. Set the “optimizer_adaptive_features” database parameter to FALSE (required for Database version 12.1.0.2). 

sqlplus "/as sysdba"
alter system set optimizer_adaptive_features=false scope=both;

System altered.

show parameter optimizer_adaptive_features

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_adaptive_features boolean FALSE


17. Apply Oracle E-Business Suite 12.2.5 Release Update Pack Patch 19676458 on the run edition application environment, using downtime mode

cd $ADMIN_SCRIPTS_HOME
adstpall.sh apps/password
adop phase=apply apply_mode=downtime patches=19676458

Note : Restarting 12.2.5 patch fails with "ERRORMSG: Cannot identify any valid application tier nodes/ORA-01400: Cannot Insert NULL Into ("APPLSYS"."FND_NODES"."NODE_NAME")" (Doc ID 2112122.1)

18. Set the “optimizer_adaptive_features” database parameter to TRUE again

sqlplus "/as sysdba"
alter system set optimizer_adaptive_features=true scope=both;
System altered.

19. Start all Application tier services on the run file system.
sh $ADMIN_SCRIPTS_HOME/adstrtal.sh

20. Perform adop cleanup action.
adop phase=cleanup

21. Synchronize file systems
Synchronize the file systems using the command shown below. This action will copy the new run edition code and configuration to the other file system, to ensure that both file systems are in sync before applying patches using the regular adop cycle on the other file system.

adop phase=fs_clone

--POST UPGRADE STEPS--

22. Apply Oracle E-Business Suite Release 12.2.5 Online Help Patch 19676460 using adop hotpatch mode on the run file system.

adop phase=apply patches=19676460 hotpatch=yes
        

23. To apply NLS ( Turkish ) Language patch follow the instructions in correct order

· Activate the new language using the Oracle Applications Manager (OAM) License Manager.

· Maintain snapshot information

· Run the AD Administration utility to maintain multi-lingual tables from the Maintain Applications Database Entities menu.

· Log on to your Applications' administration node as the APPLMGR user and source the APPL_TOP environment file. If you are on Release 12.2.0 or above, make sure you are connected to the RUN edition. Use the manifest generation tool to generate a manifest file by executing the following command:

perl $AD_TOP/bin/adgennls.pl

The manifest generated from the tool is located at :
$APPL_TOP/admin/$TWO_TASK/out/adgennls.txt 

Request a translation sync path using "https://updates.oracle.com/TransSync"
Upload and apply patch with adop through an online patching cycle (prepare,apply,finalize,cutover,cleanup)

24. Apply Localizations patches and implement localizations if necessary.

At this point, we reached the end. That is our EBS 12.2.5 is ready for use. But, before I put an end to this blog post, I want to share some useful documents with you.
Following is a list of  document that may be useful according to your needs.

For NLS- >Oracle E-Business Suite NLS Release Notes, Release 12.2 (Doc ID 1314621.1)
For HR Legislative: DATAINSTALL AND HRGLOBAL APPLICATION: 12.2 SPECIFICS (Doc ID 1469456.1)
For Localization : Creating CLE Product & Applying Mandatory Patches for R12.2 EMEA Add-on Localizations (Doc ID 1628719.1) --optional
EMEA Add-on Localizations - Upgrade steps to 12.2 (Doc ID 1593750.1) --optional
For Turkish Localizations -> R12 EMEA Add-on Localizations - Turkey (Doc ID 472686.1)

44 comments :

  1. Awesome...Exactly what I was looking for . Thank you for great post.

    ReplyDelete
  2. Awesome Post Emran. God Bless You

    ReplyDelete
  3. Thanks for the awesome document. I am able to get the 12.2.5 running on OEL 6.7 following these steps.

    ReplyDelete
  4. great post, I was executing the same steps.

    ReplyDelete
  5. gracias! muy buen post

    ReplyDelete
  6. Hi Erman!
    I would like to apply on top of 12.2.5 Financials and SUpply Chain reccomended critical patches .. How do you search for them ? Patch Wizard ? I tried manual search in Metalink.. It just show 12.2 and not show is it applicable or not for 12.2.5. Any hints?
    Thanks,Linda

    ReplyDelete
  7. Hi Linda,

    Check this note: How to Find E-Business Suite Recommended Patches (Doc ID 1400757.1)

    I didnt try it yet, but I hope it will help you.

    ReplyDelete
  8. Also note that, there is no guarantee for RPC patches.
    For example: as for the Payables 12.2.X, at the moment, there are no available Recommended Patch Collection (RPC)

    Also, 2 facts for you:

    1)All patches available for versions 12.2 can be found on: My Oracle support > Patches & Updates > Select Product: Payable > Release: 12.2
    2)latest patch news: https://community.oracle.com/community/support/oracle_e-business_suite/e-business_patching

    ReplyDelete
  9. Good Document with Clear Steps. Keep sharing........... Thanks & Regards Venkatesh RK

    ReplyDelete
  10. Excellent doc with clear steps thanks Earman

    ReplyDelete
  11. Excellent i will follow this doc
    I have a question can we perform upgrade from 12.2.0 with startCD 46 to 12.2.5
    Might me we need to upgrade db 12c and fmw to 1119 or else use starCD 51 if i m wrong please correct me

    ReplyDelete
  12. Hi Misba,

    StartCDs are just for the installation. Initial installation.
    However the startCD version is also important for the upgrades, because using a higher version of startCD for the initial installation, will make your job easier during the upgrade.
    I mean afher 12.2.0 installation, you need to do the prereqs for the EBS 12.2.5 right?, so that prereqs will change according to your startCD version.
    That is, if you did the installation using an old version startCD, then you will have to do more preregs. FMW 11.1.1.7 upgrade for example.
    So the answer for your question is yes. you can perform upgrade from 12.2.0 (installed with startCD 46) to 12.2.5.

    As for the db; 12c is not a must.
    As for the FMW; currently -> Oracle E-Business Suite 12.2.5 Release Update Pack requires Fusion Middleware Technology Stack (FMW) 11.1.1.7 (11gR1 PS6) or higher.

    However, I recommend you to install EBS 12.2.0 using startCD 51. As I said earlier, It will ease your job.
    Also , versions below start CD 51 is not supported for the installation. So if you encounter any problem, Oracle support may say to you " use startCD 51".

    ReplyDelete
  13. Hi Erman,

    I was followed to article for oracle e-business suit 12.2 so when i upgrade 12.2.0 to 12.2.5 some issue will come

    2. Apply RDBMS (12.1.0.2) Patches

    Note: Shutdown database before apply patches


    Not included in any startCD
    Linux x86-64

    21841318

    22098146

    21286665

    21967332
    opatch rollback -id 18893947
    21387964


    already install database 12.1.2 why again apply these patches.

    ReplyDelete
    Replies
    1. You apply these patches on top of 12.1.0.2, because these patches are not included in any installation package.

      Delete
  14. when search this patch at oracle 21967332 lot of patches will come which patch i will choose.

    ReplyDelete
    Replies
    1. You will install the patch according to your environment.
      i.e For Linux intel 64 bit, you will insatall the patch for release 12.1.0.2.0 and platform Linux X86-64

      Delete
  15. What is the way to install 12.2.6. How do I know which files I have to down load from edelivary.

    ReplyDelete
  16. Check this link. It is already answered in my forum.

    http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/not-ablel-to-download-ebs-12-2-5-files-td1342.html

    In edelivery, choose Oracle Financial(EBS,FIN,Oracle E-Business Suite,ebusiness) , then choose Oracle EBS 12.2.6. (also choose your OS type)

    After this, you will see the files.
    Don't bother if the filenames are not like the ones documented in my blog post.
    This is normal, as now the latest release is EBS 12.2.6 and the files are new.

    What you will do is, download EBS 12.2.0 (all the installation files) + download EBS 12.2.6 (all the installation files), download Oracle Database 12c (all the installation files), download the relevant lanuage installation file + weblogic + webiter files + Oracle E-Business Suite (12.2.5).

    It seem there is bug there. Because, the files which is in EBS 12.2.5 category is needed for EBS 12.2.6 install as well.

    ReplyDelete
  17. Hi Emran,
    Thanks for your wonderful document.Need one clarification,WHen i am checking the edlivery for release pack update r12.2.5 i couldnt able to find the RUP's for 12.2.5.latest version 12.2.6 is available.can you confirm ?

    Ameer

    ReplyDelete
  18. Oracle Software Delivery Cloud
    Need Help?Contact Software Delivery Customer Service


    If more than one release is available, you may select an alternate release by clicking on the 'Select Alternate Release...' link.


    Download Queue
    Release
    Selected Item
    Applicable Terms & Restrictions
    Size
    Published Date
    Oracle E-Business Suite 12.2.6.0.0 for Linux x86-64, 115 files
    Select Alternate Release...
    Oracle Financials Oracle Standard Terms and Restrictions 85.6 GB Jan 30, 2017
    Oracle E-Business Suite (12.2.6), 13 files
    7.3 GB
    Oracle Database (12.1.0.2.0), 2 files
    2.5 GB
    Oracle E-Business Suite (12.2.0), 6 files
    7.1 GB
    Oracle E-Business Suite (12.2.5), 17 files
    24.7 GB
    Oracle E-Business Suite Languages (12.2.0.0.0), 36 files
    22.0 GB
    Oracle E-Business Suite Languages (12.2.6.0.0), 36 files
    11.4 GB
    Oracle E-Business Suite Mobile Application Archive (6.0), 2 files
    5.4 GB
    Oracle Mobile Maintenance for Oracle E-Business Suite Mobile Application Archive (1.6), 1 file
    2.3 GB
    Oracle Web Tier (11.1.1.9.0), 1 file
    2.0 GB
    Oracle WebLogic Server (10.3.6.0.0), 1 file
    1018.5 MB

    ReplyDelete
  19. Hi Emran,
    wonderful document!!

    I installed EBS 12.2.0 with startCD 47 then upgraded to EBS 12.2.3 successfully. Now i am having 11.2.0.3 DB along with 12.2.3 applications.

    Please suggest me the procedure to upgrade the DB from 11.2.0.3 to 11.2.0.4 (or) 12.1.0.2 so that i can later upgrade EBS 12.2.3 to 12.2.5.

    Thanks in Advance!!

    ReplyDelete
  20. Hi Mohammed,

    Follow Section 1 "Upgrading an R12 Database to Oracle Database 11g Release 2 (11.2.0)" of Oracle Support document named "Interoperability Notes E-Business Suite Release 12.2 with Database 11g Release 2 (Doc ID 1623879.1)".

    ReplyDelete
  21. Hi Ermar,

    Thanks for the document, this doc makes the 12.2.5 installation easy.

    I installed 12.2.5, I skipped step 11(Apply patch for Oracle Weblogic Server 10.3.6.0) but successfully upgraded to 12.2.5. I thought that it(step 11) is for security bug fixes, please correct me if i am wrong and suggest me that i need to complete the step 11 now.

    ReplyDelete
  22. The patch versions documented in this blog post belong to the time that this blog post is written.
    You need to read this blog post, but follow the oracle documentation while installing EBS.
    This blog post is written for showing you the way.
    So , the up-to-date patch versions should be gathered from Oracle support.
    Bytheway, you can't ignore anything during the installation. Prereq is prereq.

    Now, You should check : Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)
    Section 4.4: Oracle WebLogic Server 10.3.6.0 Patch and Bug Numbers
    Actually, check the document above entirely.

    You should apply the patches documented in 1594274.1.
    If you didn't yet, then you are lucky.
    You should apply the patches even if you are upgraded 12.2.5.

    In general the documentation you follow should start with EBS readme (EBS 12.2.5 readme in your case). The readme will direct you to all the necessary documents.

    -->
    apply the latest application tier technology patches documented in 'Section 4: Application Tier Technology Patches and Bug Numbers' of My Oracle Support Knowledge Document 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes.

    Note: Refer to My Oracle Support Knowledge Document 1355068.1, Oracle E-Business Suite 12.2 Patching Technology Components Guide for instructions on how to apply technology patches.' of My Oracle Support Knowledge Document 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes.

    ReplyDelete
  23. Hi Erman i successfully installed the 12.2.5 and now i want to upgrade it to 12.2.6
    can you please suggest me any docs(or) links. what patch set should i download and apply.
    Thanks in advance

    ReplyDelete
  24. This is very easy. Just follow the readme.
    Oracle E-Business Suite Release 12.2.6 Readme (Doc ID 2114016.1)

    ReplyDelete
    Replies
    1. This comment has been removed by the author.

      Delete
  25. Hi Erman! How long did it take for you to get that translation patch you requested ? 1-2 days ? Thx!

    ReplyDelete
  26. Hi, within the same day. Most of the times, in 2 hours.

    ReplyDelete
  27. Hi..
    I want upgrade R12.1.3 to R12.2.0.
    If any document

    ReplyDelete
  28. You can start with this note ->

    "Oracle® E-Business Suite Upgrade Guide Release 12.0 and 12.1 to 12.2 Part No. E48839-03"

    Link: https://docs.oracle.com/cd/E51111_01/current/acrobat/122upg12.pdf

    ReplyDelete
  29. Hi Erman,

    Unfortunately I deinstall the one I installed. It made it impossible for me to send you all that you asked me. I want to rerty it but can I use your installation steps?

    Lexy

    ReplyDelete
  30. Lexy,

    We were trucking your issue under the forum entry : http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Can-t-login-into-EBS12-2-browser-tp4690.html

    So you have already a forum entry for this.. Please, update that forum entry (don't make comments here)

    As for your question; read my blog to get the idea, to understand the process.. On the other hand; follow Oracle documents for doing the installation. they may be more up-to-date.

    ReplyDelete
  31. how to set this two parameters. i am facing issue while running rda report.
    it gives me kernel parameter semmni too small. kernel parameter semmns too small

    how to set this
    kernel.semmsl 256

    cat /proc/sys/kernel/sem
    250 32000 100 128

    Please advise thanks

    kernel.semmns 32000

    ReplyDelete
  32. SEMMSL defines the maximum number of System V IPC semaphores per identifier.
    It is the max number of semaphores per set.

    kernel.sem = SEMMSL SEMMNS SEMOPM SEMMNI

    Basically, the formula is "(max number of arrays)*(max semaphores per array)=(max semaphores system wide)."

    Your SEMMSL is 250 and you want to increase it to 256 , right?

    To set the values permanently in Linux, make sure the file "/etc/sysctl.conf" has the line.

    kernel.sem = SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value

    Edit the file using vi and save it..

    for example:

    kernel.sem = 256 32000 100 128

    and then activate the changes:

    # /sbin/sysctl -p /etc/sysctl.conf

    ReplyDelete
  33. note that, those semaphore values are "minimum" recommended values.
    In order to set these values properly, you need to know your database workload. Max number of connections and Max number of concurrent connections..

    ReplyDelete
  34. Hi Erman,

    I am a fresher starting to learn the oracle apps installation by myself. I read your blog. and i need a small clarity in the step 11.

    how i will get the startcd folder by unzipping which sipped file. Could you please let me know.

    ReplyDelete
  35. which oracle ebusiness suite 12.2 files should i copy to database server and app server

    ReplyDelete
  36. This one is awesome blog. Much thanks.
    Here is another solution: https://www.ssogen.com/oracle-ebs-sso-integrations/ 
    Kind regards,
    -Mikemiller.

    ReplyDelete
  37. I am facing error at db installation phase when rman is trying to restore the control files (restorerman1.sql)
    no autobackup found or specified handle
    My stage is NFS mounted and taken care of all mount point options.
    Kindly suggest further.

    ReplyDelete
  38. Hi, I am not getting Oracle E-Business Suite Release 12.2.5 Update Pack. is it obsolete or what. When I am trying to find I got Oracle E-Business Suite Release 12.2.8 Update Pack. Please help

    ReplyDelete
  39. Hi I got error at 12%, unable to rename the database in error log, May i know the issue.

    ReplyDelete

If you will ask a question, please don't comment here..

For your questions, please create an issue into my forum.

Forum Link: http://ermanarslan.blogspot.com.tr/p/forum.html

Register and create an issue in the related category.
I will support you from there.