Oracle EBS Release Update from 12.2.0 to R12.2.10
In this post, I am going to share how to upgrade Oracle EBS Release R12.2.0 to R12.2.10
Please note this is my part of the EBS apps upgrade series, so patches might differ if you are doing for a fresh install of R12.2.0 version, but the steps will remain the same.
DB Version: 12.1.0.2
EBS version: R12.2.0
SQL> select release_name from apps.fnd_product_groups; RELEASE_NAME -------------------------------------------------- 12.2.0
Make sure DB and Listener are running
Steps:
1) Apply Required Database Patches
Download the latest ETCC patch (available via Patch 17537119) of the EBS Technology Code level Checker (ETCC). Use the command checkDBpatch.sh and apply all recommended patches. Please note ETCC patch keeps getting updated, so the patches it recommends might vary from time to time
Source DB environment and run the below script.
[oracle@ebsupgrade R12210_RUP]$ ls -ltr total 116 -rwxrwx---. 1 root vboxsf 114857 Dec 17 20:43 p17537119_R12_GENERIC.zip [oracle@ebsupgrade R12210_RUP]$ unzip p17537119_R12_GENERIC.zip Archive: p17537119_R12_GENERIC.zip inflating: checkDBpatch.cmd inflating: checkDBpatch.sh inflating: checkMTpatch.cmd inflating: checkMTpatch.sh creating: db/ creating: db/cloud/ inflating: db/cloud/txk_R1220_EXABM_mappings.xml inflating: db/cloud/txk_R1220_DBCS_base_bugs.xml inflating: db/cloud/txk_R1220_DBCS_RAC_base_bugs.xml inflating: db/cloud/txk_R1220_VMDB_RAC_base_bugs.xml inflating: db/cloud/txk_R1220_EXACS_mappings.xml inflating: db/cloud/txk_R1220_EXACS_base_bugs.xml inflating: db/cloud/txk_R1220_DBCS_RAC_mappings.xml inflating: db/cloud/txk_R1220_DBSI_base_bugs.xml inflating: db/cloud/txk_R1220_VMDB_RAC_mappings.xml inflating: db/cloud/txk_R1220_DBSI_mappings.xml inflating: db/cloud/txk_R1220_DBCS_mappings.xml inflating: db/cloud/txk_R1220_EXABM_base_bugs.xml creating: db/onprem/ inflating: db/onprem/txk_R1220_DB_mappings.xml inflating: db/onprem/txk_R1220_DB_base_bugs.xml inflating: db/onprem/txk_R1220_GRID_base_bugs.xml creating: mw/ inflating: mw/txk_R1220_MT_base_bugs.xml inflating: mw/txk_R1220_MT_mappings.xml inflating: README.txt inflating: db/cloud/txk_R1220_EXACC_base_bugs.xml inflating: db/cloud/txk_R1220_EXACC_mappings.xml [oracle@ebsupgrade R12210_RUP]$ ls -ltr total 388 drwxrwx---. 1 root vboxsf 4096 May 8 2018 db drwxrwx---. 1 root vboxsf 4096 Feb 8 2019 mw -rwxrwx---. 1 root vboxsf 45020 Aug 25 22:48 checkMTpatch.sh -rwxrwx---. 1 root vboxsf 26087 Nov 16 15:24 README.txt -rwxrwx---. 1 root vboxsf 87955 Nov 16 15:47 checkDBpatch.sh -rwxrwx---. 1 root vboxsf 50341 Nov 16 15:47 checkDBpatch.cmd -rwxrwx---. 1 root vboxsf 49438 Nov 16 15:52 checkMTpatch.cmd -rwxrwx---. 1 root vboxsf 114857 Dec 17 20:43 p17537119_R12_GENERIC.zip [oracle@ebsupgrade R12210_RUP]$ ./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: /tarmachin/EBS1213/GOLD/DB/tech_st/12.1.0/appsutil/GOLD121_ebsupgrade.xml Using context file from currently set database environment: /tarmachin/EBS1213/GOLD/DB/tech_st/12.1.0/appsutil/GOLD121_ebsupgrade.xml Starting Database EBS Technology Codelevel Checker, Version 120.82 Thu Dec 17 20:44:18 IST 2020 Log file for this session : /media/sf_Downloads/R12210_RUP/log/checkDBpatch_3129.log Identifying database release. Database release set to 12.1.0.2. Connecting to database. Database connection successful. Database GOLD121 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.57 This file will be used for identifying missing bugfixes. Mapping file ./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.32 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.2.0.1.23. 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: 18485835 -> Patch 29748518 Missing Bugfix: 18607546 -> Patch 18607546 Missing Bugfix: 18674024 -> Patch 31692949 Missing Bugfix: 18689530 -> Patch 22098146 Missing Bugfix: 18793246 -> Patch 18793246 Missing Bugfix: 18881811 -> Patch 25599890 Missing Bugfix: 18964939 -> Patch 31692949 Missing Bugfix: 18966843 -> Patch 28653113 Missing Bugfix: 19068380 -> Patch 19068380 Missing Bugfix: 19239846 -> Patch 31692949 Missing Bugfix: 19291380 -> Patch 19291380 Missing Bugfix: 19472320 -> Patch 19472320 Missing Bugfix: 19487147 -> Patch 31692949 Missing Bugfix: 19509982 -> Patch 29748518 Missing Bugfix: 19536415 -> Patch 31692949 Missing Bugfix: 19835133 -> Patch 19835133 Missing Bugfix: 19896336 -> Patch 31692949 Missing Bugfix: 20093776 -> Patch 20093776 Missing Bugfix: 20181016 -> Patch 20181016 Missing Bugfix: 20245930 -> Patch 31692949 Missing Bugfix: 20294666 -> Patch 20294666 Missing Bugfix: 20413820 -> Patch 31692949 Missing Bugfix: 20476776 -> Patch 27264965 Missing Bugfix: 20588502 -> Patch 31692949 Missing Bugfix: 20627866 -> Patch 31692949 Missing Bugfix: 20766180 -> Patch 20766180 Missing Bugfix: 20798891 -> Patch 20798891 Missing Bugfix: 20825533 -> Patch 31692949 Missing Bugfix: 20868862 -> Patch 27264965 Missing Bugfix: 20887355 -> Patch 20887355 Missing Bugfix: 20936905 -> Patch 31692949 Missing Bugfix: 21028698 -> Patch 22098146 Missing Bugfix: 21091431 -> Patch 31692949 Missing Bugfix: 21106027 -> Patch 31692949 Missing Bugfix: 21153266 -> Patch 21153266 Missing Bugfix: 21321429 -> Patch 21321429 Missing Bugfix: 21322448 -> Patch 21322448 Missing Bugfix: 21387964 -> Patch 31692949 Missing Bugfix: 21614112 -> Patch 29748518 Missing Bugfix: 21626377 -> Patch 21626377 Missing Bugfix: 21751519 -> Patch 27264965 Missing Bugfix: 21813400 -> Patch 31692949 Missing Bugfix: 21864513 -> Patch 21864513 Missing Bugfix: 21904072 -> Patch 21904072 Missing Bugfix: 21967332 -> Patch 21967332 Missing Bugfix: 22024071 -> Patch 31692949 Missing Bugfix: 22223463 -> Patch 22223463 Missing Bugfix: 22229581 -> Patch 27264965 Missing Bugfix: 22331786 -> Patch 31692949 Missing Bugfix: 22452653 -> Patch 27264965 Missing Bugfix: 22496904 -> Patch 22496904 Missing Bugfix: 22568797 -> Patch 31692949 Missing Bugfix: 22666802 -> Patch 31692949 Missing Bugfix: 22737974 -> Patch 27264965 Missing Bugfix: 23089357 -> Patch 23089357 Missing Bugfix: 23125826 -> Patch 23125826 Missing Bugfix: 23220453 -> Patch 31692949 Missing Bugfix: 23604553 -> Patch 27264965 Missing Bugfix: 23632545 -> Patch 31692949 Missing Bugfix: 24326444 -> Patch 31692949 Missing Bugfix: 24385983 -> Patch 31692949 Missing Bugfix: 24560906 -> Patch 24560906 Missing Bugfix: 24589081 -> Patch 31692949 Missing Bugfix: 25099339 -> Patch 31692949 Missing Bugfix: 25139545 -> Patch 27264965 Missing Bugfix: 25305405 -> Patch 25305405 Missing Bugfix: 25643931 -> Patch 25643931 Missing Bugfix: 25906117 -> Patch 25906117 Missing Bugfix: 25971286 -> Patch 31692949 Missing Bugfix: 26336977 -> Patch 31692949 Missing Bugfix: 26654363 -> Patch 31692949 Missing Bugfix: 26658759 -> Patch 31692949 Missing Bugfix: 26742604 -> Patch 27264965 Missing Bugfix: 26798411 -> Patch 31692949 Missing Bugfix: 27929509 -> Patch 31692949 Missing Bugfix: 27997875 -> Patch 31692949 Missing Bugfix: 28507324 -> Patch 28653113 Missing Bugfix: 28542455 -> Patch 29842421 Missing Bugfix: 29125374 -> Patch 29748518 Missing Bugfix: 30758943 -> Patch 30758943 Missing Bugfix: 31404014 -> Patch 31404014 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 29748518 - Filename: p29748518_121020_Linux-x86-64.zip Patch 18607546 - Filename: p18607546_121020_Linux-x86-64.zip Patch 31692949 - Filename: p31692949_121020_Linux-x86-64.zip Patch 22098146 - Filename: p22098146_121020_Linux-x86-64.zip Patch 18793246 - Filename: p18793246_121020_Generic.zip Patch 25599890 - Filename: p25599890_121020_Generic.zip Patch 28653113 - Filename: p28653113_121020_Generic.zip Patch 19068380 - Filename: p19068380_121020_Linux-x86-64.zip Patch 19291380 - Filename: p19291380_121020_Linux-x86-64.zip Patch 19472320 - Filename: p19472320_121020_Linux-x86-64.zip Patch 19835133 - Filename: p19835133_121020_Linux-x86-64.zip Patch 20093776 - Filename: p20093776_121020_Linux-x86-64.zip Patch 20181016 - Filename: p20181016_121020_Linux-x86-64.zip Patch 20294666 - Filename: p20294666_121020_Linux-x86-64.zip Patch 20766180 - Filename: p20766180_121020_Generic.zip Patch 20798891 - Filename: p20798891_121020_Linux-x86-64.zip Patch 20887355 - Filename: p20887355_121020_Generic.zip Patch 21153266 - Filename: p21153266_121020_Linux-x86-64.zip Patch 21321429 - Filename: p21321429_121020_Generic.zip Patch 21322448 - Filename: p21322448_121020_Linux-x86-64.zip Patch 21626377 - Filename: p21626377_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 22223463 - Filename: p22223463_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 29842421 - Filename: p29842421_121020_Linux-x86-64.zip Patch 30758943 - Filename: p30758943_121020_Linux-x86-64.zip Patch 31404014 - Filename: p31404014_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 31770871 [12.1.0.2.0 version] - EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR OCT 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 GOLD121 successfully. Finished checking fixes for Oracle Database: Thu Dec 17 20:44:53 IST 2020 Log file for this session: /media/sf_Downloads/R12210_RUP/log/checkDBpatch_3129.log ===============================================================================
As per the reports, Download and apply the patches mentioned.
Make sure Database and application services are down
[oracle@ebsupgrade 12.1.0.2]$ pwd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2 [oracle@ebsupgrade 12.1.0.2]$ ls p18607546_121020_Linux-x86-64.zip p20798891_121020_Linux-x86-64.zip p24560906_121020_Linux-x86-64.zip p18793246_121020_Generic.zip p20887355_121020_Generic.zip p25305405_121020_Linux-x86-64.zip p19068380_121020_Linux-x86-64.zip p21153266_121020_Linux-x86-64.zip p25599890_121020_Generic.zip p19291380_121020_Linux-x86-64.zip p21321429_121020_Generic.zip p25643931_121020_Linux-x86-64.zip p19393542_121020_Linux-x86-64.zip p21322448_121020_Linux-x86-64.zip p25906117_121020_Linux-x86-64.zip p19472320_121020_Linux-x86-64.zip p21626377_121020_Linux-x86-64.zip p27264965_121020_Linux-x86-64.zip p19591608_121020_Linux-x86-64.zip p21864513_121020_Linux-x86-64.zip p28653113_121020_Generic.zip p19627012_121020_Linux-x86-64.zip p21904072_121020_Linux-x86-64.zip p29748518_121020_Linux-x86-64.zip p19649152_121020_Linux-x86-64.zip p21967332_121020_Linux-x86-64.zip p29842421_121020_Linux-x86-64.zip p19835133_121020_Linux-x86-64.zip p22098146_121020_Linux-x86-64.zip p30758943_121020_Linux-x86-64.zip p20093776_121020_Linux-x86-64.zip p22223463_121020_Linux-x86-64.zip p31404014_121020_Linux-x86-64.zip p20181016_121020_Linux-x86-64.zip p22496904_121020_Linux-x86-64.zip p31692949_121020_Linux-x86-64.zip p20294666_121020_Linux-x86-64.zip p23089357_121020_Linux-x86-64.zip p8975044_121020_Linux-x86-64.zip p20766180_121020_Generic.zip p23125826_121020_Linux-x86-64.zip
unzip -o p8975044_121020_Linux-x86-64.zip unzip -o p27264965_121020_Linux-x86-64.zip unzip -o p29748518_121020_Linux-x86-64.zip unzip -o p18607546_121020_Linux-x86-64.zip unzip -o p31692949_121020_Linux-x86-64.zip unzip -o p22098146_121020_Linux-x86-64.zip unzip -o p18793246_121020_Generic.zip unzip -o p25599890_121020_Generic.zip unzip -o p28653113_121020_Generic.zip unzip -o p19068380_121020_Linux-x86-64.zip unzip -o p19291380_121020_Linux-x86-64.zip unzip -o p19472320_121020_Linux-x86-64.zip unzip -o p19835133_121020_Linux-x86-64.zip unzip -o p20093776_121020_Linux-x86-64.zip unzip -o p20181016_121020_Linux-x86-64.zip unzip -o p20294666_121020_Linux-x86-64.zip unzip -o p20766180_121020_Generic.zip unzip -o p20798891_121020_Linux-x86-64.zip unzip -o p20887355_121020_Generic.zip unzip -o p21153266_121020_Linux-x86-64.zip unzip -o p21321429_121020_Generic.zip unzip -o p21322448_121020_Linux-x86-64.zip unzip -o p21626377_121020_Linux-x86-64.zip unzip -o p21864513_121020_Linux-x86-64.zip unzip -o p21904072_121020_Linux-x86-64.zip unzip -o p21967332_121020_Linux-x86-64.zip unzip -o p22223463_121020_Linux-x86-64.zip unzip -o p22496904_121020_Linux-x86-64.zip unzip -o p23089357_121020_Linux-x86-64.zip unzip -o p23125826_121020_Linux-x86-64.zip unzip -o p24560906_121020_Linux-x86-64.zip unzip -o p25305405_121020_Linux-x86-64.zip unzip -o p25643931_121020_Linux-x86-64.zip unzip -o p25906117_121020_Linux-x86-64.zip unzip -o p29842421_121020_Linux-x86-64.zip unzip -o p30758943_121020_Linux-x86-64.zip unzip -o p31404014_121020_Linux-x86-64.zip
export PATH=$PATH:$ORACLE_HOME/OPatch
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/8975044 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/27264965 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/29748518 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/18607546 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/31692949 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/22098146 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/18793246 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/25599890 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/28653113 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/19068380 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/19291380 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/19472320 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/19835133 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/20093776 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/20181016 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/20294666 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/20766180 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/20798891 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/20887355 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/21153266 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/21321429 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/21322448 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/21626377 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/21864513 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/21904072 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/21967332 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/22223463 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/22496904 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/23089357 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/23125826 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/24560906 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/25305405 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/25643931 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/25906117 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/29842421 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/30758943 opatch apply cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/12.1.0.2/31404014 opatch apply
Apply all patches and once applied start the DB and run the below command.
[oracle@ebsupgrade OPatch]$ cd $ORACLE_HOME/OPatch
[oracle@ebsupgrade OPatch]$ ./datapatch
SQL Patching tool version 12.2.0.0.0 on Thu Dec 17 23:31:57 2020
Copyright (c) 2014, Oracle. All rights reserved.
Connecting to database...OK
Determining current state...done
Adding patches to installation queue and performing prereq checks...done
Installation queue:
Nothing to roll back
The following patches will be applied:
18793246 ()
20887355 ()
21321429 ()
22098146 ()
25599890 ()
27264965 ()
28653113 ()
catcon: ALL catcon-related output will be written to /tmp/sqlpatch_catcon__catcon_18082.lst
catcon: See /tmp/sqlpatch_catcon_*.log files for output generated by scripts
catcon: See /tmp/sqlpatch_catcon__*.lst files for spool files, if any
Installing patches...
Patch installation complete. Total patches installed: 7
Validating logfiles...done
SQL Patching tool complete on Thu Dec 17 23:46:02 2020
Restart the Database and re-run the checkDBpatch.sh again to make sure all patches at DB level are applied.
2) Set the database parameters
optimizer_adaptive_features=false
_disable_actualization_for_grant=true
SQL> alter system set optimizer_adaptive_features=false; System altered. SQL> show parameter optimizer_adaptive_features NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ optimizer_adaptive_features boolean FALSE SQL> alter system set "_disable_actualization_for_grant"=true; System altered. SQL> show parameter _disable_actualization_for_grant NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ _disable_actualization_for_grant boolean TRUE
3)Apply Consolidated Seed Table Upgrade Patch (Required)
Note: You can skip this step if you have upgraded to Release 12.2.0 using the latest Consolidated Upgrade Patch 30399970:12.2.0 (CUP11) or earlier Consolidated Upgrade Patches:
Patch 28853097:12.2.0 (CUP10)
Patch 26924710:12.2.0 (CUP9)
Patch 24690520:12.2.0 (CUP8)
Stop all application tier services on the run file system.
sh $ADMIN_SCRIPTS_HOME/adstpall.sh
Start-up only the Oracle Weblogic Admin Server on the run file system.
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
Apply the consolidated seed table upgrade Patch 26787701:12.2.0 on the run file system using adop hotpatch mode.
[applmgr@ebsupgrade patch]$ adop phase=apply patches=26787701 hotpatch=yes
Validate the patch is applied successfully and move ahead to the next step.
4) Apply the Latest AD and TXK Delta Release Update Packs
The latest RUPs are R12.AD.C.Delta.12 (Patch 30628681) and R12.TXK.C.Delta.12 (Patch 30735865).
Source the run edition environment file.
Start-up only the Oracle Weblogic Admin Server on the run edition application tier file system.
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
Execute adgrants by following the instructions in the readme of Patch 30628681, which includes the latest version of adgrants.
On the run edition application tier file system, apply Patch 30628681 (R12.AD.C.Delta.12) in hotpatch mode.
Note: Do not merge Patch 30628681 with any other patches.
[applmgr@ebsupgrade 30628681]$ adop phase=apply patches=30628681 hotpatch=yes
No AD critical patches were available to be applied.
Apply Patch 30735865 (R12.TXK.C.Delta.12) (plus any additional critical patches)
[applmgr@ebsupgrade 30735865]$ adop phase=apply patches=30735865 hotpatch=yes
[applmgr@ebsupgrade patch]$ adop phase=apply patches=31904550 merge=yes hotpatch=yes
Verify all patches are applied successfully.
5) Apply other important patches
Apply Patch 19259764:R12.FND.C.
[applmgr@ebsupgrade patch]$ adop phase=apply patches=19259764 hotpatch=yes
6) Run the Middle Tier EBS Technology Codelevel Checker (MT-ETCC) on the run file system.
Source run file system
EBSapps.env run
Run the MT-ETCC utility checkMTpatch.sh
[applmgr@ebsupgrade R12210_RUP]$ ./checkMTpatch.sh
All reported patches can be applied later for Middle Tier application.
7) Apply RUP for 12.2.10
Source the run edition applications environment.
Stop Oracle WebLogic Server's Admin Server and Node Manager services.
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
Apply Oracle E-Business Suite 12.2.10 Release Update Pack Patch 30399999 on the run edition application environment, using downtime mode.
[applmgr@ebsupgrade patch]$ adop phase=apply apply_mode=downtime patches=30399999
It took 14 hrs to complete for me.
8) Complete the patching cycle by running the following commands in the order.
. /tarmachin/EBS12210/GOLD/APPS/EBSapps.env run
[applmgr@ebsupgrade ~]$ adop phase=cleanup
9) Apply Oracle E-Business Suite Release 12.2.10 Online Help Patch 30399996 using adop hotpatch mode on the run file system.
Please note new patching cycle session will be opened at this stage. Make sure are tablespaces have sufficient free space.
[applmgr@ebsupgrade ~]$ adop phase=apply patches=30399996 hotpatch=yes
[applmgr@ebsupgrade ~]$ adop phase=cleanup
10) Update Database Tier to Latest Code
On the application tier (as the applmgr user):
Source the run edition environment file.
. <EBS_ROOT>/EBSapps.env run
perl $AD_TOP/bin/admkappsutil.pl
Copy or FTP the appsutil.zip file to <RDBMS ORACLE_HOME>.
Uncompress appsutil.zip, under <RDBMS ORACLE_HOME>.
$ cd <ORACLE_HOME>
$ unzip -o appsutil.zip
Run AutoConfig on <RDBMS ORACLE_HOME>.
Run AutoConfig on the Application run file system.
As the applmgr user, run AutoConfig on all application tier nodes by executing whichever of these commands applies to your system:
UNIX:
$ sh <INST_TOP>/admin/scripts/adautocfg.sh
[applmgr@ebsupgrade scripts]$ ./adautocfg.sh Enter the APPS user password: The log file for this session is located at: /tarmachin/EBS12210/GOLD/APPS/fs1/inst/apps/GOLD121_ebsupgrade/admin/log/12191111/adconfig.log wlsDomainName: EBS_domain_GOLD121 WLS Domain Name is VALID. AutoConfig is configuring the Applications environment... AutoConfig will consider the custom templates if present. Using CONFIG_HOME location : /tarmachin/EBS12210/GOLD/APPS/fs1/inst/apps/GOLD121_ebsupgrade Classpath : /tarmachin/EBS12210/GOLD/APPS/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/tarmachin/EBS12210/GOLD/APPS/fs1/EBSapps/comn/java/classes Using Context file : /tarmachin/EBS12210/GOLD/APPS/fs1/inst/apps/GOLD121_ebsupgrade/appl/admin/GOLD121_ebsupgrade.xml Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database...COMPLETED Configuring templates from all of the product tops... Configuring AD_TOP........COMPLETED Configuring FND_TOP.......COMPLETED Configuring ICX_TOP.......COMPLETED Configuring MSC_TOP.......COMPLETED Configuring IEO_TOP.......COMPLETED Configuring BIS_TOP.......COMPLETED Configuring CZ_TOP........COMPLETED Configuring SHT_TOP.......COMPLETED Configuring AMS_TOP.......COMPLETED Configuring CCT_TOP.......COMPLETED Configuring WSH_TOP.......COMPLETED Configuring CLN_TOP.......COMPLETED Configuring OKE_TOP.......COMPLETED Configuring OKL_TOP.......COMPLETED Configuring OKS_TOP.......COMPLETED Configuring CSF_TOP.......COMPLETED Configuring IBY_TOP.......COMPLETED Configuring JTF_TOP.......COMPLETED Configuring MWA_TOP.......COMPLETED Configuring CN_TOP........COMPLETED Configuring CSI_TOP.......COMPLETED Configuring WIP_TOP.......COMPLETED Configuring CSE_TOP.......COMPLETED Configuring EAM_TOP.......COMPLETED Configuring GMF_TOP.......COMPLETED Configuring PON_TOP.......COMPLETED Configuring FTE_TOP.......COMPLETED Configuring ONT_TOP.......COMPLETED Configuring AR_TOP........COMPLETED Configuring AHL_TOP.......COMPLETED Configuring IES_TOP.......COMPLETED Configuring OZF_TOP.......COMPLETED Configuring CSD_TOP.......COMPLETED Configuring IGC_TOP.......COMPLETED AutoConfig completed successfully.
11) Synchronize the file systems.
adop phase=fs_clone
This completed update to R12.2.10. Verify all services
SQL> select release_name from apps.fnd_product_groups; RELEASE_NAME -------------------------------------------------- 12.2.10
Known Issues:
References:
Oracle E-Business Suite Release 12.2.10 Readme (Doc ID 2666934.1)
Document 1617461.1, Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2, and follow the instructions to apply the required codelevel of AD and TXK for your system.
17 Comments
Thanks for sharing your experience.
ReplyDeleteI have some concerns about what you've suggested below:
adop phase=apply patches=31904550 merge=yes hotpatch=yes
In “Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)” it's adviced to apply Patch 31904550:R12.TXK.C (Section 4.2, Critical TXK Patches) as follows:
adop phase=apply patches=30735865,31904550 hotpatch=yes merge=yes
Hi,
DeleteYes I understood, I just applied them separately. As I do all these steps on my test server so I try to check various combinations and how they impact the steps.
Regards,
Nice document bro
ReplyDeleteapply patch 17537119
ReplyDelete###########
error :
-----
opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/oracle/product/12102
Central Inventory : /home/oracle/oraInventory
from : /u01/oracle/product/12102/oraInst.loc
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : /u01/oracle/product/12102/cfgtoollogs/opatch/opatch2017-09-12_15-30-47PM_1.log
List of Homes on this system:
Home name= agent13c2, Location= "/u01/oracle/product/agent13c/agent_13.2.0.0.0"
Home name= 11204, Location= "/u01/oracle/product/11204"
Home name= OraHome3, Location= "/u01/oracle/product/gg121"
Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
Oracle Home dir. path does not exist in Central Inventory
Oracle Home is a symbolic link
Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo
OPatch failed with error code 73
solution :
---------
took backup of oraInventory contents
becuase two oraInventory directories were created so rm -rf oraInventory*
mkdir -p /u01/app/oracle/oraInventory
copied oraInventory contents from backup to this newly created directory
$ORACLE_HOME/oui/bin/runInstaller -silent -ignoreSysPrereqs -invPtrLoc "/u01/app/oracle/db/tech_st/12.1.0/oraInst.loc" -attachHome ORACLE_HOME="/u01/app/oracle/db/tech_st/12.1.0" ORACLE_HOME_NAME="Ora12cHome"
ReplyDeleteadop phase=apply patches=30735865 hotpatch=yes workers=10
error for patch
Validating system setup.
Node registry is valid.
[WARNING] SYS.DUAL table has incorrect privileges
Shut down the application tier services and then run the following commands in the order shown
sqlplus apps/ @ $AD_TOP/patch/115/sql/ADFIXUSER.sql
sqlplus apps/ @ $AD_TOP/sql/adutlrcmp.sql
[ERROR] ETCC not run in the database node prod
The EBS Technology Codelevel Checker needs to be run on the database node.
It is available as Patch 17537119.
[WARNING] MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.
Encountered the above errors when performing database validations.
Resolve the above errors and restart adop.
[STATEMENT] Please run adopscanlog utility, using the command
"adopscanlog -latest=yes"
to get the list of the log files along with snippet of the error message corresponding to each log file.
adop exiting with status = 1 (Fail)
--------
solution :
bounce apps and db services
sqlplus apps/ @ $AD_TOP/patch/115/sql/ADFIXUSER.sql
sqlplus apps/ @ $AD_TOP/sql/adutlrcmp.sql
SQL> select NODE_NAME from applsys.txk_tcc_results;
NODE_NAME
--------------------------------------------------------------------------------
prod
prod
prod
prod
prod
prod
prod.oracledba.org
7 rows selected.
UPDATE applsys.txk_tcc_results SET node_name ='prod' where NODE_NAME='prod.oracledba.org';
1 row updated.
SQL> commit;
rerun above patch :
adop phase=apply patches=30735865 hotpatch=yes workers=10
u dont need to press Y twice for each patch with below method . copy paste all once or 1 by1 u can as well but keep an eye for error .
ReplyDelete. /u01/app/oracle/db/tech_st/12.1.0/PROD_prod.env
export PATH=$PATH:$ORACLE_HOME/OPatch
cd /u01/app/oracle/db/tech_st/12.1.0/Opatch
opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/8975044
opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/27264965
opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/29748518
opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/18607546
opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/31692949
opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/22098146
opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/18793246
opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/25599890
opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/28653113
opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/19068380
opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/19291380
opatch apply -oh /u01/app/oracle/db/tech_st/12.1.0 -local -silent /u02/R12_upgrade/R12.2.0_R12.2.10/19472320
Thanks for your beautifull presentation.
ReplyDeleteThank you for detailed explanation.
ReplyDeleteI am also upgrading 12.1.3 to 12.2.10, upgrade went well and able to access the application through application server url.
But failed to access through load balancer, error message "Invalid redirect has been blocked".
Updated following context parameters
"s_external_url"
"s_webentryhost"
"s_webentrydomain"
"s_login_page"
“s_webentryurlprotocol”
“s_active_webport”
"s_enable_sslterminator"
Any idea , what is the issue
what is working before upgrade. Have you checked the patches required for R12.2.10
Deletes_url_protocol
Deletes_local_url_protocol
s_webentryurlprotocol
s_active_webport
s_webssl_port
s_https_listen_parameter
s_login_page
s_external_url
Yes, I able to access the application using the below URL
ReplyDeletehttps://XXXXX.com/OA_HTML/RF.jsp?function_id=31645&resp_id=-1&resp_appl_id=-1&security_group_id=0&lang_code=US&oas=6OXZu5iX1LEIuCj8xJLQlA..¶ms=KQ0ueFd3h5ncJDQ0.532EQ.
Using the above URL login page is appearing , after login application working normally.
But OA_HTML/AppsLocalLogin.jsp is not accessible
AppsLocalLogin.jsp file is present on server, if yes please try to recompile the jsp.
DeleteYes ,AppsLocalLogin.jsp is in folder $OA_HTML
ReplyDeletehtml]$ ls -ltr AppsLocalLogin.jsp
-rw-r--r--. 1 oracle oinstall 4358 Nov 9 12:34 AppsLocalLogin.jsp
And related runtime classes are available in $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pages folder
_pages]$ ls -ltr *appslocallo*
-rw-r--r--. 1 oracle oinstall 9112 Nov 9 14:45 __appslocallogout.class
-rw-r--r--. 1 oracle oinstall 10151 Nov 9 14:58 __appslocallogin.class
Recompiled all jsp , but no luck. Only this /OA_HTML/AppsLocalLogin.jsp is not working. Otherwise application is working without any issue.
Is there any special setup in $FND_TOP/secure?
Regards
Satheesh
Thanks Himanshu . A good reference.
ReplyDeletefrom 12.2.0 onwards no need to stop the application tier for ETCC and TXK patches during the patching activity. i tried and it worked
ReplyDeleteYou are referring to online patching or hotpatch mode?
DeleteGetting below error after apply etcc application patches while starting application. URL not accessible-
ReplyDelete[applmgr@testerp scripts]$ ./adapcctl.sh startall
You are running adapcctl.sh version 120.0.12020000.2
opmnctl startall: starting opmn and all managed processes...
================================================================================
opmn id=testerp.txis.com:6207
Response: 0 of 1 processes started.
ias-instance id=EBS_web_TEST_OHS1
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
EBS_web_TEST/OHS/OHS/
Error
--> Process (index=1,uid=1919571417,pid=29429)
failed to start a managed process after the maximum retry limit
Log:
/data/TEST/apps/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/diagnostics/logs/OHS/EBS_web_TEST/console~OHS~1.log
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /data/TEST/apps/fs1/inst/apps/TEST_testerp/logs/appl/admin/log/adapcctl.txt for more information ...
Post a Comment