For Any queries, please mail us at support@funoracleapps.com

Oracle EBS Release Update Steps from 12.2.0 to R12.2.10

No comments

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:
EBS version:  R12.2.0

SQL> select release_name from apps.fnd_product_groups;


Make sure DB and Listener are running


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:

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

Connecting to database. 
Database connection successful. 

Database GOLD121 is in READ WRITE mode.

Identifying APPS and APPLSYS schema names. 
 - APPS schema : APPS

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

Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.

The opatch utility is version
DB-ETCC is compatible with this opatch version.

Found patch records in the inventory.

Checking Mapping XML file for

  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.

The default patch recommendations to install these missing bugfixes are:
Oracle Database Release  (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 is available on My Oracle Support via:

  Patch 31770871 [ version]

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]$ pwd
[oracle@ebsupgrade]$ 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

cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
opatch apply
cd /media/sf_Downloads/R12210_RUP/etcc-bundle/LINUX_X86-64/database/ 
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 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


SQL> alter system set optimizer_adaptive_features=false;

System altered.

SQL> show parameter optimizer_adaptive_features

------------------------------------ ----------- ------------------------------
optimizer_adaptive_features	     boolean	 FALSE

SQL> alter system set "_disable_actualization_for_grant"=true;

System altered.

SQL> show parameter _disable_actualization_for_grant

------------------------------------ ----------- ------------------------------
_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>.
$ 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:

$ 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;


Known Issues:


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.

If you like please follow and comment

No comments :

Post a Comment