Step by Step instruction on EBS R12.1.3 upgrade to R12.2.0

In this post, I am going to share step-by-step instructions on upgrading EBS R12.1.3 to R12.2.

My Source Application version: R12.1.3
Database version: 12.1.0.2

Make sure the Database is up and running and Application services are down for 12.1.3.


1) Download the R12.2.0 software zip and keep on the server.(How to Download EBS 12.2.0)


2) Add Service ebs_patch in EBS Database



[oracle@ebsupgrade 12.1.0]$ sqlplus '/as sysdba'

SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 10 21:13:21 2020

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL>  show parameter service

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
service_names			     string	 GOLD121
SQL> show parameter spfile;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
spfile				     string	 /tarmachin/EBS1213/GOLD/DB/tec
						 h_st/12.1.0/dbs/spfileGOLD121.
						 ora
SQL> alter system set service_names='GOLD121,ebs_patch' scope=both;

System altered.

SQL> show parameter service

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
service_names			     string	 GOLD121,ebs_patch

3) Download Patch 17537119 on the server and run as below. No need to apply the patches as recommended for now.


[oracle@ebsupgrade EBS1213_1220_upgrade_patches]$ pwd
/media/sf_Downloads/EBS1213_1220_upgrade_patches
[oracle@ebsupgrade EBS1213_1220_upgrade_patches]$ ls
checkDBpatch.cmd  checkDBpatch.sh  checkMTpatch.cmd  checkMTpatch.sh  db  mw  p17537119_R12_GENERIC.zip  README.txt
[oracle@ebsupgrade EBS1213_1220_upgrade_patches]$ ./checkDBpatch.sh contextfile=$CONTEXT_FILE

 +===============================================================+ 
 |    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 command line argument:
/tarmachin/EBS1213/GOLD/DB/tech_st/12.1.0/appsutil/GOLD121_ebsupgrade.xml


Starting Database EBS Technology Codelevel Checker, Version 120.82 
Thu Dec 10 22:36:35 IST 2020
Log file for this session : /media/sf_Downloads/EBS1213_1220_upgrade_patches/log/checkDBpatch_7817.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. 
Creating DB-ETCC results table. 
Created the table to store DB-ETCC results.


4) Setup new layout for R12.2 file system. Login as root and go to the directory where the EBS12.2.0 zip files are kept and run rapidwiz.


[root@ebsupgrade APPS12.2]# pwd
/tarmachin/EBS12210/software/APPS12.2
[root@ebsupgrade APPS12.2]# ls
V100052-01_1of3.zip  V100060-01_1of3.zip  V29856-01.zip       V35804-01_1of2.zip
V100052-01_2of3.zip  V100060-01_2of3.zip  V35802-01.zip       V35804-01_2of2.zip
V100052-01_3of3.zip  V100060-01_3of3.zip  V35803-01_1of3.zip  V46095-01_1of2.zip
V100059-01_1of2.zip  V100061-01.zip       V35803-01_2of3.zip  V46095-01_2of2.zip
V100059-01_2of2.zip  V100102-01.zip       V35803-01_3of3.zip  V75792-01.zip


Patching the Stage Area

After running the buildStage script, you should patch the stage area with the latest consolidated fixes since the release of the current StartCD. For StartCD 12.2.0.51, the consolidated fixes are delivered in Patch 25525148.

Download Patch 25525148.

Unzip this patch using the following command:

unzip p25525148_R12_GENERIC.zip.Change to the 25525148 directory.

Patch the stage area using the following commands:

UNIX:

sh patchRIStage.sh

When prompted for the location of the Rapid Install stage, enter the path to the stage area you created for StartCD 12.2.0.51.

Tip: Run the script as the same user(root) that you used to run the buildStage script when creating the stage area.

[root@ebsupgrade 25525148]# ./patchRIStage.sh
Patch directory is /media/sf_Downloads/EBS1213_1220_upgrade_patches/25525148

Enter the location of the Rapid Install Stage area:/tarmachin/EBS12210/software/APPS12.2
Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/25525148/Disk1/rapidwiz/template/adrun12c.sh to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/adrun12c.sh.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/25525148/Disk1/rapidwiz/template/adrundb.sh to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/adrundb.sh.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/25525148/Disk1/rapidwiz/template/adrunat.sh to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/adrunat.sh.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/25525148/Disk1/rapidwiz/etc/appsutil.zip to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/etc/appsutil.zip.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/25525148/Disk1/rapidwiz/etc/adlsnr10RAC.ora to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/etc/adlsnr10RAC.ora.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/25525148/Disk1/rapidwiz/jlib/java/oracle/apps/ad/tools/configuration/RACAutoConfig.class to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/tools/configuration/RACAutoConfig.class.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/25525148/Disk1/rapidwiz/jlib/java/oracle/apps/ad/tools/configuration/RACAutoConfig$ClusterCmdHolder.class to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/tools/configuration/RACAutoConfig$ClusterCmdHolder.class.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/25525148/Disk1/rapidwiz/etc/admerge.pl to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/etc/admerge.pl.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/25525148/Disk1/rapidwiz/template/afinit_db121.ora to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/afinit_db121.ora.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/25525148/Disk1/rapidwiz/template/afinit_db121RAC.ora to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/afinit_db121RAC.ora.

Completed patching of the Rapid Install Stage area /tarmachin/EBS12210/software/APPS12.2

Finally, apply the additional Rapid Install patch, Patch 31033613. 
Patch 25525148 should be applied Patch 31033613.

Download Patch 31033613 from My Oracle Support.

Unzip this patch using the following command:

unzip p31033613_R12_GENERIC.zip
Change to the 31033613 directory.

Patch the Rapid Install stage area using the following commands:

UNIX:

sh patchRIStage.sh


When prompted for the location of the Rapid Install stage, enter the path to the stage area you created for StartCD 12.2.0.51.

[root@ebsupgrade 31033613]# ./patchRIStage.sh
Patch directory is /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613

Enter the location of the Rapid Install Stage area:/tarmachin/EBS12210/software/APPS12.2
Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/template/adcfgdeploy.sh to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/adcfgdeploy.sh.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/template/adcfgdeploy.cmd to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/adcfgdeploy.cmd.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/template/adrundeploy.cmd to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/adrundeploy.cmd.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/template/adrundb.sh to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/adrundb.sh.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/template/adrundb.cmd to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/adrundb.cmd.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/template/adrunat.sh to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/adrunat.sh.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/template/adrunat.cmd to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/adrunat.cmd.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/template/adrunfmw.cmd to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/adrunfmw.cmd.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/template/adsetpass.sh to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/adsetpass.sh.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/template/adsetpass.cmd to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/template/adsetpass.cmd.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/etc/afcpctx.sh to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/etc/afcpctx.sh.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/etc/afcpctx.cmd to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/etc/afcpctx.cmd.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/bin/riwTDBup.sh to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/bin/riwTDBup.sh.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/bin/riwTDBup.cmd to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/bin/riwTDBup.cmd.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/etc/adstartallmanaged.cmd to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/etc/adstartallmanaged.cmd.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/etc/oamksvc.obj to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/etc/oamksvc.obj.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/etc/OAMKSVC.exe to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/etc/OAMKSVC.exe.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/etc/adwindowsservicesuser.cmd to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/etc/adwindowsservicesuser.cmd.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/etc/adsvNodeManager.cmd to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/etc/adsvNodeManager.cmd.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/etc/igccmprf.cmd to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/etc/igccmprf.cmd.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/jlib/java/oracle/apps/ad/rapidwiz/data/AppsInstall.class to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/rapidwiz/data/AppsInstall.class.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/jlib/java/oracle/apps/ad/clone/util/OracleHomeCloner.class to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/clone/util/OracleHomeCloner.class.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/jlib/java/oracle/apps/ad/clone/util/OracleHomeCloner$AbsorbPrintStream.class to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/clone/util/OracleHomeCloner$AbsorbPrintStream.class.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/jlib/java/oracle/apps/ad/rapidwiz/util/CheckerClass.class to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/rapidwiz/util/CheckerClass.class.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess.class to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess.class.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess$TimedProcessProcess.class to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess$TimedProcessProcess.class.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess$AsyncStreamReader.class to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess$AsyncStreamReader.class.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess$TimedProcessTimer.class to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/jlib/java/oracle/apps/ad/util/TimedProcess$TimedProcessTimer.class.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/etc/txkManageDBConnectionPool.pl to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/etc/txkManageDBConnectionPool.pl.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/TechInstallers/ASInstallHome/fnd/patch/115/etc/txkUpdateBSU.sh to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/TechInstallers/ASInstallHome/fnd/patch/115/etc/txkUpdateBSU.sh.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/TechInstallers/ASInstallHome/fnd/patch/115/etc/txkUpdateBSU.cmd to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/TechInstallers/ASInstallHome/fnd/patch/115/etc/txkUpdateBSU.cmd.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/etc/Java.pm to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/etc/Java.pm.

Copied /media/sf_Downloads/EBS1213_1220_upgrade_patches/31033613/Disk1/rapidwiz/etc/TechstackDB.pm to /tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz/etc/TechstackDB.pm.

Completed patching of the Rapid Install Stage area /tarmachin/EBS12210/software/APPS12.2

Give 777 permission to stage location.

[root@ebsupgrade rapidwiz]# cd /tarmachin/EBS12210
[root@ebsupgrade EBS12210]# ls -ltr
total 8
drwxr-xr-x. 3 root    root     4096 Dec 10 21:01 software

[root@ebsupgrade EBS12210]# chmod -R 777 software
[root@ebsupgrade EBS12210]# ls -ltrr
total 8
drwxrwxrwx. 3 root    root     4096 Dec 10 21:01 software



Now kick-off Rapidwiz from root user.
[root@ebsupgrade rapidwiz]# pwd
/tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz
[root@ebsupgrade rapidwiz]# ls
bin            etc     jlib  rapidwiz      RapidWizVersion      template
ClientWiz.cmd  File    jre   RapidWiz.cmd  RapidWizVersion.cmd  unzip
driver         images  oui   RapidWiz.ini  TechInstallers       Xpatches
[root@ebsupgrade rapidwiz]# ./rapidwiz 

Click Next


Select the upgrade Option


Uncheck the security updates click next then click yes.


Select Create a new Upgrade File System


Select Port Pool for file system 1 same as the one used for R12.1


Select details for current R12.1.3 database details and check option as use existing Oracle Home


Make sure all passwords for correct.


a) Selected Languages: American_English-US 
b) Default Territory: AMERICA 
c) Database Character Set: AL32UTF8 
d) APPL_TOP Character Set: AL32UTF8 
e) IANA Character Set: UTF-8


Provide a path where the file system layout for R12.2 will be installed. I am using a different folder for the same. "/tarmachin/EBS12210"


Give a password that need to be set for the weblogic and the correct password for applmgr OS user.





As soon as you click next it will do a pre-check to validate. 



Please ignore the Technology CodeCheck, These patches we will apply later and proceed as per the below screenshots.










It took 4 hrs for me to complete. Click finish once completed.



Verify the new EBS12.2 file system layout has been created.

[applmgr@ebsupgrade APPS]$ pwd
/tarmachin/EBS12210/GOLD/APPS
[applmgr@ebsupgrade APPS]$ ls -ltr
total 12
drwxr-xr-x. 5 applmgr oinstall 4096 Dec 11 00:34 fs1
drwxr-xr-x. 5 applmgr oinstall 4096 Dec 11 00:34 fs2
drwxr-xr-x. 4 applmgr oinstall 4096 Dec 11 03:14 fs_ne

5) Enable the maintenance mode by setting the environment file from the new EBS12.2 file system. Please use fs1 only as it will be the run file system.


/tarmachin/EBS12210/GOLD/APPS/fs1/EBSapps/appl
[applmgr@ebsupgrade appl]$ ls -ltr APPSGOLD121_ebsupgrade.env 
-rw-r--r--. 1 applmgr oinstall 1112 Dec 11 05:46 APPSGOLD121_ebsupgrade.env
[applmgr@ebsupgrade appl]$ . APPSGOLD121_ebsupgrade.env
[applmgr@ebsupgrade appl]$ adadmin



            AD Administration Main Menu
   --------------------------------------------------

   1.    Generate Applications Files menu

   2.    Maintain Applications Files menu

   3.    Compile/Reload Applications Database Entities menu

   4.    Maintain Applications Database Entities menu

   5.    Change Maintenance Mode

   6.    Exit AD Administration


Select option 5 and then select option 1. Once maintenance mode is set, please exit.

Enter your choice [6] : 5

             Change Maintenance Mode
   ----------------------------------------

Maintenance Mode is currently: [Disabled].


Maintenance mode should normally be enabled when patching
Oracle E-Business Suite and disabled when users are logged on
to the system.  See the Oracle E-Business Suite Maintenance
Utilities manual for more information about maintenance mode.


Please select an option:

   1.    Enable Maintenance Mode

   2.    Disable Maintenance Mode

   3.    Return to Main Menu
Enter your choice [3] : 1

sqlplus -s &un_apps/***** @/tarmachin/EBS12210/GOLD/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE

Successfully enabled Maintenance Mode.


6) Apply AD 12.2 Upgrade Driver



Download below patches and need to be applied
10117518
22742061

Connect as database user, source the environment file and Create
$ORACLE_HOME/appsutil/admin if not present.

[oracle@ebsupgrade ~]$ . GOLD121_ebsupgrade.env
[oracle@ebsupgrade ~]$ cd $ORACLE_HOME/appsutil
[oracle@ebsupgrade appsutil]$ ls -ld admin
drwxr-xr-x. 2 oracle oinstall 4096 Dec  9 18:16 admin
Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin to that in patch directory.
Copy the higher version of adgrants.sql (UNIX) to $ORACLE_HOME/appsutil/admin.

Set the environment to point to ORACLE_HOME on the database server.

sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPS schema name>

[applmgr@ebsupgrade admin]$ pwd
/media/sf_Downloads/EBS1213_1220_upgrade_patches/10117518/admin
[applmgr@ebsupgrade admin]$ adident Header adgrants.sql
adgrants.sql:
$Header adgrants.sql 120.67.12020000.8 2012/10/05 15:19:21 sstomar ship $
$Header adgrants.sql 120.67.12020000.8 2012/10/05 15:19:21 sstomar ship $
$Header adgrants.sql 120.67.12020000.8 2012/10/05 15:19:21 sstomar ship $
$Header adgrants.sql 120.67.12020000.8 2012/10/05 15:19:21 sstomar ship $
$Header adgrants.sql 120.67.12020000.8 2012/10/05 15:19:21 sstomar ship $
[applmgr@ebsupgrade admin]$ ls -ltr /tarmachin/EBS12210/GOLD/APPS/fs1/EBSapps/appl/admin/adgrants.sql
-rwxr-xr-x. 1 applmgr oinstall 96710 Nov 24  2012 /tarmachin/EBS12210/GOLD/APPS/fs1/EBSapps/appl/admin/adgrants.sql
[applmgr@ebsupgrade admin]$ adident Header /tarmachin/EBS12210/GOLD/APPS/fs1/EBSapps/appl/admin/adgrants.sql
/tarmachin/EBS12210/GOLD/APPS/fs1/EBSapps/appl/admin/adgrants.sql:
$Header adgrants.sql 120.67.12020000.8 2012/10/05 15:19:21 sstomar ship $
$Header adgrants.sql 120.67.12020000.8 2012/10/05 15:19:21 sstomar ship $
$Header adgrants.sql 120.67.12020000.8 2012/10/05 15:19:21 sstomar ship $
$Header adgrants.sql 120.67.12020000.8 2012/10/05 15:19:21 sstomar ship $
$Header adgrants.sql 120.67.12020000.8 2012/10/05 15:19:21 sstomar ship $
[applmgr@ebsupgrade admin]$ cd ../../22742061/admin/
[applmgr@ebsupgrade admin]$ ls -ltr
total 300
-rwxrwx---. 1 root vboxsf  9580 Jan  1  2002 Preinstall_Codelevel_MP.txt
-rwxrwx---. 1 root vboxsf  3717 Jan  1  2002 adsysapp2.sql
-rwxrwx---. 1 root vboxsf 97806 Jan  1  2002 adgrants.sql
-rwxrwx---. 1 root vboxsf 97741 Jan  1  2002 adgrants_nt.sql
-rwxrwx---. 1 root vboxsf 92139 Jan  1  2002 adddlb.pls
[applmgr@ebsupgrade admin]$ adident Header adgrants.sql
adgrants.sql:
$Header adgrants.sql 120.67.12020000.36 2015/07/16 09:22:15 absandhw ship $
$Header adgrants.sql 120.67.12020000.36 2015/07/16 09:22:15 absandhw ship $
$Header adgrants.sql 120.67.12020000.36 2015/07/16 09:22:15 absandhw ship $
$Header adgrants.sql 120.67.12020000.36 2015/07/16 09:22:15 absandhw ship $
$Header adgrants.sql 120.67.12020000.36 2015/07/16 09:22:15 absandhw ship $


Copy adgrants from 22742061 to DB oracle home.

[oracle@ebsupgrade 10117518]$ cd /media/sf_Downloads/EBS1213_1220_upgrade_patches/22742061/admin
[oracle@ebsupgrade admin]$ ls -ltr
total 300
-rwxrwx---. 1 root vboxsf  9580 Jan  1  2002 Preinstall_Codelevel_MP.txt
-rwxrwx---. 1 root vboxsf  3717 Jan  1  2002 adsysapp2.sql
-rwxrwx---. 1 root vboxsf 97806 Jan  1  2002 adgrants.sql
-rwxrwx---. 1 root vboxsf 97741 Jan  1  2002 adgrants_nt.sql
-rwxrwx---. 1 root vboxsf 92139 Jan  1  2002 adddlb.pls
[oracle@ebsupgrade admin]$ cp adgrants.sql /tarmachin/EBS1213/GOLD/DB/tech_st/12.1.0/appsutil/admin/
[oracle@ebsupgrade admin]$ sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Fri Dec 11 18:24:42 2020

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql apps

We will need to merge both patches and apply. Remember the source environment is set from fs1.

Create AD_source and AD_target directory and copy both patches to AD_source. Make sure the owner of directories is applmgr.

[applmgr@ebsupgrade patches]$ admrgpch -s /tarmachin/patches/AD_source -d /tarmachin/patches/AD_target -merge_name ad_cup7_patch -admode

Executing the merge of the patch drivers
 -- Processing patch: /tarmachin/patches/AD_source/22742061
 -- Processing file: /tarmachin/patches/AD_source/22742061/u22742061.drv
 -- Done processing file: /tarmachin/patches/AD_source/22742061/u22742061.drv
 -- Done processing patch: /tarmachin/patches/AD_source/22742061

 -- Processing patch: /tarmachin/patches/AD_source/10117518
 -- Processing file: /tarmachin/patches/AD_source/10117518/u10117518.drv
 -- Done processing file: /tarmachin/patches/AD_source/10117518/u10117518.drv
 -- Done processing patch: /tarmachin/patches/AD_source/10117518



Copying files...

5% complete. Copied 47 files of 925...
10% complete. Copied 93 files of 925...
15% complete. Copied 139 files of 925...
20% complete. Copied 185 files of 925...
25% complete. Copied 232 files of 925...
30% complete. Copied 278 files of 925...
35% complete. Copied 324 files of 925...
40% complete. Copied 370 files of 925...
45% complete. Copied 417 files of 925...
50% complete. Copied 463 files of 925...
55% complete. Copied 509 files of 925...
60% complete. Copied 555 files of 925...
65% complete. Copied 602 files of 925...
70% complete. Copied 648 files of 925...
75% complete. Copied 694 files of 925...
80% complete. Copied 740 files of 925...
85% complete. Copied 787 files of 925...
90% complete. Copied 833 files of 925...
95% complete. Copied 879 files of 925...
100% complete. Copied 925 files of 925...

Character-set converting files...

  2 unified drivers merged.

Patch merge completed successfully

Please check the log file at ./admrgpch.log.

Source fs1 file system environment file.
cd /tarmachin/patches/AD_target
Run 
adpatch

when prompted for drive file, give the merge driver file name
u_ad_cup7_patch.drv

It will take around 1 hrs to complete.

7) Fix Timestamp Mismatch


Download patch 17268684 and unzip.

Copy file 17268684/admin/ADZDDTFIX.sql from patch to DB ORACLE HOME

[oracle@ebsupgrade EBS1213_1220_upgrade_patches]$ cp 17268684/admin/ADZDDTFIX.sql $ORACLE_HOME/appsutil/admin
Connect as system user only and execute the script.

[oracle@ebsupgrade admin]$ sqlplus system/manager

SQL*Plus: Release 12.1.0.2.0 Production on Fri Dec 11 19:19:32 2020

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Last Successful login time: Fri Dec 11 2020 19:08:03 +05:30

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> @ADZDDTFIX.sql
begin
dbms_utility.invalidate(20857,NULL,0);
dbms_utility.invalidate(20837,NULL,0);
dbms_utility.invalidate(20849,NULL,0);
dbms_utility.invalidate(20791,NULL,0);
dbms_utility.invalidate(20829,NULL,0);
dbms_utility.invalidate(233652,NULL,0);
dbms_utility.invalidate(20838,NULL,0);
dbms_utility.invalidate(233653,NULL,0);
end;
/
exec sys.utl_recomp.recomp_parallel;
exit;
An out file will be created.

[oracle@ebsupgrade admin]$ cat adzddtfix.out
begin
dbms_utility.invalidate(20857,NULL,0);
dbms_utility.invalidate(20837,NULL,0);
dbms_utility.invalidate(20849,NULL,0);
dbms_utility.invalidate(20791,NULL,0);
dbms_utility.invalidate(20829,NULL,0);
dbms_utility.invalidate(233652,NULL,0);
dbms_utility.invalidate(20838,NULL,0);
dbms_utility.invalidate(233653,NULL,0);
end;
/
exec sys.utl_recomp.recomp_parallel;
exit;
Execute the adzddtfix.out file from the system user.

[oracle@ebsupgrade admin]$ sqlplus system/manager

SQL*Plus: Release 12.1.0.2.0 Production on Fri Dec 11 19:21:45 2020

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Last Successful login time: Fri Dec 11 2020 19:19:33 +05:30

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> @adzddtfix.out

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

Re-execute script ADZDDTFIX.sql to check for any pending TimeStamp Mismatch issues.It should show no output.

8) Apply Consolidated Upgrade Patch and Run the 12.2.0 Upgrade


Connect as sysdba at db node and  set
sec_case_sensitive_logon to False if set to True.

alter system set sec_case_sensitive_logon=false;

I have already kept it false so nothing to do.


SQL> show parameter case

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon	     boolean	 FALSE


Download 22742071
Go to the Application node and run below from the patch location. Source fs1 environment file.

 [applmgr@ebsupgrade patches]$ cd 22742071
[applmgr@ebsupgrade 22742071]$ pwd
/tarmachin/patches/22742071
adpatch preinstall=y 

Now merge the patch.
Note: American English Patch driver u10124646.drv comes with 12.2 filesystem layout installation as done earlier

[applmgr@ebsupgrade 22742071]$ cd $AU_TOP/patch/115/driver
[applmgr@ebsupgrade driver]$ ls
augenmsg.drvx  ausstats.drvx  u10124646.drv  u10201000.drv
[applmgr@ebsupgrade driver]$ admrgpch -d . -preinstall -master u10124646.drv

Executing the merge of the patch drivers
 -- Processing file: /tarmachin/EBS12210/GOLD/APPS/fs1/EBSapps/appl/admin/GOLD121/preinstall/u22742071.drv
 -- Done processing file: /tarmachin/EBS12210/GOLD/APPS/fs1/EBSapps/appl/admin/GOLD121/preinstall/u22742071.drv
 -- Processing file: u10124646.drv
 -- Done processing file: u10124646.drv


  2 unified drivers merged.

Patch merge completed successfully

Please check the log file at ./admrgpch.log.

The default merged driver by name u_merged.drv is then created in the destination directory.

Apply the merge patch on fs1 filesystem. Source the environment file.

[applmgr@ebsupgrade driver]$ cd /tarmachin/EBS12210/GOLD/APPS/fs1/EBSapps/appl/au/12.0.0/patch/115/driver
[applmgr@ebsupgrade driver]$ adpatch options=nocopyportion,nogenerateportion

It will take 6-7 hrs to complete.
Please keep monitoring the database alert log and patch log on other putty/terminal sessions.

-----------------------------------------------------------------------------------------------------------------------------
Known Error:
Updating FND_PRODUCT_GROUPS.release_name, if necessary...
  Done saving Patch History information.

AutoPatch error:
adptaskStoreTimInfoToHist: Error while inserting into AD_PROGRAM_RUN_TASK_JOBS.

AutoPatch error:
ORA-01653: unable to extend table APPLSYS.AD_PROGRAM_RUN_TASK_JOBS by 16 in tablespace APPS_TS_TX_DATA


AutoPatch error:
adpmrp: Error calling adptaskStoreTimInfoToHist(2).
Add space to tablespace/or autoextend the datafile.Rerun adpatch again.
Solution:
SQL> select file_name,bytes/1024/1024,autoextensible from dba_data_files where tablespace_name='APPS_TS_TX_DATA';

FILE_NAME							       BYTES/1024/1024 AUT
---------------------------------------------------------------------- --------------- ---
/tarmachin/EBS1213/GOLD/DB/apps_st/data/a_txn_data04.dbf			  1744 NO
/tarmachin/EBS1213/GOLD/DB/apps_st/data/a_txn_data01.dbf			1267.5 NO
/tarmachin/EBS1213/GOLD/DB/apps_st/data/a_txn_data02.dbf		      1657.625 NO
/tarmachin/EBS1213/GOLD/DB/apps_st/data/a_txn_data03.dbf			  1323 NO

SQL> alter database datafile '/tarmachin/EBS1213/GOLD/DB/apps_st/data/a_txn_data01.dbf' autoextend on;


Database altered.

SQL> SQL> select file_name,bytes/1024/1024,autoextensible from dba_data_files where tablespace_name='APPS_TS_TX_DATA'
  2  ;

FILE_NAME							       BYTES/1024/1024 AUT
---------------------------------------------------------------------- --------------- ---
/tarmachin/EBS1213/GOLD/DB/apps_st/data/a_txn_data04.dbf			  1744 NO
/tarmachin/EBS1213/GOLD/DB/apps_st/data/a_txn_data01.dbf			1267.5 YES
/tarmachin/EBS1213/GOLD/DB/apps_st/data/a_txn_data02.dbf		      1657.625 NO
/tarmachin/EBS1213/GOLD/DB/apps_st/data/a_txn_data03.dbf			  1323 NO

Re-run adpatch now.
-----------------------------------------------------------------------------------------------------------------------------
Verify patch 22742071 has been applied.


SQL> select bug_number from ad_bugs where bug_number='22742071';

BUG_NUMBER
------------------------------
22742071

9) Disable Maintenance Mode

Run adadmin after sourcing fs1 environment file.


             Change Maintenance Mode
   ----------------------------------------

Maintenance Mode is currently: [Enabled].


Maintenance mode should normally be enabled when patching
Oracle E-Business Suite and disabled when users are logged on
to the system.  See the Oracle E-Business Suite Maintenance
Utilities manual for more information about maintenance mode.


Please select an option:

   1.    Enable Maintenance Mode

   2.    Disable Maintenance Mode

   3.    Return to Main Menu



Enter your choice [3] : 2

sqlplus -s &un_apps/***** @/tarmachin/EBS12210/GOLD/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql DISABLE

Successfully disabled Maintenance Mode.


10)Run AutoConfig on the Apps Tier


On Application node and Source the applications run file system environment file 

Verify if below autoconfig table exists

[applmgr@ebsupgrade driver]$ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Sat Dec 12 08:01:25 2020

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL>  select object_name, object_type, owner, status from dba_objects where
upper(object_name)='ADX_PRE_AUTOCONFIG' and object_type='TABLE' and
upper(owner)='APPS';  2    3  

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-----------------------
OWNER
--------------------------------------------------------------------------------
STATUS
-------
ADX_PRE_AUTOCONFIG
TABLE
APPS
VALID

Execute the following commands to drop table ADX_PRE_AUTOCONFIG from APPS
schema:

sqlplus apps/apps

SQL> @$AD_TOP/patch/115/sql/txkDropAdxPreAutoConfig.sql
Table ADX_PRE_AUTOCONFIG dropped
Synonym ADX_PRE_AUTOCONFIG does not exist

PL/SQL procedure successfully completed.


Commit complete.

Execute auto-config now

Make sure it completes successfully.


[applmgr@ebsupgrade driver]$ $ADMIN_SCRIPTS_HOME/adautocfg.sh

11) Configuring the Oracle E-Business Suite Release 12.2 Application Tier by rapid install

Go to the stage area which was also used in step 4 earlier.

connect with root user and launch rapidwiz

[root@ebsupgrade rapidwiz]# pwd
/tarmachin/EBS12210/software/APPS12.2/startCD/Disk1/rapidwiz

./rapidwiz




Click next on the Welcome Screen


Select Upgrade Option


Don't provide any email address and continue.


On Select Upgarde Action screen, select Configure Upgarde Release 12.2.0 Instance
and Browse the path ($INST_TOP>/appl/admin/<CONTEXT_NAME>.xml) and click Next.


Enter the WebLogic password which was given earlier in Step 4. and click Next. It will do pre-checks.


Click next on the Validate system configuration screen. But before that ensure that all the checks should be passed


Verify the Database and Middle tier Information



Confirm rapidwiz to start configuring the EBS 12.2.0




It took 2 hrs for me to complete.



Click Next and Finish.

12) Enable the Online patching


Run the Online Patching Enablement - Readiness Reports

Source run file system and create below directory.


mkdir $LOG_HOME/appl/op
cd $LOG_HOME/appl/op

Run the following Readiness reports:
a) ADZDPSUM.sql - Provides a summary of the schemas that will be editioned and also schemas with objects that depend on E-Business Suite code that is recommended to be editioned. You can register these schemas with the application by running the commands that will be listed in the last section of this report. Oracle recommends that you run this report again after the custom schemas are registered with the application. You should run ADZDPSUM.sql repeatedly to handle dependent schemas until no further EBR violations are reported.

sqlplus system/manager
@$AD_TOP/sql/ADZDPSUM.sql 

Once completed rename the outfile which is created.

mv adzdpsum.txt adzdpsum_pre_dbprep.txt

b) ADZDPMAN.sql - Lists objects with different categories of violations to EBR rules that must be fixed prior to running the enablement process to avoid errors during this process. Oracle recommends that you run this report after all custom schemas are registered with the application according to instructions in the above report ADZDPSUM.sql.

sqlplus system/manager
@$AD_TOP/sql/ADZDPMAN.sql 

Once completed rename the outfile which is created.

mv adzdpman.txt adzdpman_pre_dbprep.txt

c) ADZDPAUT.sql - This report lists all the objects with violations of the EBR rules that will be fixed automatically from the enablement process. This report is provided for information purposes and no action should be taken from this report.

Note: Please make sure you have sufficient space in  TEMP tablespace as it can fail with "unable to extend temp tablespace error".

sqlplus system/manager
SQL> @$AD_TOP/sql/ADZDPAUT.sql 

Once completed rename the outfile which is created.

mv adzdpaut.txt adzdpaut_pre_dbprep.txt


----------------------------------------------------------------------------------------------------
Important

The Online Patching Readiness Report contains sections with different violation types.

Review all sections listed from the ADZDPMAN.sql report. Follow instructions in each section to fix violations.

Note: Many violations in the Readiness report can be automatically fixed by registering your custom schemas. Review the last section of the Summary Readiness Report (ADZDPSUM.sql) for sample commands on how to register your custom schemas as well as any schema installed as part of an Oracle technology such as APEX, XDB, and OWBSYS. You must register any custom or third-party schema that does not support Oracle E-Business Suite Online Patching.

The following schemas should NOT be registered:

SYS

SYSTEM

CTXSYS

Any dependency between these schemas and Editioned Objects is a coding standards violation and must be fixed manually.

Oracle recommends that you perform the chosen fix by customizing template file $AD_TOP/sql/ADZDPCUST.sql. The reports provide more details on this step.

Repeat the Run the Online Patching Enablement - Readiness Report step above until all violations have been addressed.
-------------------------------------------------------------------------------------------------------------------------


Verify database tablespace free space

On application node and Source the application run environment file.
perl $AD_TOP/bin/adzdreport.pl apps

a) Enter apps password (apps) when prompt to enter.
b) Select option 3 - 'Other Generic Reports' 

Select the next option 3 - 'Free Space in Important Tablespaces

=========================================================================
=		       Important Tablespace Status
=========================================================================

TABLESPACE_NAME 	       TOTAL_SPACE(GB) USED_SPACE(GB) FREE_SPACE(GB) PCT_USED
------------------------------ --------------- -------------- -------------- --------
APPS_TS_SEED				  2.97		 2.81		 .16	94.74
APPS_TS_TX_DATA 			  6.16		 5.86		 .30	95.13
APPS_TS_TX_IDX				  8.26		 7.57		 .69	91.63
SYSTEM					 12.38		11.79		 .60	95.18


Above report is captured in file : /tarmachin/EBS12210/GOLD/APPS/fs1/EBSapps/appl/admin/GOLD121/out/adzdshowts.out.
===============================================================================

Ensure the following:

SYSTEM Tablespace: has a minimum of 25 GB of free space

APPS_TS_SEED Tablespace: has a minimum of 5 GB of free space

APPS_TS_SEED is used to host all tables that have been registered as seed tables and that require seed data storage infrastructure.

Add the required space in the tablespaces and rerun the report to validate.

=========================================================================
=		       Important Tablespace Status
=========================================================================

TABLESPACE_NAME 	       TOTAL_SPACE(GB) USED_SPACE(GB) FREE_SPACE(GB) PCT_USED
------------------------------ --------------- -------------- -------------- --------
APPS_TS_SEED				  8.82		 2.81		6.01	31.86
APPS_TS_TX_DATA 			 10.46		 5.86		4.60	56.06
APPS_TS_TX_IDX				 13.18		 7.57		5.60	57.47
SYSTEM					 38.43		11.79	       26.64	30.67


Above report is captured in file : /tarmachin/EBS12210/GOLD/APPS/fs1/EBSapps/appl/admin/GOLD121/out/adzdshowts.out.
===============================================================================

Note: Verify that all middle-tier E-Business Suite services are shut down prior to applying the Online Patching Enablement patch.

Check compatible is 12.1.0 for database
Your database should be set to compatible 12.1.0 and if is pointing to 11.1.0 then change else if database is pointing to 12.1.0 then skip this.


sqlplus “/as sysdba”
SQL> show parameter compatible
If value is 11.1.0 then change and restart database 

SQL> alter system set compatible=’12.1.0’ scope=spfile;
SQL> shutdown immediate
SQL> startup 


Run the Online Patching Enablement - Status Report

This report provides an overall status of the enabling online patching process. You can run it before, during, and after the enablement, the patch is applied. At this stage, you will receive report results before you enable online patching.

Set the current directory to $LOG_HOME/appl/op:

$ cd $LOG_HOME/appl/op
Run the report using the following command. Ensure that you verify any invalid objects at this stage. Take special note to ensure that all online patching objects (objects that match the pattern 'AD_ZD%') are valid:

$ sqlplus <apps username> @$AD_TOP/sql/ADZDEXRPT.sql
Note: Enter the apps password when prompted.

Save the output as pre_dbprep for future references, such as:

$ mv adzdexrpt.txt adzdexrpt_pre_dbprep.txt


Apply the Online Patching Enablement patch

Download patch 13543062

On the application node and source the environment file.

Copy the 13543062 patch to the default patch directory.
cd /tarmachin/EBS12210/GOLD/APPS/fs_ne/EBSapps/patch
cp /media/sf_Downloads/EBS1213_1220_upgrade_patches/p13543062_R12.AD.C_R12_GENERIC.zip .
.
unzip p13543062_R12.AD.C_R12_GENERIC.zip

Run Autopatch in hotpatch mode to apply the patch

Note: We are not placing in maintenance mode as we are applying it in hotpatch mode,after this patch is applied, maintenance mode will be removed from good, so should not enable maintenance mode.
This patch is reapplied here for online Patching enablement, that is why it is applied in forceapply mode.

cd /tarmachin/EBS12210/GOLD/APPS/fs_ne/EBSapps/patch/13543062
adpatch options=hotpatch,forceapply


Important: While applying the Online Enablement patch, you may receive the following error: 'Attention: Adpatch should no longer be used to apply patches. Please use ADOP tool for applying patches.' If you receive this error, then you must use adop in hotpatch mode to apply the enablement patch.

Known Error:

There are now 46 jobs remaining (current phase=A3):
    0 running, 1 ready to run and 45 waiting.

 Assigned: file ADZDPREP.sql on worker  1 for product ad  username APPLSYS.
   FAILED: file ADZDPREP.sql on worker  1 for product ad  username APPLSYS.
 Deferred: file ADZDPREP.sql on worker  1 for product ad  username APPLSYS.               (Deferment number 1 for this job)
 Assigned: file ADZDPREP.sql on worker  1 for product ad  username APPLSYS.
   FAILED: file ADZDPREP.sql on worker  1 for product ad  username APPLSYS.
 Deferred: file ADZDPREP.sql on worker  1 for product ad  username APPLSYS.               (Deferment number 2 for this job)
 Assigned: file ADZDPREP.sql on worker  1 for product ad  username APPLSYS.
   FAILED: file ADZDPREP.sql on worker  1 for product ad  username APPLSYS.

ATTENTION: All workers either have failed or are waiting:

	   FAILED: file ADZDPREP.sql on worker  1.

Solution:
Check the status of all the AD_ZD objects:
 

SQL> col OWNER for a12;
col OBJECT_NAME for a25;
col STATUS for a15;
set pages 500;
select owner,object_name,status from dba_objects where object_name like 'AD_ZD%';
Below object is seen as invalid
APPS      AD_ZD_PREP        INVALID

When trying to compile:

SQL> alter package apps.AD_ZD_PREP compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY APPS.AD_ZD_PREP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
424/3	 PL/SQL: SQL Statement ignored
424/19	 PL/SQL: ORA-00942: table or view does not exist
428/5	 PL/SQL: SQL Statement ignored
428/21	 PL/SQL: ORA-00942: table or view does not exist
448/5	 PL/SQL: Statement ignored
448/5	 PLS-00201: identifier 'SYS.XDB_MIGRATESCHEMA' must be declared
462/5	 PL/SQL: SQL Statement ignored
462/21	 PL/SQL: ORA-00942: table or view does not exist

1. Confirm if the package 'xdb_migrateschema' exists using the following select statement:

select owner, object_name from dba_objects where object_name like upper ('xdb_migrateschema');


If it does NOT exist, then use the following scripts to create it and confirm results again using the above query:


conn / as sysdba

@?/rdbms/admin/dbmsxdbschmig.sql

@?/rdbms/admin/prvtxdbschmig.plb

2. Run adgrants.sql.

3. Recompile the package AD_ZD_PREP and ensure it compiles successfully.

SQL> alter package apps.AD_ZD_PREP compile body;

Package body altered.

4. Continue with the upgrade and confirm online patching is successfully enabled.

Use adctrl to restart the failed worker.

Monitor the Online Patching Enablement patch application.

The enablement patch application may take several hours to finish. You can monitor its progress at any time by running the DDL Status Report (ADZDSHOWDDLS.sql) as follows:

$ sqlplus <apps Username> @$AD_TOP/sql/ADZDSHOWDDLS.sql
This report lists a count of the DDL statements that are required to EBR enable your environment. The report is organized by outcome of execution: 'Successfully Executed', 'Not Executed', and 'Failed Execution'. At the end of the patch application the report should have a zero count in the sections: 'Not Executed' and 'Failed Execution'. If the report contains 'Not Executed' and 'Failed Execution' items, then report these failures to Oracle Support. You will be asked to provide the output from the report, the patch log and all worker logs, and the online patching enablement status report output. If there is any worker failure during the Online Enablement patch, you should not ignore or skip the failed error. The issue should be addressed before restarting the worker. Ignoring or skipping the error can cause database corruption.

Example:

[applmgr@ebsupgrade ~]$ sqlplus apps @$AD_TOP/sql/ADZDSHOWDDLS.sql

SQL*Plus: Release 10.1.0.5.0 - Production on Sat Dec 12 14:26:43 2020

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password: 

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

DOC>
DOC>  Count of Current DDL Jobs per Phase and Status
DOC>
DOC>  Phases:
DOC>	1.  DROP_UNUSED_OBJECT : Remove obsolete objects from XLA schema.
DOC>	2.  COPY_TYPE	       : Create EBS Types in APPS_NE schema, stop Advanced Queues.
DOC>	3.  COMPILE_TYPE       : Recompile APPS_NE schema.
DOC>	4.  COPY_EVOLVED_TYPE  : Create evolved types in APPS_NE schema.
DOC>	5.  FIX_COLUMN	       : Fix TYPE reference to APPS_NE.<type> at table and AQ level.
DOC>	6.  FIX_TYPE	       : Additional check, Fix TYPE reference and then drop TYPE
DOC>				 from source schema.
DOC>	7.  FIX_PUBLIC_SYNONYM : Fix public synonyms.
DOC>	8.  RECREATE_AQ_OBJECT : Re-create internal AQ objects after TYPE Ref fix.
DOC>	9.  DROP_OBJECT        : Drop objects like CTXSYS.<package>, CTXSYS.<synonym> and others if any.
DOC>	10. ENABLE_EDITIONING  : Enable registered schemas for Online Patching.
DOC>	11. UPGRADE_TABLE      : Create Editioning View cover layer over EBS data model.
DOC>	12. UPGRADE_SEED       : Upgrade seed data tables to support edition based storage.
DOC>	13. COLLECT_STATS      : Gather Statistics on Seed Data Tables after upgrade.
DOC>	14. UPGRADE_MVIEW      : Convert Materialized Views with expand query.
DOC>	15. CUTOVER	       : Perform maintenance operations on columns and indexes after adop APPLY phase
DOC>				 and before actually changing Patch-Edition as Default-Edition.
DOC>	16. ACTUALIZE_ALL      : Actualize all editioned objects into the current edition.
DOC>	17. CLEANUP	       : Cleanup task after adop CUTOVER.
DOC>
DOC>
DOC>  Results spooled to: ADZDSHOWDDLS.out
DOC>#

Phase		       Count Status
-------------------- ------- ------------------------------
COPY_TYPE		  41 S - Successfully Executed

COMPILE_TYPE		   1 S - Successfully Executed

COPY_EVOLVED_TYPE	   1 S - Successfully Executed

FIX_COLUMN		   2 S - Successfully Executed

FIX_TYPE		  22 S - Successfully Executed

FIX_PUBLIC_SYNONYM	4486 S - Successfully Executed

RECREATE_AQ_OBJECT	  11 S - Successfully Executed

DROP_OBJECT		  10 S - Successfully Executed

ENABLE_EDITIONING	 163 S - Successfully Executed

UPGRADE_TABLE	       11508 N - Not Executed
			   4 R - Running
			6331 S - Successfully Executed

UPGRADE_SEED		2605 N - Not Executed

COLLECT_STATS		2605 N - Not Executed

UPGRADE_MVIEW		 120 N - Not Executed


15 rows selected.

DOC>
DOC>  Currently running phase is:
DOC>
DOC>#

Running Phase
--------------------
UPGRADE_TABLE

1 row selected.

Total time taken is 7 hrs .

13) Compile Invalid Objects (if any)


Connect to sqlplus as 'apps' and run the following:

$ exec sys.utl_recomp.recomp_parallel

14) Re-run the Online Patching Enablement Status Report after the Online Patching Enablement patch has been applied


Set the current directory to $LOG_HOME/appl/op:

$ cd $LOG_HOME/appl/op
Run the Status Report immediately after the enablement patch completes:

$ sqlplus <Apps Username> @$AD_TOP/sql/ADZDEXRPT.sql
Note: You must provide the APPS schema password when prompted.

The purpose of running this report at this stage is to identify and fix any errors that occurred during the enablement process.

Important: You must fix errors listed by this report. Failure to comply may result in unexpected failures during future patching cycles.

15) Re-run the Online Patching Enablement Readiness Report after the Online Patching Enablement patch has been applied


Set the current directory to $LOG_HOME/appl/op:

$ cd $LOG_HOME/appl/op
Run the Readiness Report after the enablement patch completes:

$ sqlplus system @$AD_TOP/sql/ADZDPSUM.sql
Note: You must provide the SYSTEM schema password when prompted.

$ mv adzdpsum.txt adzdpsum_post_dbprep.txt
$ sqlplus system @$AD_TOP/sql/ADZDPMAN.sql
$ mv adzdpman.txt adzdpman_post_dbprep.txt
$ sqlplus system @$AD_TOP/sql/ADZDPAUT.sql
$ mv adzdpaut.txt adzdpaut_post_dbprep.txt
The purpose of running this report at this stage is to ensure that all EBR violations that could have appeared before enabling the online patching feature are fixed.

16) Run the Online Patching Database Compliance Checker report to check for coding standards violations


There are two levels of compliance that can be targeted:

Minimal Compliance (Minimal) - These checks represent the minimum requirement for correct operation of Oracle E-Business Suite Release 12.2.

Warning: Do not attempt to operate the system if there are P1 minimal compliance violations. Custom code should pass the minimal compliance checks before being used in a Release 12.2 system.

Full Compliance (Full) - These checks indicate whether an object can be patched using Online Patching. Objects which do not meet full compliance may have limitations in how they can be patched, or may need to be patched using downtime patching. Full compliance also requires that all minimal compliance checks are passed. Custom code that will only be patched using downtime patching does not need to meet the full compliance level.

Set the current directory to $LOG_HOME/appl/op:

$ cd $LOG_HOME/appl/op
Run the Online Patching Database Compliance Checker report to check for online patching database objects standards violations:

sqlplus <Apps Username> @$AD_TOP/sql/ADZDDBCC.sql
This utility reports all violations to the Online Patching Development Standards. All Oracle E-Business Suite violations are fixed by the 12.2 upgrade. You must fix any object listed in this report that is part of your custom code. If you do not fix the violation, then you cannot leverage the online patching infrastructure to patch the objects listed in this report.

Note:

The 'recyclebin' parameter must be turned off to allow the cleanup phase of the online patching cycle to be performed without having to connect as SYS. This feature may still be used at other times.

For example:

$ recyclebin=off
If the _SYSTEM_TRIG_ENABLED parameter is set to false, then system triggers are not processed. The post Online Patching Enablement parameter must be set to true.

_SYSTEM_TRIG_ENABLED=true

$ _SYSTEM_TRIG_ENABLED=true



This completes our upgrade of EBS to R12.2.0. How to upgrade to the latest code level will be shared in another post.






Reference Note:
  • R12.2: How To Create the Stage In Preparation For Installation (Doc ID 1596433.1)
  • Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)
  • Oracle E-Business Suite Release 12.2: Suite-Wide Rollup and AD/TXK Delta Information (Doc ID 1583092.1)
  • Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
  • Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 (Doc ID 1531121.1)
  • https://docs.oracle.com/cd/E26401_01/doc.122/e73540/T660854T660862.htm#8360043
  • 12.2 E-Business Suite DBA Upgrade Script ADZDEXRPT.sql Fails On Invalid Object 'AD_ZD_PREP' Or Patch 13543062 Fails With Error: ORA-06508: PL/SQL: could not find APPS.AD_ZD_PREPAD_ZD_PREP Due To Missing Package 'xdb_migrateschema' (Doc ID 2066607.1)


If you like please follow and comment