This is a fresh install of EBS 12.2.6 in Linux machine using latest startCD 51. There are considerable changes done in this release and the details can be found in my previous posts.
Lets get started:
Oracle
E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux
x86-64 (Doc ID 1330701.1)
1. Installation of Linux
2. Installing rpms for EBS 12.2 and RDBMS 12C
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
R12.2: How To Create the
Stage In Preparation For Installation (Doc ID 1596433.1)
Check the
version of existing version of start CD:
[root@ebs1 rapidwiz]# ./RapidWizVersion
Oracle E-Business Suite Rapid Install Wizard
Version 12.2.0.51
(c) Copyright 2000-2011 Oracle Corporation. All rights reserved.
[root@ebs1 rapidwiz]#
Build the stage
[root@ebs1 bin]# sh buildStage.sh
Copyright (c) 2002, 2013 Oracle Corporation
Redwood Shores, California, USA
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:
/u01/stage/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java
-classpath /u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/java
oracle.apps.ad.rapidwiz.util.StageBuilder /u01/stage/startCD/Disk1/rapidwiz/bin
Linux_x64 Linux_x64
Specify the directory containing the zipped installation
media:
/u01/stage
File list:
/u01/stage/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat
The set of zip files is complete.
Unzip command is:
/u01/stage/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o
Press Enter to continue...
Archive:
/u01/stage/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip
extracting:
/u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14272383/p14272383_1036_Generic.zip
extracting:
/u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/20484781/p20484781_111190_Generic.zip
extracting:
/u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14577216/p14577216_101231_Generic.zip
extracting:
/u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/16241466/p16241466_10123_LINUX.zip
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]: 2
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
Directory /u01/stage/TechPatches
Stage Builder will now stage the one-off patches for
Linux_x64...
Press Enter to continue...
Press Enter to continue...
Archive:
/u01/stage/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip
Finished copying additional patches.
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]:4
Now, start the rapidwiz process.
cd /u01/stage/startCD/Disk1/rapidwiz
Now upgrade 12.2.0 to
12.2.6
Oracle
E-Business Suite Release 12.2.6 Readme (Doc ID 2114016.1)
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
CON_ID
----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 -
64bit Production
0
PL/SQL Release 12.1.0.2.0 - Production
0
CORE
12.1.0.2.0 Production
0
BANNER
--------------------------------------------------------------------------------
CON_ID
----------
TNS for Linux: Version 12.1.0.2.0 - Production
0
NLSRTL Version 12.1.0.2.0 - Production
0
SQL> select release_name from apps.fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.2.0
[applmgr@ebs1 appl]$ . ./PROD_ebs1.env run
[applmgr@ebs1 appl]$ echo $FILE_EDITION
run
[applmgr@ebs1 appl]$ pwd
/u01/r12/application/fs1/EBSapps/appl
[applmgr@ebs1 appl]$
EBS Technology Codelevel Checker(ETCC)--Doc ID 1594274.1)
In the database tier
created one directory /u01/r12/database/12.1.0/appsutil/etcc
[oracle@ebs1 etcc]$ pwd
/u01/r12/database/12.1.0/appsutil/etcc
[oracle@ebs1 etcc]$ ./checkDBpatch.sh
+===============================================================+
| Copyright (c) 2005, 2016 Oracle and/or its
affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release
12.2 |
| Database EBS Technology Codelevel
Checker |
+===============================================================+
Using context file from currently set database environment:
/u01/r12/database/12.1.0/appsutil/PROD_ebs1.xml
Starting Database EBS Technology Codelevel Checker, Version
120.40
Tue Jan 24 01:08:48 EST 2017
Log file for this session : ./checkDBpatch_20236.log
Bugfix XML file version: 120.0.12020000.33
This file will be used for identifying missing bugfixes.
Mapping XML file version: 120.0.12020000.6
This file will be used for mapping bugfixes to patches.
[WARNING] DB-ETCC: Bugfix XML file
(./txk_R1220_DB_base_bugs.xml) in current directory is more than 30 days old.
Check if a newer
version is available in patch 17537119.
Identifying database release.
Database release set to 12.1.0.2.
Connecting to database.
PATCH RECOMMENDATION SUMMARY
===============================================================================
The default patch recommendations to install these missing
bugfixes are:
-------------------------------------------------------------------------------
Oracle Database Release 12.1.0.2 (No PSU applied)
-------------------------------------------------------------------------------
Patch 23595848
- Filename:
p23595848_121020_Linux-x86-64.zip
Patch 18793246
- Filename:
p18793246_121020_Generic.zip
Patch 23745950
- Filename:
p23745950_121020_Linux-x86-64.zip
Patch 19591608
- Filename:
p19591608_121020_Linux-x86-64.zip
Patch 19908836
- Filename:
p19908836_121020_Linux-x86-64.zip
Patch 24481723
- Filename:
p24481723_121020_Linux-x86-64.zip
Patch 22098146
- Filename:
p22098146_121020_Linux-x86-64.zip
Patch 21286665
- Filename:
p21286665_121020_Linux-x86-64.zip
Patch 21321429
- Filename:
p21321429_121020_Generic.zip
Patch 21387964
- Filename:
p21387964_121020_Linux-x86-64.zip
Patch 21864513
- Filename:
p21864513_121020_Linux-x86-64.zip
Patch 21904072
- Filename:
p21904072_121020_Linux-x86-64.zip
Patch 21967332
- Filename:
p21967332_121020_Linux-x86-64.zip
Patch 22338374
- Filename:
p22338374_121020_Linux-x86-64.zip
Patch 22496904
- Filename:
p22496904_121020_Linux-x86-64.zip
Patch 22731026
- Filename: p22731026_121020_Generic.zip
Patch 23089357
- Filename:
p23089357_121020_Linux-x86-64.zip
Apply the required patches and rerun this script
You should check the patch READMEs for minimum opatch
version requirements.
The latest opatch is available from My Oracle Support via
Patch 6880880.
+-----------------------------------------------------------------------------+
A consolidated zip file with the required patches for
Database Release
12.1.0.2.0 is available on My Oracle Support via:
Patch 24658746
[12.1.0.2.0 version]
- EBS RELEASE 12.2
CONSOLIDATED DATABASE FIXES FOR 161018 AND 160719
Note: This zip does not include any database bundle patches
or PSUs.
+-----------------------------------------------------------------------------+
See Doc ID 1594274.1 for any special instructions for these
patches.
Note: Footnotes in Doc ID 1594274.1 also apply to
corresponding overlay patches.
Stored Technology Codelevel Checker results in the database
PROD successfully.
Finished prerequisite patch testing : Tue Jan 24 01:10:06
EST 2017
Log file for this session: ./checkDBpatch_20236.log
===============================================================================
[applmgr@ebs1 patches]$ pwd
/u01/patches
[applmgr@ebs1 patches]$ sh checkMTpatch.sh
+===============================================================+
| Copyright (c) 2005, 2016 Oracle and/or its
affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release
12.2 |
| Middle Tier Technology Codelevel
Checker |
+===============================================================+
Using context file from currently set applications
environment:
/u01/r12/application/fs1/inst/apps/PROD_ebs1/appl/admin/PROD_ebs1.xml
Starting Middle Tier Technology Codelevel Checker, Version:
120.0.12020000.30.
Tue Jan 24 01:18:56 EST 2017
Log file for this session:
/u01/patches/checkMTpatch_22029.log
Bugfix XML file version: 120.0.12020000.27
This file will be used for identifying missing bugfixes.
Mapping XML file version: 120.0.12020000.12
This file will be used for mapping bugfixes to patches.
Checking for prerequisite bugfixes in File Edition: run
Enter the password for the APPS user:
Connecting to database.
Database connection successful.
The installed AD.C codelevel does not support storing the
results in the database.
===============================================================================
Oracle Forms and Reports
===============================================================================
Now examining product Oracle Forms and Reports.
Oracle Home = /u01/r12/application/fs1/EBSapps/10.1.2.
Product version = 10.1.2.3.0.
Checking required bugfixes for Oracle Forms and Reports
10.1.2.3.0.
Missing Bugfix:
17353142 -> Patch 22698265
Missing Bugfix:
20643256 -> Patch 22698265
Missing Bugfix:
16041055 -> Patch 22698265
Missing Bugfix:
16910762 -> Patch 22698265
Missing Bugfix:
20270659 -> Patch 22698265
Missing Bugfix:
17372642 -> Patch 22698265
Missing Bugfix:
17566694 -> Patch 22698265
Missing Bugfix:
20240480 -> Patch 22698265
Missing Bugfix:
19304738 -> Patch 22698265
Missing Bugfix:
20391574 -> Patch 22698265
Missing Bugfix:
22351071 -> Patch 22698265
Missing Bugfix: 21024122 ->
Patch 22698265
Missing Bugfix:
19588847 -> Patch 22698265
The above list shows missing bugfixes for Oracle Forms and
Reports.
Checking required bugfixes for RSF within Forms 10.1.0.5.0.
All required bugfixes are present for RSF within Forms.
===============================================================================
Oracle Fusion Middleware (FMW) - Web Tier
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - Web
Tier.
Oracle Home = /u01/r12/application/fs1/FMW_Home/webtier.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.
Missing Bugfix:
21300463 -> Patch 22288381
Missing Bugfix:
21892015 -> Patch 22288381
The above list shows missing bugfixes for FMW - Web Tier.
Checking required bugfixes for RSF within FMW Web tier
11.1.0.7.0.
All required bugfixes are present for RSF within FMW Web
tier.
===============================================================================
Oracle Fusion Middleware (FMW) - oracle_common
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) -
oracle_common.
Oracle Home = /u01/r12/application/fs1/FMW_Home/oracle_common.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - oracle common
11.1.1.9.0.
Missing Bugfix:
9905685 -> Patch 9905685
Missing Bugfix:
21366277 -> Patch 21366277
Missing Bugfix:
21628307 -> Patch 21628307
The above list shows missing bugfixes for FMW - oracle
common.
===============================================================================
Oracle WebLogic Server (WLS)
===============================================================================
Now examining product Oracle WebLogic Server (WLS).
Oracle Home =
/u01/r12/application/fs1/FMW_Home/wlserver_10.3.
Product Version = 10.3.6.0.7
Note that for Oracle WebLogic Server, patches rather than
bugfixes are verified.
Checking required patches for Oracle WebLogic Server (WLS)
10.3.6.0.7.
Missing Patch ID:
20780171
Missing Patch ID:
22323006
The above list shows missing patches for Oracle WebLogic
Server.
If you have applied other Oracle WebLogic Server patches,
they may have included the bugfixes needed.
Contact Oracle Support if you require assistance in
determining whether this is the case.
===============================================================================
Generating Patch Recommendation Summary.
===============================================================================
PATCH RECOMMENDATION SUMMARY
===============================================================================
One or more products have bugfixes missing.
The default patch recommendations to install these missing
bugfixes are:
-------------------------------------------------------------------------------
Oracle Forms and Reports 10.1.2.3.0
-------------------------------------------------------------------------------
Patch 22698265
- Filename:
p22698265_101232_LINUX.zip
-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0
-------------------------------------------------------------------------------
Patch 22288381
- Filename:
p22288381_111190_Generic.zip
-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0
-------------------------------------------------------------------------------
Patch 9905685
- Filename:
p9905685_111190_Generic.zip
Patch 21366277
- Filename:
p21366277_111190_Generic.zip
Patch 21628307
- Filename:
p21628307_111190_Generic.zip
-------------------------------------------------------------------------------
Oracle WebLogic Server (WLS) 10.3.6.0.7
-------------------------------------------------------------------------------
Patch 20780171 [SU
Patch [EJUW]: WLS PSU 10.3.6.0.12]
- Filename:
p20780171_1036_Generic.zip
Patch 22323006 [SU
Patch [DI8E]]
- Filename:
p22323006_1036_Generic.zip
Apply the required patches and rerun this script.
+-----------------------------------------------------------------------------+
A consolidated zip file with the required middle tier patches
is available on
My Oracle Support via:
Patch 24658753
- EBS RELEASE 12.2
CONSOLIDATED FMW FIXES FOR 161018 AND 160719
+-----------------------------------------------------------------------------+
[WARNING] Patch
20780171 [SU Patch [EJUW]: WLS PSU 10.3.6.0.12] is missing.
This is the recommended minimum WLS patch set.
You should install it now, and then rerun this script to
check for any
further fixes available.
+-----------------------------------------------------------------------------+
See Doc ID 1594274.1 for any special instructions regarding
these patches.
Footnotes in Doc ID 1594274.1 also apply to corresponding
overlay patches.
Finished checking prerequisite patches for File Edition:
run.
Tue Jan 24 01:20:24 EST 2017
Log file for this session:
/u01/patches/checkMTpatch_22029.log
===============================================================================
[applmgr@ebs1 patches]$
applied the required patches as mentioned in the list above.
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
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh
start
$ adop phase=apply patches=17204589,21900871 merge=yes
hotpatch=yes
Successfully created out directory
[STATEMENT] [END 2017/01/24 03:41:39] Performing Automatic DB
cutover
[STATEMENT] [START
2017/01/24 03:41:40] Running cutover since in hotpatch mode
[STATEMENT] [END 2017/01/24 03:41:42] Running cutover since
in hotpatch mode
[STATEMENT] [START
2017/01/24 03:41:43] Compiling Invalid Objects
[STATEMENT] [END 2017/01/24 03:41:48] Compiling Invalid
Objects
[STATEMENT] [END 2017/01/24 03:41:52] apply phase
[STATEMENT] [START
2017/01/24 03:41:53] Generating Post Apply Reports
[STATEMENT] APPLY Phase
END TIME: 24-01-2017 03:41:54
[STATEMENT] [START
2017/01/24 03:41:56] Generating Report to spool all logs from ad_zd_logs
[STATEMENT] Report:
/u01/r12/application/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql
[STATEMENT] Output:
/u01/r12/application/fs_ne/EBSapps/log/adop/2/apply_20170124_015013/PROD_ebs1/adzdshowlog.out
[STATEMENT] [END 2017/01/24 03:42:00] Generating Report to
spool all logs from ad_zd_logs
[STATEMENT] [END 2017/01/24 03:42:01] Generating Post Apply
Reports
[STATEMENT] [END
2017/01/24 03:42:05] adzdoptl.pl run
[STATEMENT] adop phase=apply - Completed Successfully
[STATEMENT] Log file:
/u01/r12/application/fs_ne/EBSapps/log/adop/2/adop_20170124_015013.log
adop exiting with status = 0 (Success)
Apply the Latest AD and TXK
Delta Release Update Packs
applied the patch
adop phase=apply patches=21841299
hotpatch=yes
Upgrade and New
Installation Customers upgrading to Oracle E-Business Suite 12.2.6 Release
Update Pack
sh
$ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
adop phase=apply patches=21830810
hotpatch=yes
Apply Oracle E-Business Suite
12.2.6 Release Update Pack
Stop
the Oracle Weblogic Admin Server 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.
- Stop the Oracle Weblogic Admin
Server on the run file system.
UNIX:
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
- Stop the Node Manager service
on the run file system.
UNIX:
$ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
Apply
Oracle E-Business Suite 12.2.6 Release Update Pack Patch 21900901 on the run edition application
environment, using downtime mode.
UNIX:
$ adop phase=apply
apply_mode=downtime patches=21900901
-------------------------------------------------------------------------------------------------
Note:EBSapps.env will be created only when first autoconfig is
run. And don't run autoconfig in patch file system because the it will throw
errors
ORA-20099: E-Business Suite Patch Edition does not exist.
it should only be run when at-least patch edition exist
which is adop phase=prepare
---------------------------------------------------------------------------------------------------
SQL> select release_name from fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.2.6
