Env: Oracle Linux 6 DB: 12.1.0 EBS: 12.2.0
=====================================
1. Download Required Patches
2.
Download Patches
and move to below directory and unzip all.
p17204589_12.2.0_R12_GENERIC.zip
p17537119_R12_GENERIC.zip
p21900871_12.2.0_R12_GENERIC.zip
[applmgr@oraebs12 patch]$ cd /u01/oracle/PROD/fs_ne/EBSapps/patch
[applmgr@oraebs12 patch]$ ls
17204589
checkDBpatch.cmd
checkMTpatch.cmd db
p17204589_12.2.0_R12_GENERIC.zip
p21900871_12.2.0_R12_GENERIC.zip
21900871
checkDBpatch.sh
checkMTpatch.sh mw p17537119_R12_GENERIC.zip README.txt
[applmgr@oraebs12 patch]$ unzip
p17204589_12.2.0_R12_GENERIC.zip
[applmgr@oraebs12 patch]$ unzip
p17537119_R12_GENERIC.zip
[applmgr@oraebs12 patch]$ unzip
p21900871_12.2.0_R12_GENERIC.zip
[applmgr@oraebs12 appl]$ cd /u01/oracle/PROD/fs1/EBSapps/appl
[applmgr@oraebs12 appl]$ .
./APPSPROD_oraebs12.env run
[applmgr@oraebs12 appl]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@oraebs12 scripts]$ ./adadminsrvctl.sh
status
You are running adadminsrvctl.sh version
120.10.12020000.2
Enter the WebLogic Admin password:
Enter the APPS Schema password:
The
AdminServer is running
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile
/u01/oracle/PROD/fs1/inst/apps/PROD_oraebs12/logs/appl/admin/log/adadminsrvctl.txt
for more information ...
Step1A:(75 Mins) Apply Consolidated seed table
upgrade Patch on run file sysetm patch 17204589
[applmgr@oraebs12 scripts]$ adop phase=apply
patches=17204589,21900871 merge=yes hotpatch=yes
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Please
wait. Validating credentials...
Enter the RUN file system context file name
[/u01/oracle/PROD/fs1/inst/apps/PROD_oraebs12/appl/admin/PROD_oraebs12.xml]: (Press Enter)
[STATEMENT] [END
2020/11/06 20:26:02] Performing verification of parameters
[STATEMENT] [START 2020/11/06 20:26:02] Checking
for the required ENV setup
[STATEMENT] [END
2020/11/06 20:26:02] Checking for the required ENV setup
************* Start of session *************
version:
12.2.0
started
at: Fri Nov 06 2020 20:26:02
APPL_TOP is set to
/u01/oracle/PROD/fs1/EBSapps/appl
[STATEMENT] [START 2020/11/06 20:26:03]
Determining admin node
[STATEMENT] [END
2020/11/06 20:26:05] Determining admin node
[STATEMENT]
Recommended Worker Count: 1 Max
Allowed Workers: 10
[STATEMENT] [START 2020/11/06 20:26:09] Acquiring
lock on sessions table
[STATEMENT] [END
2020/11/06 20:26:10] Acquiring lock on sessions table
[STATEMENT] [START 2020/11/06 20:26:10] Checking
for any pending sessions
[STATEMENT] [START 2020/11/06 20:26:14] Staging the
current session
[STATEMENT] [START 2020/11/06 20:26:18] Checking if node
"oraebs12" is abandoned
[STATEMENT] [END 2020/11/06
20:26:20] Checking if node "oraebs12" is abandoned
[STATEMENT] [END
2020/11/06 20:26:22] Staging the current session
[STATEMENT] [START 2020/11/06 20:26:24] Unlocking
sessions table
[STATEMENT] [END
2020/11/06 20:26:25] Unlocking sessions table
[STATEMENT] [START 2020/11/06 20:26:25]
adzdoptl.pl run
[STATEMENT] Session ID: 2
[STATEMENT] Phase: apply
[STATEMENT] Log file:
/u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/adop_20201106_182842.log
[STATEMENT] [START 2020/11/06 20:26:35] Invoking admerge
[STATEMENT] [START 2020/11/06 20:26:37] Running AD Merge Normal Mode
[STATEMENT] Calling:
/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/admerge.pl
[STATEMENT] Log file:
/u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201106_182842/PROD_oraebs12/admrgpch.log
[STATEMENT] [END 2020/11/06
20:26:37] Running AD Merge Normal Mode
[STATEMENT] [START 2020/11/06 20:26:37] Running AD Merge in AD Mode
[STATEMENT] Calling:
/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/admerge.pl
[STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201106_182842/PROD_oraebs12/admrgpch.log
-console off
Executing the merge of the patch drivers
--
Processing patch:
/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996/src/17204589
--
Processing file: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996/src/17204589/u17204589.drv
-- Done
processing patch:
/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996/src/17204589
--
Processing patch: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996/src/21900871
--
Processing file:
/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996/src/21900871/u21900871.drv
-- Done
processing patch: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996/src/21900871
Copying files...
100% complete. Copied 0 files of 0...
Character-set converting files...
0 unified
drivers merged.
Patch merge completed successfully
Please check the log file at
/u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201106_182842/PROD_oraebs12/admrgpch.log.
[STATEMENT] [END 2020/11/06
20:26:37] Running AD Merge in AD Mode
[STATEMENT] [END 2020/11/06
20:26:38] Invoking admerge
[STATEMENT]
[START 2020/11/06 20:26:39] apply phase
[STATEMENT] APPLY Phase START TIME: 06-11-2020 20:26:40
[STATEMENT] [START 2020/11/06 20:26:42] Performing Check for Logon
Trigger existence and enablement
[STATEMENT] [END 2020/11/06
20:26:45] Performing Check for Logon Trigger existence and enablement
sh: module: line 1: syntax error: unexpected end
of file
sh: error importing function definition for
`module'
[STATEMENT] [Start 2020/11/06 20:26:49]
ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
[STATEMENT] Reading defaults file
/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt
[STATEMENT] Substituting tokens ...
[STATEMENT] Regenerating defaults file ...
[STATEMENT] [End 2020/11/06 20:26:49]
ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
[STATEMENT] Calling: adpatch
workers=1 options=hotpatch flags=autoskip console=no interactive=no
defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt
patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996
driver=u_20201106_1604679996.drv logfile=u_20201106_1604679996.log
[STATEMENT] ADPATCH Log directory:
/u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201106_182842/PROD_oraebs12/ADOP_MRG_20201106_1604679996/log
[STATEMENT] Running: adpatch
workers=1 options=hotpatch flags=autoskip console=no interactive=no
defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt
patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20201106_1604679996
driver=u_20201106_1604679996.drv logfile=u_20201106_1604679996.log stdin=yes
sh: module: line 1: syntax error: unexpected end
of file
sh: error importing function definition for `module'
Successfully created out directory
[STATEMENT] [START 2020/11/06 21:57:45] Running finalize since in
hotpatch mode
[STATEMENT] [END 2020/11/06
22:01:00] Running finalize since in hotpatch mode
[STATEMENT] [START 2020/11/06 22:01:01] Performing Automatic DB cutover
[STATEMENT] [Start 2020/11/06 22:01:04]
ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
[STATEMENT] Reading defaults file /u01/oracle/PROD/fs2/EBSapps/appl/admin/PROD_patch/adalldefaults.txt
[STATEMENT] Substituting tokens ...
[STATEMENT] Regenerating defaults file ...
[STATEMENT] [End 2020/11/06
22:01:05] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
[STATEMENT] Calling: adpatch
options=hotpatch,nocompiledb interactive=no console=no workers=1 restart=no
abandon=yes
defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt
patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver
logfile=cutover.log driver=ucutover.drv
[STATEMENT] ADPATCH Log directory:
/u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201106_182842/PROD_oraebs12/log
[STATEMENT] Running: adpatch options=hotpatch,nocompiledb interactive=no
console=no workers=1 restart=no abandon=yes
defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt
patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver
logfile=cutover.log driver=ucutover.drv stdin=yes
sh: module: line 1: syntax error: unexpected end
of file
sh: error importing function definition for
`module'
Successfully created out directory
[STATEMENT] [END 2020/11/06
22:02:34] Performing Automatic DB cutover
[STATEMENT] [START 2020/11/06 22:02:36] Running cutover since in
hotpatch mode
[STATEMENT] [END 2020/11/06
22:02:39] Running cutover since in hotpatch mode
[STATEMENT] [START 2020/11/06 22:02:40] Compiling Invalid Objects
[STATEMENT] [END 2020/11/06
22:02:48] Compiling Invalid Objects
sh: module: line 1: syntax error: unexpected end
of file
sh: error importing function definition for
`module'
[STATEMENT] [END 2020/11/06
22:02:52] apply phase
[STATEMENT] [START 2020/11/06 22:02:53] Generating Post Apply Reports
[STATEMENT] APPLY Phase END TIME: 06-11-2020 22:02:54
[STATEMENT] [START 2020/11/06 22:02:56] Generating Report to spool all
logs from ad_zd_logs
[STATEMENT] Report:
/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql
[STATEMENT] Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201106_182842/PROD_oraebs12/adzdshowlog.out
[STATEMENT] [END 2020/11/06
22:03:01] Generating Report to spool all logs from ad_zd_logs
[STATEMENT] [END 2020/11/06
22:03:03] Generating Post Apply Reports
[STATEMENT] [END
2020/11/06 22:03:07] adzdoptl.pl run
[STATEMENT] adop phase=apply - Completed
Successfully
[STATEMENT] Log file:
/u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/adop_20201106_182842.log
adop exiting with status = 0 (Success)
[applmgr@oraebs12 scripts]$
=================================================================
[oracle@oraebs12 OPatch]$ pwd
/u01/oracle/PROD/12.1.0/OPatch
[oracle@oraebs12 OPatch]$ ls
checkDBpatch.cmd
emdpatch.pl opatchdiag oracle_common
checkDBpatch.sh
jlib
opatchdiag.bat
p17537119_R12_GENERIC.zip
checkMTpatch.cmd
mw opatch.pl patch
checkMTpatch.sh
ocm opatchprereqs README.txt
datapatch
opatch operr scripts
datapatch.bat
opatchauto operr.bat version.txt
db
opatchauto-dir operr_readme.txt
docs
opatch.bat oplan
[oracle@oraebs12 OPatch]$ ./checkDBpatch.sh
+===============================================================+
| Copyright (c) 2005, 2020 Oracle and/or its
affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release
12.2 |
| Database EBS Technology Codelevel
Checker |
+===============================================================+
Validating context file:
/u01/oracle/PROD/12.1.0/appsutil/PROD_oraebs12.xml
Using context file from currently set database
environment:
/u01/oracle/PROD/12.1.0/appsutil/PROD_oraebs12.xml
Starting Database EBS Technology Codelevel
Checker, Version 120.81
Fri Nov 6
23:26:21 +04 2020
Log file for this session :
/u01/oracle/PROD/12.1.0/OPatch/log/checkDBpatch_17603.log
Identifying database release.
Database release set to 12.1.0.2.
Connecting to database.
Database connection successful.
Database PROD is in READ WRITE mode.
Identifying APPS and APPLSYS schema names.
- APPS
schema : APPS
- APPLSYS
schema : APPLSYS
Checking for DB-ETCC results table.
Table to store DB-ETCC results already exists in
the database.
Checking if InMemory option is enabled.
InMemory option is not enabled in the database.
Bugfix file
./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.56
This file will be used for identifying missing
bugfixes.
Mapping file
./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.31
This file will be used for mapping bugfixes to
patches.
[WARNING] DB-ETCC: Bugfix XML file
(./db/onprem/txk_R1220_DB_base_bugs.xml) is more than 30 days old.
Check if a
newer version is available in patch 17537119.
Identified RDBMS DST version 18.
Checking Bugfix XML file for 12.1.0.2
Obtained list of bugfixes to be applied and the
list to be rolled back.
Now checking Database ORACLE_HOME.
The opatch utility is version 12.1.0.1.10.
DB-ETCC is compatible with this opatch version.
Found patch records in the inventory.
Checking Mapping XML file for 12.1.0.2
Missing
Bugfix: 8975044 -> Patch 8975044
Missing
Bugfix: 14666816 -> Patch 27264965
Missing
Bugfix: 18793246 -> Patch 18793246
Missing
Bugfix: 18881811 -> Patch 25599890
Missing
Bugfix: 19068380 -> Patch 19068380
Missing
Bugfix: 19239846 -> Patch 30092105
Missing
Bugfix: 19509982 -> Patch 29748518
Missing
Bugfix: 19591608 -> Patch 19591608
Missing
Bugfix: 20627866 -> Patch 30092105
Missing
Bugfix: 20766180 -> Patch 20766180
Missing
Bugfix: 20868862 -> Patch 27264965
Missing
Bugfix: 21028698 -> Patch 22098146
Missing
Bugfix: 21106027 -> Patch 30092105
Missing
Bugfix: 21321429 -> Patch 21321429
Missing
Bugfix: 21387964 -> Patch 30092105
Missing
Bugfix: 21614112 -> Patch 29748518
Missing
Bugfix: 21751519 -> Patch 27264965
Missing
Bugfix: 21813400 -> Patch 30092105
Missing
Bugfix: 21864513 -> Patch 21864513
Missing
Bugfix: 21904072 -> Patch 21904072
Missing
Bugfix: 21967332 -> Patch 21967332
Missing
Bugfix: 22024071 -> Patch 30092105
Missing
Bugfix: 22229581 -> Patch 27264965
Missing
Bugfix: 22452653 -> Patch 27264965
Missing
Bugfix: 22496904 -> Patch 22496904
Missing
Bugfix: 22568797 -> Patch 30092105
Missing
Bugfix: 22660003 -> Patch 29748518
Missing
Bugfix: 22666802 -> Patch 30092105
Missing
Bugfix: 22731026 -> Patch 25599890
Missing
Bugfix: 22737974 -> Patch 27264965
Missing
Bugfix: 23089357 -> Patch 23089357
Missing
Bugfix: 23125826 -> Patch 23125826
Missing
Bugfix: 23220453 -> Patch 30092105
Missing
Bugfix: 23604553 -> Patch 27264965
Missing
Bugfix: 23632545 -> Patch 30092105
Missing
Bugfix: 23645516 -> Patch 30092105
Missing
Bugfix: 24326444 -> Patch 30092105
Missing
Bugfix: 24385983 -> Patch 30092105
Missing
Bugfix: 24560906 -> Patch 24560906
Missing
Bugfix: 24589081 -> Patch 30092105
Missing
Bugfix: 25099339 -> Patch 30092105
Missing
Bugfix: 25139545 -> Patch 27264965
Missing
Bugfix: 25305405 -> Patch 25305405
Missing
Bugfix: 25643931 -> Patch 25643931
Missing
Bugfix: 25906117 -> Patch 25906117
Missing
Bugfix: 25971286 -> Patch 30092105
Missing
Bugfix: 26336977 -> Patch 30092105
Missing
Bugfix: 26654363 -> Patch 30092105
Missing
Bugfix: 26658759 -> Patch 30092105
Missing
Bugfix: 26742604 -> Patch 27264965
Missing
Bugfix: 26798411 -> Patch 30092105
Missing
Bugfix: 27929509 -> Patch 30092105
Missing
Bugfix: 27997875 -> Patch 30092105
Missing
Bugfix: 28507324 -> Patch 28653113
Missing
Bugfix: 28542455 -> Patch 29842421
Missing
Bugfix: 29125374 -> Patch 29748518
Missing
Bugfix: 30758943 -> Patch 30758943
Generating Patch Recommendation Summary.
===============================================================================
PATCH RECOMMENDATION SUMMARY
===============================================================================
The default patch recommendations to install
these missing bugfixes are:
-------------------------------------------------------------------------------
Oracle Database Release 12.1.0.2 (No PSU applied)
-------------------------------------------------------------------------------
Patch
8975044
-
Filename: p8975044_121020_Linux-x86-64.zip
Patch
27264965
-
Filename: p27264965_121020_Linux-x86-64.zip
Patch
18793246
-
Filename: p18793246_121020_Generic.zip
Patch
25599890
-
Filename: p25599890_121020_Generic.zip
Patch
19068380
-
Filename: p19068380_121020_Linux-x86-64.zip
Patch
30092105
-
Filename: p30092105_121020_Linux-x86-64.zip
Patch
29748518
-
Filename: p29748518_121020_Linux-x86-64.zip
Patch
19591608
-
Filename: p19591608_121020_Linux-x86-64.zip
Patch
20766180
-
Filename: p20766180_121020_Generic.zip
Patch
22098146
-
Filename: p22098146_121020_Linux-x86-64.zip
Patch
21321429
-
Filename: p21321429_121020_Generic.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
22496904
-
Filename: p22496904_121020_Linux-x86-64.zip
Patch
23089357
-
Filename: p23089357_121020_Linux-x86-64.zip
Patch
23125826
-
Filename: p23125826_121020_Linux-x86-64.zip
Patch 24560906
-
Filename: p24560906_121020_Linux-x86-64.zip
Patch
25305405
-
Filename: p25305405_121020_Linux-x86-64.zip
Patch
25643931
-
Filename: p25643931_121020_Linux-x86-64.zip
Patch
25906117
-
Filename: p25906117_121020_Linux-x86-64.zip
Patch
28653113
-
Filename: p28653113_121020_Generic.zip
Patch
29842421
-
Filename: p29842421_121020_Linux-x86-64.zip
Patch
30758943
-
Filename: p30758943_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
31381618 [12.1.0.2.0 version]
- EBS
RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR JUL 2020
Note: This zip does not include database Release
Updates, bundles 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 checking fixes for Oracle Database: Fri
Nov 6 23:26:50 +04 2020
Log file for this session:
/u01/oracle/PROD/12.1.0/OPatch/log/checkDBpatch_17603.log
[oracle@oraebs12 OPatch]$
=========================================================================
INSTALLING ORACLE DB PATCHES (Download All
Required Patches & Unzip all)
"Shutdown Database"
========================================================================
[oracle@oraebs12 19591608]$ pwd
/u01/oracle/PROD/12.1.0/OPatch/patchdb/19591608
[oracle@oraebs12 19591608]$ cd ..
[oracle@oraebs12 patchdb]$ ls
18793246
27264965
p23089357_121020_Linux-x86-64.zip
19068380
28653113
p23125826_121020_Linux-x86-64.zip
19591608
29748518 p24560906_121020_Linux-x86-64.zip
20766180
29842421
p25305405_121020_Linux-x86-64.zip
21321429
30092105
p25599890_121020_Generic.zip
21864513
30758943
p25643931_121020_Linux-x86-64.zip
21904072
8975044
p25906117_121020_Linux-x86-64.zip
21967332
p18793246_121020_Generic.zip
p27264965_121020_Linux-x86-64.zip
22098146
p19068380_121020_Linux-x86-64.zip
p28653113_121020_Generic.zip
22496904 p19591608_121020_Linux-x86-64.zip p29748518_121020_Linux-x86-64.zip
23089357
p20766180_121020_Generic.zip
p29842421_121020_Linux-x86-64.zip
23125826
p21321429_121020_Generic.zip
p30092105_121020_Linux-x86-64.zip
24560906
p21864513_121020_Linux-x86-64.zip
p30758943_121020_Linux-x86-64.zip
25305405
p21904072_121020_Linux-x86-64.zip
p8975044_121020_Linux-x86-64.zip
25599890
p21967332_121020_Linux-x86-64.zip
PatchSearch.xml
25643931
p22098146_121020_Linux-x86-64.zip
25906117
p22496904_121020_Linux-x86-64.zip
[oracle@oraebs12 patchdb]$ cd 18793246/
[oracle@oraebs12 18793246]$ ls
etc
files README.txt
[oracle@oraebs12 18793246]$ opatch apply
Oracle Interim Patch Installer version
12.1.0.1.10
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home
: /u01/oracle/PROD/12.1.0
Central Inventory : /u01/oracle/oraInventory
from :
/u01/oracle/PROD/12.1.0/oraInst.loc
OPatch version
: 12.1.0.1.10
OUI version
: 12.1.0.2.0
Log file location :
/u01/oracle/PROD/12.1.0/cfgtoollogs/opatch/18793246_Nov_07_2020_17_26_13/apply2020-11-07_17-26-13PM_1.log
Verifying environment and performing prerequisite
checks...
OPatch continues with these patches: 18793246
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of
security issues, install and
initiate Oracle Configuration Manager. Easier for
you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html
for details.
Email address/User Name:
You have not provided an email address for
notification of security issues.
Do you wish to remain uninformed of security
issues ([Y]es, [N]o) [N]: y
Backing up files...
Applying interim patch '18793246' to OH
'/u01/oracle/PROD/12.1.0'
Patching component oracle.rdbms.dbscripts,
12.1.0.2.0...
Patch 18793246 successfully applied.
Log file location:
/u01/oracle/PROD/12.1.0/cfgtoollogs/opatch/18793246_Nov_07_2020_17_26_13/apply2020-11-07_17-26-13PM_1.log
OPatch succeeded.
[oracle@oraebs12 OPatch]$
[oracle@oraebs12 OPatch]$ opatch apply -force
/u01/oracle/PROD/12.1.0/OPatch/patchdb/21967332 ( Used -force option if patch have conflicts
with other patch) : [ 18893947 21967332 ]
Oracle Interim Patch Installer version
12.1.0.1.10
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home
: /u01/oracle/PROD/12.1.0
Central Inventory : /u01/oracle/oraInventory
from :
/u01/oracle/PROD/12.1.0/oraInst.loc
OPatch version
: 12.1.0.1.10
OUI version
: 12.1.0.2.0
Log file location :
/u01/oracle/PROD/12.1.0/cfgtoollogs/opatch/opatch2020-11-08_16-57-54PM_1.log
Verifying environment and performing prerequisite
checks...
Conflicts/Supersets for each patch are:
Patch : 21967332
Conflict with 18893947
Conflict details:
/u01/oracle/PROD/12.1.0/lib/libgeneric12.a:qcdo.o
Following patches have conflicts: [ 18893947
21967332 ]
Refer to My Oracle Support Note 1299688.1 for
instructions on resolving patch conflicts.
Do you want to proceed? [y|n]
y
User Responded with: Y
OPatch continues with these patches: 21967332
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of
security issues, install and
initiate Oracle Configuration Manager. Easier for
you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html
for details.
Email address/User Name:
You have not provided an email address for
notification of security issues.
Do you wish to remain uninformed of security
issues ([Y]es, [N]o) [N]: y
Please shutdown Oracle instances running out of
this ORACLE_HOME on the local system.
(Oracle Home = '/u01/oracle/PROD/12.1.0')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '21967332' to OH
'/u01/oracle/PROD/12.1.0'
Rolling back interim patch '18893947' from OH
'/u01/oracle/PROD/12.1.0'
Patching component oracle.rdbms.rsf,
12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
RollbackSession removing interim patch '18893947'
from inventory
OPatch back to application of the patch
'21967332' after auto-rollback.
Patching component oracle.rdbms.rsf,
12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patch 21967332 successfully applied.
N-Apply process is complete. Bugs [ 18893947 ] are lost. Please verify and re-run.
OPatch Session completed with warnings.
Log file location:
/u01/oracle/PROD/12.1.0/cfgtoollogs/opatch/opatch2020-11-08_16-57-54PM_1.log
OPatch completed with warnings.
[oracle@oraebs12 OPatch]$
[oracle@oraebs12 1patch]$ ./checkDBpatch.sh
+===============================================================+
| Copyright (c) 2005, 2020 Oracle and/or its
affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release
12.2 |
| Database EBS Technology Codelevel
Checker |
+===============================================================+
Validating context file: /u01/oracle/PROD/12.1.0/appsutil/PROD_oraebs12.xml
Using context file from currently set database
environment:
/u01/oracle/PROD/12.1.0/appsutil/PROD_oraebs12.xml
Starting Database EBS Technology Codelevel
Checker, Version 120.81
Sun Nov 8
17:12:41 +04 2020
Log file for this session :
/u01/oracle/PROD/12.1.0/1patch/log/checkDBpatch_19422.log
Identifying database release.
Database release set to 12.1.0.2.
Connecting to database.
Database connection successful.
Database PROD is in READ WRITE mode.
Identifying APPS and APPLSYS schema names.
- APPS
schema : APPS
- APPLSYS
schema : APPLSYS
Checking for DB-ETCC results table.
Table to store DB-ETCC results already exists in
the database.
Checking if InMemory option is enabled.
InMemory option is not enabled in the database.
Bugfix file
./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.56
This file will be used for identifying missing
bugfixes.
Mapping file
./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.31
This file will be used for mapping bugfixes to
patches.
[WARNING] DB-ETCC: Bugfix XML file
(./db/onprem/txk_R1220_DB_base_bugs.xml) is more than 30 days old.
Check if a
newer version is available in patch 17537119.
Identified RDBMS DST version 18.
Checking Bugfix XML file for 12.1.0.2
Obtained list of bugfixes to be applied and the
list to be rolled back.
Now checking Database ORACLE_HOME.
The opatch utility is version 12.1.0.1.10.
DB-ETCC is compatible with this opatch version.
Found patch records in the inventory.
Checking Mapping XML file for 12.1.0.2
Missing
Bugfix: 18607546 -> Patch 18607546
Generating Patch Recommendation Summary.
===============================================================================
PATCH RECOMMENDATION SUMMARY
===============================================================================
The default patch recommendations to install
these missing bugfixes are:
-------------------------------------------------------------------------------
Oracle Database Release 12.1.0.2 (No PSU applied)
-------------------------------------------------------------------------------
Patch
18607546
-
Filename: p18607546_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
31381618 [12.1.0.2.0 version]
- EBS
RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR JUL 2020
Note: This zip does not include database Release
Updates, bundles 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 checking fixes for Oracle Database: Sun
Nov 8 17:13:05 +04 2020
Log file for this session:
/u01/oracle/PROD/12.1.0/1patch/log/checkDBpatch_19422.log
=========================================================================
Oracle EBS APPLICATION PATCHES Information
=========================================================================
[applmgr@oraebs12 patch]$ ./checkMTpatch.sh
+===============================================================+
| Copyright (c) 2005, 2020 Oracle and/or its
affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release
12.2 |
| Application Tier Technology Codelevel
Checker |
+===============================================================+
Using context file from currently set
applications environment:
/u01/oracle/PROD/fs1/inst/apps/PROD_oraebs12/appl/admin/PROD_oraebs12.xml
Starting Application Tier Technology Codelevel
Checker
Version: 120.0.12020000.42.
Sun Nov 8
17:19:04 +04 2020
Log file for this session:
/u01/oracle/patch/log/checkMTpatch_20456.log
Bugfix XML file version: 120.0.12020000.46
This file will be used for identifying missing
bugfixes.
Mapping XML file version: 120.0.12020000.32
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 databas
e.
===============================================================================
Oracle Forms and Reports
===============================================================================
Now examining product Oracle Forms and Reports.
Oracle Home =
/u01/oracle/PROD/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 26825525
Missing
Bugfix: 20643256 -> Patch 26825525
Missing
Bugfix: 16041055 -> Patch 26825525
Missing
Bugfix: 16910762 -> Patch 26825525
Missing
Bugfix: 20270659 -> Patch 26825525
Missing
Bugfix: 17372642 -> Patch 26825525
Missing
Bugfix: 17566694 -> Patch 26825525
Missing
Bugfix: 20240480 -> Patch 26825525
Missing
Bugfix: 19304738 -> Patch 26825525
Missing
Bugfix: 20391574 -> Patch 26825525
Missing
Bugfix: 22351071 -> Patch 26825525
Missing
Bugfix: 21024122 -> Patch 26825525
Missing
Bugfix: 19588847 -> Patch 26825525
Missing
Bugfix: 19639173 -> Patch 26825525
Missing
Bugfix: 20545718 -> Patch 26825525
Missing
Bugfix: 22524329 -> Patch 26825525
Missing
Bugfix: 23123655 -> Patch 26825525
Missing
Bugfix: 23728755 -> Patch 26825525
Missing
Bugfix: 24315226 -> Patch 26825525
Missing
Bugfix: 24480018 -> Patch 26825525
Missing
Bugfix: 24808044 -> Patch 26825525
Missing
Bugfix: 24620875 -> Patch 26825525
Missing
Bugfix: 25355211 -> Patch 26825525
Missing
Bugfix: 23538157 -> Patch 26825525
Missing
Bugfix: 23538170 -> Patch 26825525
Missing
Bugfix: 13557392 -> Patch 26825525
Missing
Bugfix: 25506193 -> Patch 26825525
Missing
Bugfix: 25342269 -> Patch 25342269
Missing
Bugfix: 26048089 -> Patch 26825525
Missing
Bugfix: 25990479 -> Patch 26825525
Missing
Bugfix: 1770039 -> Patch 26825525
Missing
Bugfix: 27491934 -> Patch 27491934
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/oracle/PROD/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
Missing
Bugfix: 24567879 -> Patch 31047338
Missing
Bugfix: 20900385 -> Patch 31047338
Missing
Bugfix: 25205368 -> Patch 31304503
Missing
Bugfix: 26837992 -> Patch 31047338
Missing
Bugfix: 21305938 -> Patch 31047338
Missing
Bugfix: 20913582 -> Patch 31047338
Missing
Bugfix: 22218211 -> Patch 31047338
Missing
Bugfix: 23107407 -> Patch 31047338
Missing
Bugfix: 19571821 -> Patch 31047338
Missing
Bugfix: 26929226 -> Patch 31047338
Missing
Bugfix: 25191174 -> Patch 31047338
Missing
Bugfix: 26101975 -> Patch 31047338
Missing
Bugfix: 21520649 -> Patch 31047338
Missing
Bugfix: 23266217 -> Patch 31304503
Missing
Bugfix: 23115139 -> Patch 31304503
Missing
Bugfix: 26318200 -> Patch 31304503
Missing
Bugfix: 23140259 -> Patch 31304503
Missing
Bugfix: 25914276 -> Patch 31304503
Missing
Bugfix: 20856766 -> Patch 31304503
Missing
Bugfix: 26434300 -> Patch 31304503
Missing
Bugfix: 25879984 -> Patch 31304503
Missing
Bugfix: 19891090 -> Patch 31304503
Missing
Bugfix: 18604692 -> Patch 31304503
Missing
Bugfix: 29389063 -> Patch 31304503
Missing
Bugfix: 20273319 -> Patch 31304503
Missing
Bugfix: 25775213 -> Patch 31304503
Missing
Bugfix: 26245237 -> Patch 31304503
Missing
Bugfix: 18166013 -> Patch 31304503
Missing
Bugfix: 19718981 -> Patch 31304503
Missing
Bugfix: 21656630 -> Patch 31304503
Missing
Bugfix: 19697993 -> Patch 31304503
Missing
Bugfix: 23055182 -> Patch 31304503
Missing
Bugfix: 25760218 -> Patch 31304503
Missing
Bugfix: 20725343 -> Patch 31304503
Missing
Bugfix: 16354467 -> Patch 31304503
Missing
Bugfix: 22750215 -> Patch 31304503
Missing
Bugfix: 25635149 -> Patch 31304503
Missing
Bugfix: 25555252 -> Patch 31304503
Missing
Bugfix: 17983206 -> Patch 31304503
Missing
Bugfix: 21063322 -> Patch 31304503
Missing
Bugfix: 26243698 -> Patch 31304503
Missing
Bugfix: 23716938 -> Patch 23716938
Missing
Bugfix: 23716938 -> Patch 23716938
Missing
Bugfix: 24681614 -> Patch 31047338
Missing
Bugfix: 30146419 -> Patch 31047338
Missing
Bugfix: 20580842 -> Patch 31047338
Missing
Bugfix: 27577851 -> Patch 31047338
Missing
Bugfix: 25288078 -> Patch 31304503
Missing
Bugfix: 30887923 -> Patch 31047338
Missing
Bugfix: 26752325 -> Patch 31047338
Missing
Bugfix: 30876572 -> Patch 31047338
Missing
Bugfix: 31285797 -> Patch 31304503
The above list shows missing bugfixes for FMW -
Web Tier.
Checking required bugfixes for RSF within FMW Web
tier 11.1.0.7.0.
Missing
Bugfix: 20004021 -> Patch 22290164
Missing
Bugfix: 20004087 -> Patch 22290164
Missing
Bugfix: 16872333 -> Patch 22290164
Missing
Bugfix: 19699191 -> Patch 22290164
Missing
Bugfix: 20558005 -> Patch 22290164
Missing
Bugfix: 20331945 -> Patch 22290164
The above list shows missing bugfixes for RSF
within FMW Web tier.
===============================================================================
Oracle Fusion Middleware (FMW) - oracle_common
===============================================================================
Now examining product Oracle Fusion Middleware
(FMW) - oracle_common.
Oracle Home =
/u01/oracle/PROD/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: 17428617 -> Patch 17428617
Missing
Bugfix: 21366277 -> Patch 21366277
Missing
Bugfix: 21628307 -> Patch 21628307
Missing
Bugfix: 24606362 -> Patch 24606362
Missing
Bugfix: 24843064 -> Patch 24843064
Missing
Bugfix: 13544814 -> Patch 13544814
Missing
Bugfix: 16089637 -> Patch 16089637
Missing
Bugfix: 20141119 -> Patch 20141119
Missing
Bugfix: 24335626 -> Patch 30368663
Missing
Bugfix: 22998551 -> Patch 30368663
Missing
Bugfix: 22660018 -> Patch 30368663
Missing
Bugfix: 24913281 -> Patch 30368663
Missing
Bugfix: 20055551 -> Patch 30368663
Missing
Bugfix: 27212806 -> Patch 27212806
Missing
Bugfix: 28371189 -> Patch 28708563
Missing
Bugfix: 26957170 -> Patch 30368663
Missing
Bugfix: 28368196 -> Patch 30368663
Missing
Bugfix: 30153175 -> Patch 30368663
Missing
Bugfix: 29702340 -> Patch 30368663
Missing
Bugfix: 29997425 -> Patch 30368663
The above list shows missing bugfixes for FMW -
oracle common.
===============================================================================
Oracle WebLogic Server (WLS)
===============================================================================
Now examining product Oracle WebLogic Server
(WLS).
Oracle Home =
/u01/oracle/PROD/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: 29204678
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
26825525
-
Filename: p26825525_101232_LINUX.zip
Patch
25342269
-
Filename: p25342269_101232_Generic.zip
Patch
27491934
-
Filename: p27491934_101232_LINUX.zip
-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - Web Tier
11.1.1.9.0
-------------------------------------------------------------------------------
Patch
22288381
-
Filename: p22288381_111190_Generic.zip
Patch
31047338
-
Filename: p31047338_111190_Linux-x86-64.zip
Patch
31304503
-
Filename: p31304503_111190_Linux-x86-64.zip
Patch
23716938
-
Filename: p23716938_111190_Generic.zip
-------------------------------------------------------------------------------
RSF within FMW Web tier 11.1.0.7.0
-------------------------------------------------------------------------------
Patch
22290164
-
Filename: p22290164_111070_Linux-x86-64.zip
-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - oracle_common
11.1.1.9.0
-------------------------------------------------------------------------------
Patch
9905685
-
Filename: p9905685_111190_Generic.zip
Patch
17428617
-
Filename: p17428617_111190_Generic.zip
Patch
21366277
-
Filename: p21366277_111190_Generic.zip
Patch 21628307
- Filename: p21628307_111190_Generic.zip
Patch
24606362
-
Filename: p24606362_111190_Generic.zip
Patch
24843064
-
Filename: p24843064_111190_Generic.zip
Patch
13544814
- Filename: p13544814_111190_Generic.zip
Patch
16089637
- Filename: p16089637_111190_Generic.zip
Patch
20141119
- Filename: p20141119_111190_Generic.zip
Patch 30368663
- Filename: p30368663_111190_Generic.zip
Patch
27212806
- Filename: p27212806_111190_Generic.zip
Patch
28708563
- Filename: p28708563_111190_Generic.zip
-------------------------------------------------------------------------------
Oracle WebLogic Server (WLS) 10.3.6.0.7
-------------------------------------------------------------------------------
Bugfix
29204678 [Warning: No patch mapping data found.]
- Use
Doc ID 1594274.1 to find the patch that delivers this bugfix.
Patch
data missing for bugfix 29204678
Apply the required patches and rerun this script.
+-----------------------------------------------------------------------------+
A consolidated zip file with the required
application tier patches is
available on My Oracle Support via:
Patch
31381605
- EBS
RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2020
+-----------------------------------------------------------------------------+
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.
Sun Nov 8
17:20:09 +04 2020
Log file for this session:
/u01/oracle/patch/log/checkMTpatch_20456.log
===============================================================================
[applmgr@oraebs12 patch]$
=====================
Installing Oracle EBS Apps
[applmgr@oraebs12 patch]$ cd 26825525
[applmgr@oraebs12 26825525]$ ls
etc
files README.txt
[applmgr@oraebs12 26825525]$ which opatch
/u01/oracle/PROD/fs1/EBSapps/10.1.2/OPatch/opatch
[applmgr@oraebs12 26825525]$ opatch apply
Oracle Interim Patch Installer version 1.0.0.0.64
Copyright (c) 2011 Oracle Corporation. All Rights
Reserved..
Oracle recommends you to use the latest OPatch
version
and read the OPatch documentation available in
the OPatch/docs
directory for usage. For information about the
latest OPatch and
other support-related issues, refer to document
ID 293369.1
available on My Oracle Support
(https://myoraclesupport.oracle.com)
Oracle Home :
/u01/oracle/PROD/fs1/EBSapps/10.1.2
Oracle Home Inventory : /u01/oracle/PROD/fs1/EBSapps/10.1.2/inventory
Central Inventory : /u01/oracle/oraInventory
from :
/etc/oraInst.loc
OUI location :
/u01/oracle/PROD/fs1/EBSapps/10.1.2/oui
OUI shared library : /u01/oracle/PROD/fs1/EBSapps/10.1.2/oui/lib/linux/liboraInstaller.so
Java location :
/u01/oracle/PROD/fs1/EBSapps/10.1.2/jdk/jre/bin/java
Log file location :
/u01/oracle/PROD/fs1/EBSapps/10.1.2/.patch_storage/<patch ID>/*.log
Creating log file
"/u01/oracle/PROD/fs1/EBSapps/10.1.2/.patch_storage/26825525/Apply_26825525_11-08-2020_22-48-25.log"
Invoking fuser to check for active processes.
Patch "26825525" overlays "
14825718 ". Conflict check between them is skipped.
Subset patches:
8557019, 18620223, 19434967,
The fixes for Patch 8557019, 18620223,
19434967, are included in the patch
currently
being installed (26825525). OPatch will roll back the subset patch(es)
and
install the new patch (26825525).
Provide your email address to be informed of
security issues, install and
initiate Oracle Configuration Manager. Easier for
you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html
for details.
Email address/User Name:
You have not provided an email address for
notification of security issues.
Do you wish to remain uninformed of security
issues ([Y]es, [N]o) [N]: y
Oracle Configuration Manager has been installed
but not configured. OCM enables
Oracle to provide superior, proactive support for
our customers. Oracle
strongly recommends customers configure OCM. To
complete the configuration of
OCM, refer to the OCM Installation and
Administration Guide
(http://www.oracle.com/technology/documentation/ocm.html).
Backing up comps.xml ...
OPatch detected non-cluster Oracle Home from the
inventory and will patch the local system only.
Please shut down Oracle instances running out of
this ORACLE_HOME
(Oracle Home =
/u01/oracle/PROD/fs1/EBSapps/10.1.2)
Is this system ready for updating?
Please respond Y|N >
y
Rolling back patch 8557019...
Creating log file
"/u01/oracle/PROD/fs1/EBSapps/10.1.2/.patch_storage/8557019/RollBack_8557019_11-08-2020_22-49-03.log"
Rolling back with all-node mode.
OPatch detected non-cluster Oracle Home from the
inventory and will patch the local system only.
Oracle instances have been shut down, proceeding
with auto-rollback.
Removing patch 8557019...
Restoring archive files...
Running make for target install.
Updating inventory...
Rolling back patch 18620223...
Creating log file
"/u01/oracle/PROD/fs1/EBSapps/10.1.2/.patch_storage/18620223/RollBack_18620223_11-08-2020_22-49-18.log"
Rolling back with all-node mode.
OPatch detected non-cluster Oracle Home from the
inventory and will patch the local system only.
Oracle instances have been shut down, proceeding
with auto-rollback.
Removing patch 18620223...
Restoring archive files...
Running make for target sharedlib.
Running make for target install.
Updating inventory...
Rolling back patch 19434967...
Creating log file
"/u01/oracle/PROD/fs1/EBSapps/10.1.2/.patch_storage/19434967/RollBack_19434967_11-08-2020_22-49-38.log"
Rolling back with all-node mode.
OPatch detected non-cluster Oracle Home from the
inventory and will patch the local system only.
Oracle instances have been shut down, proceeding
with auto-rollback.
Removing patch 19434967...
Restoring archive files...
Restoring copied files...
Running make for target sharedlib.
Running make for target install.
Running make for target sharedlibs.
Updating inventory...
Back to applying patch 26825525...
Backing up 2nd copy of comps.xml ...
Applying patch 26825525...
Patching archive files...
Patching copy files...
Running make for target sharedlibs.
Running make for target sharedlib.
Running make for target install.
Inventory is good and does not have any dangling
patches.
Updating inventory...
Verifying patch...
Backing up comps.xml ...
Patch succeeded.
[applmgr@oraebs12 26825525]$
=========================
FMW HOME Installation
Patches
$ which opatch
/u01/oracle/PROD/fs1/EBSapps/10.1.2/Opatch/opatch
[applmgr@oraebs12 22288381]$
$ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version
11.1.0.12.9
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home
: /u01/oracle/PROD/fs1/FMW_Home/webtier
Central Inventory : /u01/oracle/oraInventory
from :
/u01/oracle/PROD/fs1/FMW_Home/webtier/oraInst.loc
OPatch version
: 11.1.0.12.9
OUI version
: 11.1.0.11.0
Log file location :
/u01/oracle/PROD/fs1/FMW_Home/webtier/cfgtoollogs/opatch/22288381_Nov_08_2020_23_10_07/apply2020-11-08_23-10-06PM_1.log
OPatch detects the Middleware Home as
"/u01/oracle/PROD/fs1/FMW_Home"
Applying interim patch '22288381' to OH
'/u01/oracle/PROD/fs1/FMW_Home/webtier'
Verifying environment and performing prerequisite
checks...
Conflicts/Supersets for each patch are:
Patch : 22288381
Bug
Superset of 20922780
Super set bugs are:
20922780
Interim patch 22288381 is a superset of the
patch(es) [ 20922780 ] in the Oracle
Home
OPatch will roll back the subset patches and
apply the given patch.
All checks passed.
Provide your email address to be informed of
security issues, install and
initiate Oracle Configuration Manager. Easier for
you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html
for details.
Email address/User Name:
You have not provided an email address for
notification of security issues.
Do you wish to remain uninformed of security
issues ([Y]es, [N]o) [N]: y
Backing up files...
Rolling back interim patch '20922780' from OH
'/u01/oracle/PROD/fs1/FMW_Home/webtier'
Patching component oracle.as.clone.ohs,
11.1.1.9.0...
Updating jar file
"/u01/oracle/PROD/fs1/FMW_Home/webtier/clone/provision/ohscloning.jar"
with
"/u01/oracle/PROD/fs1/FMW_Home/webtier/.patch_storage/20922780_May_28_2015_05_58_51/files//clone/provision/ohscloning.jar/oracle/as/clone/ohs/constants/OHSComponentCloningConstants$WebGateInfo.class"
Updating jar file
"/u01/oracle/PROD/fs1/FMW_Home/webtier/clone/provision/ohscloning.jar"
with
"/u01/oracle/PROD/fs1/FMW_Home/webtier/.patch_storage/20922780_May_28_2015_05_58_51/files//clone/provision/ohscloning.jar/oracle/as/clone/ohs/helper/MovePlanHelper.class"
Updating jar file
"/u01/oracle/PROD/fs1/FMW_Home/webtier/clone/provision/ohscloning.jar"
with
"/u01/oracle/PROD/fs1/FMW_Home/webtier/.patch_storage/20922780_May_28_2015_05_58_51/files//clone/provision/ohscloning.jar/oracle/as/clone/ohs/helper/MovePlanHelper$MovePlanValidationHandler.class"
Updating jar file
"/u01/oracle/PROD/fs1/FMW_Home/webtier/clone/provision/ohscloning.jar"
with
"/u01/oracle/PROD/fs1/FMW_Home/webtier/.patch_storage/20922780_May_28_2015_05_58_51/files//clone/provision/ohscloning.jar/oracle/as/clone/ohs/resources/OHSComponentCloningResources.class"
RollbackSession removing interim patch '20922780'
from inventory
OPatch back to application of the patch
'22288381' after auto-rollback.
Patching component oracle.as.clone.ohs,
11.1.1.9.0...
Verifying the update...
Patch 22288381 successfully applied
Log file location:
/u01/oracle/PROD/fs1/FMW_Home/webtier/cfgtoollogs/opatch/22288381_Nov_08_2020_23_10_07/apply2020-11-08_23-10-06PM_1.log
OPatch succeeded.
[applmgr@oraebs12 22288381]$ cd ..
[applmgr@oraebs12 patch]$ ls
17204589
p16089637_111190_Generic.zip
p25342269_101232_Generic.zip
21900871
p17204589_12.2.0_R12_GENERIC.zip
p26825525_101232_LINUX.zip
22288381
p17428617_111190_Generic.zip
p27212806_111190_Generic.zip
26825525
p17537119_R12_GENERIC.zip
p27491934_101232_LINUX.zip
27491934
p20141119_111190_Generic.zip
p28708563_111190_Generic.zip
checkDBpatch.cmd p21366277_111190_Generic.zip p30368663_111190_Generic.zip
checkDBpatch.sh
p21628307_111190_Generic.zip
p31047338_111190_Linux-x86-64.zip
checkMTpatch.cmd
p21900871_12.2.0_R12_GENERIC.zip
p31304503_111190_Linux-x86-64.zip
checkMTpatch.sh
p22288381_111190_Generic.zip
p9905685_111190_Generic.zip
db
p22290164_111070_Linux-x86-64.zip
README.txt
mw
p23716938_111190_Generic.zip
p13544814_111190_Generic.zip p24606362_111190_Generic.zip
[applmgr@oraebs12 patch]$ unzip
p31047338_111190_Linux-x86-64.zip
Archive:
p31047338_111190_Linux-x86-64.zip
creating: 31047338/
creating: 31047338/files/
creating: 31047338/files/ohs/
creating: 31047338/files/ohs/modules/
inflating: 31047338/files/ohs/modules/mod_ossl.so
creating: 31047338/files/ohs/bin/
inflating: 31047338/files/ohs/bin/httpd.worker
inflating: 31047338/files/ohs/bin/httpd.prefork
inflating: 31047338/files/ohs/bin/httpd
creating: 31047338/files/ohs/conf/
inflating: 31047338/files/ohs/conf/httpd.conf
inflating: 31047338/files/ohs/conf/ssl.conf
creating: 31047338/files/ohs/lib/
inflating: 31047338/files/ohs/lib/libxml2.so
creating: 31047338/etc/
creating: 31047338/etc/config/
inflating: 31047338/etc/config/actions.xml
inflating: 31047338/etc/config/inventory.xml
inflating: 31047338/etc/config/deploy.xml
creating: 31047338/etc/xml/
inflating: 31047338/etc/xml/GenericActions.xml
inflating: 31047338/etc/xml/ShiphomeDirectoryStructure.xml
inflating: 31047338/README.txt
[applmgr@oraebs12 patch]$ cd 31047338/
[applmgr@oraebs12 31047338]$
$ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version
11.1.0.12.9
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home
: /u01/oracle/PROD/fs1/FMW_Home/webtier
Central Inventory : /u01/oracle/oraInventory
from :
/u01/oracle/PROD/fs1/FMW_Home/webtier/oraInst.loc
OPatch version
: 11.1.0.12.9
OUI version
: 11.1.0.11.0
Log file location :
/u01/oracle/PROD/fs1/FMW_Home/webtier/cfgtoollogs/opatch/31047338_Nov_08_2020_23_11_26/apply2020-11-08_23-11-26PM_1.log
OPatch detects the Middleware Home as
"/u01/oracle/PROD/fs1/FMW_Home"
Applying interim patch '31047338' to OH
'/u01/oracle/PROD/fs1/FMW_Home/webtier'
Verifying environment and performing prerequisite
checks...
All checks passed.
Provide your email address to be informed of
security issues, install and
initiate Oracle Configuration Manager. Easier for
you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html
for details.
Email address/User Name:
You have not provided an email address for
notification of security issues.
Do you wish to remain uninformed of security
issues ([Y]es, [N]o) [N]: y
Please shutdown Oracle instances running out of
this ORACLE_HOME on the local system.
(Oracle Home =
'/u01/oracle/PROD/fs1/FMW_Home/webtier')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.ohs2, 11.1.1.9.0...
Verifying the update...
Patch 31047338 successfully applied
Log file location:
/u01/oracle/PROD/fs1/FMW_Home/webtier/cfgtoollogs/opatch/31047338_Nov_08_2020_23_11_26/apply2020-11-08_23-11-26PM_1.log
OPatch succeeded.
[applmgr@oraebs12 31047338]$
====================================================================================
Oracle WebLogic Server (WLS) When you apply patch on WLS First set the
ORACLE_HOME Variable
=====================================================================================
Now examining product Oracle WebLogic Server
(WLS).
$ Export Oracle Home =
/u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3
$ echo $ORACLE_HOME
/u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3
=======================================================================
ADGRANTS.SQL Scripts (Download Patch 20745242)
/u01/oracle/PROD/fs_ne/EBSapps/patch/PatchTXKAD/20745242/admin/adgrants.sh
[applmgr@oraebs12 admin]$ cp adgrants.sql /u01/oracle/PROD/fs1/EBSapps/appl/admin/
======================================================================
[oracle@oraebs12 12.1.0]$ . ./PROD_oraebs12.env
[oracle@oraebs12 12.1.0]$ cd bin
[oracle@oraebs12 bin]$ ./sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 10 17:26:41 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> @/u01/oracle/PROD/fs1/EBSapps/appl/admin/adgrants.sql apps
Connected.
---------------------------------------------------
--- adgrants.sql started at 2020-11-10 17:27:52 ---
Creating PL/SQL profiler objects.
---------------------------------------------------
--- profload.sql started at 2020-11-10 17:27:52 ---
Session altered.
Package created.
Grant succeeded.
Synonym created.
Session altered.
Session altered.
Library created.
Package body created.
Session altered.
Testing for correct installation
SYS.DBMS_PROFILER successfully loaded.
PL/SQL procedure successfully completed.
-----------------------------------------------------
--- profload.sql completed at 2020-11-10 17:27:59 ---
--------------------------------------------------
--- proftab.sql started at 2020-11-10 17:27:59 ---
Table dropped.
Table dropped.
Table dropped.
Sequence dropped.
Table created.
Comment created.
Table created.
Comment created.
Table created.
Comment created.
Sequence created.
-----------------------------------------------------
--- profltab.sql completed at 2020-11-10 17:28:02 ---
Installing Hierarchical Profiler.
Table dropped.
Table dropped.
Table dropped.
Sequence dropped.
Table created.
Comment created.
Table created.
Comment created.
Table created.
Comment created.
Sequence created.
Session altered.
Package created.
Synonym created.
Session altered.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Loading Stylesheets if missing
PL/SQL procedure successfully completed.
Start of Creating AD_JAR context
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
End of Creating AD_JAR context
Creating PL/SQL Package AD_DBMS_METADATA.
Package created.
Package body created.
End of Creating PL/SQL Package AD_DBMS_METADATA.
Creating PL/SQL Package AD_ZD_SYS.
Package created.
Package body created.
End of Creating PL/SQL Package AD_ZD_SYS.
Start of giving grants. This may take few minutes.
PL/SQL procedure successfully completed.
Start of PURGE DBA_RECYCLEBIN.
PL/SQL procedure successfully completed.
End of PURGE DBA_RECYCLEBIN.
Commit complete.
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@oraebs12 bin]$
=======================================================================
ADGRANTS.SQL Scripts (Download Patch 22123818/)
/u01/oracle/PROD/fs_ne/EBSapps/patch/22123818/admin/adgrants.sh
[applmgr@oraebs12 admin]$ cp adgrants.sql /u01/oracle/PROD/fs1/EBSapps/appl/admin/
======================================================================
[oracle@oraebs12 bin]$ ./sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 10 18:58:11 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> @/u01/oracle/PROD/fs1/EBSapps/appl/admin/adgrants.sql apps
Connected.
---------------------------------------------------
--- adgrants.sql started at 2020-11-10 18:58:30 ---
Creating PL/SQL profiler objects.
---------------------------------------------------
--- profload.sql started at 2020-11-10 18:58:30 ---
Session altered.
Package created.
Grant succeeded.
Synonym created.
Session altered.
Session altered.
Library created.
Package body created.
Session altered.
Testing for correct installation
SYS.DBMS_PROFILER successfully loaded.
PL/SQL procedure successfully completed.
-----------------------------------------------------
--- profload.sql completed at 2020-11-10 18:58:35 ---
--------------------------------------------------
--- proftab.sql started at 2020-11-10 18:58:35 ---
Table dropped.
Table dropped.
Table dropped.
Sequence dropped.
Table created.
Comment created.
Table created.
Comment created.
Table created.
Comment created.
Sequence created.
-----------------------------------------------------
--- profltab.sql completed at 2020-11-10 18:58:35 ---
Installing Hierarchical Profiler.
Table dropped.
Table dropped.
Table dropped.
Sequence dropped.
Table created.
Comment created.
Table created.
Comment created.
Table created.
Comment created.
Sequence created.
Session altered.
Package created.
Synonym created.
Session altered.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Loading Stylesheets if missing
PL/SQL procedure successfully completed.
Start of Creating AD_JAR context
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
End of Creating AD_JAR context
Creating PL/SQL Package AD_DBMS_METADATA.
Package created.
Package body created.
End of Creating PL/SQL Package AD_DBMS_METADATA.
Creating PL/SQL Package AD_ZD_SYS.
Package created.
Package body created.
End of Creating PL/SQL Package AD_ZD_SYS.
Start of giving grants. This may take few minutes.
PL/SQL procedure successfully completed.
Start of PURGE DBA_RECYCLEBIN.
PL/SQL procedure successfully completed.
End of PURGE DBA_RECYCLEBIN.
Commit complete.
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@oraebs12 bin]$
[applmgr@oraebs12 22123818]$ adop phase=apply patches=22123818 hotpatch=yes
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/oracle/PROD/fs1/inst/apps/PROD_oraebs12/appl/admin/PROD_oraebs12.xml
Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_oraebs12/appl/admin/PROD_oraebs12.xml
Reading driver file (up to 50000000 bytes).
Patch file system free space: 85.76 GB
Validating system setup.
Node registry is valid.
[WARNING] ETCC: The following required database fixes have not been applied to node oraebs12:
18607546
Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.
Checking for existing adop sessions.
Application tier services are down.
Continuing with the existing session [Session ID: 2].
===========================================================================
ADOP (C.Delta.7)
Session ID: 2
Node: oraebs12
Phase: apply
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/adop_20201110_195755.log
===========================================================================
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'
Applying patch 22123818.
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201110_195755/PROD_oraebs12/22123818/log/u22123818.log
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'
Running finalize actions for the patches being applied.
Log: @ADZDSHOWLOG.sql "2020/11/10 20:11:07"
Running cutover actions for the patches being applied.
Creating addtional workers to process cutover DDL in parallel
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201110_195755/PROD_oraebs12/log/cutover.log
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'
Performing database cutover in Quick mode
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `module'
Generating post apply reports.
Generating log report.
Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20201110_195755/PROD_oraebs12/adzdshowlog.out
The apply phase completed successfully.
adop exiting with status = 0 (Success)
[applmgr@oraebs12 22123818]$
