Oracle Apps DBA, Oracle DBA: How to run EBS Tech Patch Automation Tool - Application Tier (ETPAT-AT) in R12.2 Upgrade

EBS Tech Patch Automation Tool - Application Tier (ETPAT-AT):

This tool saved me a lot of time and efforts while 12.2 upgrade. So I wanted to share this with you all.

This tool will take care of the patching tasks which we used to manually on 12.2 application tier during the upgrade after laying out File system.

Below is the Tool overview from MoS,

EBS Tech Patch Automation Tool - Application Tier (ETPAT-AT) automates patching of technology one-offs for the following components of the Oracle E-Business Suite Release (EBS) Release 12.2.0 application tier.

FMW WebTier 11.1.1.9
Oracle WebLogic Server 10.3.6 Smart Update Patch
Oracle WebLogic Server 10.3.6.0
FMW oracle_common 11.1.1.9
Forms and Reports 10.1.2.3

Specifically, ETPAT-AT:

Can be run on an EBS Release 12.2.0 application tier (run file system) for new installations or upgrades.
Is available for all platforms on which Oracle E-Business Suite is supported.
Runs ETCC-MT both before and after each patching session.
Provides comprehensive reports on:
- All components that were patched in the patching session
- The resulting updated application tier technology stack inventory.
Works both with on-premises and Compute environments.
Makes no changes to the EBS database.
Cannot be used on EBS systems that are already at Release 12.2.3 or later.

Obtaining the Tool

- ETPAT-AT is available from My Oracle Support as Patch 32208510. Download the patch from MOS and move it to patch stage area.

- Create or specify a patch stage area directory. This patch stage area can be in any location accessible from the application tier. For example: <NE_BASE>/EBSapps/patch/etpat-at. If you wish, you can use your regular patch download area. This patch stage area will be used to download all the required patches prompted for by ETPAT-AT when it runs.

- Download the latest ETCC Patch 17537119 to the patch stage area. This tool runs ETCC before patching the middle-tier and after patching to make sure all the required patches have been applied. So we dont need to run ETCC manually on MiddleTier.

$ cd patch stage area

$ unzip -o p32208510_R12_GENERIC.zip

Archive: p32208510_R12_GENERIC.zip

inflating: post_install_steps.xml

inflating: README.txt

inflating: etpat_at.pl

Preparing to RUN ETPAT-AT

- Download the prerequisite patches below and move to patch stage area. These patches will be applied to 12.2 Middle Tier by the tool.

- Note : Don’t unzip the patches.

p17537119_R12_GENERIC.zip

p6880880_101000_SOLARIS64.zip

p6880880_111000_SOLARIS64.zip

p32152068_R12_SOLARIS64.zip

p32052267_1036_Generic.zip

p31136426_1036_Generic.zip

- While running the tool, you will be prompted to download and keep the required the patches in patch stage area. This is another way you can find what are all the patches required easily.

Snippet of the question :

*******************************************

[OPatch patch 6880880. Ensure that p6880880_101000_SOLARIS64.zip, p6880880_111000_SOLARIS64.zip are downloaded under the patch stage area]

[Fusion Middleware consolidated patch 32670837. Ensure that p32670837_R12_SOLARIS64.zip is downloaded under patch stage area]

[Latest WLS Patch 32403651. Ensure that p32403651_1036_Generic.zip is downloaded under patch stage area]

[Smart update Patch 31136426. Ensure that p31136426_1036_Generic.zip is downloaded under patch stage area]

Download above patches under patch stage area and Enter 'Yes' to Continue (Yes/No):

Yes

******************************************************************************

While running the tool, Respond to the following prompts:

$ Enter 12.2.0 Run edition file system context file:
$ Enter APPS schema name [APPS]:
$ Enter password for APPS schema:
$ Enter directory where you downloaded ETCC Patch 17537119:

Running ETPAT-AT

applmgr@test21:/u01/oracle/patch_stage_area$ perl etpat_at.pl

Enter 12.2.0 Run edition file system context file:

/u01/oracle/TEST/fs1/inst/apps/TEST_test21/appl/admin/TEST_test21.xml

***********************************************************

Validating the context file...

Context file exists: /u01/oracle/TEST/fs1/inst/apps/TEST_test21/appl/admin/TEST_test21.xml

***********************************************************

Start Time: Wednesday, April 7, 2021 at 8:44:06 PM BST

***********************************************************

File System level is 12.2.0

***********************************************************

Sourcing the 12.2 RUN File System

Sourcing Apps Environment file /u01/oracle/TEST/fs1/EBSapps/appl/APPSTEST_test21.env

***********************************************************

Generating ocm.rsp file for silent installation

Provide your email address to be informed of security issues, install and

initiate Oracle Configuration Manager. Easier for you if you use your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: The OCM configuration response file (/u01/oracle/patch_stage_area/ocm.rsp) was successfully created.

***********************************************************

Platform: Solaris

***********************************************************

Enter APPS schema name [APPS]:

Enter password for APPS schema:

Validating APPS user login details...

Password validation is completed

******************************************************************

EBS Release level is 12.1.3

*****************************************************************

Validating pre-requisite files availability under Technology Stack Patching tool stage area...

Post install steps file post_install_steps.xml exists under Technology Stack Patching tool stage area

****************************************************************

Enter directory where you downloaded ETCC Patch 17537119:

/u01/oracle/patch_stage_area

*******************************************

Validating the Latest ETCC patch availabilty...

ETCC Patch /u01/oracle/patch_stage_area/p17537119_R12_GENERIC.zip exists

Archive: /u01/oracle/patch_stage_area/p17537119_R12_GENERIC.zip

inflating: /u01/oracle/patch_stage_area/checkDBpatch.cmd

inflating: /u01/oracle/patch_stage_area/checkDBpatch.sh

inflating: /u01/oracle/patch_stage_area/checkMTpatch.cmd

inflating: /u01/oracle/patch_stage_area/checkMTpatch.sh

inflating: /u01/oracle/patch_stage_area/db/cloud/txk_R1220_EXABM_mappings.xml

inflating: /u01/oracle/patch_stage_area/db/cloud/txk_R1220_DBCS_base_bugs.xml

inflating: /u01/oracle/patch_stage_area/db/cloud/txk_R1220_DBCS_RAC_base_bugs.xml

inflating: /u01/oracle/patch_stage_area/db/cloud/txk_R1220_VMDB_RAC_base_bugs.xml

inflating: /u01/oracle/patch_stage_area/db/cloud/txk_R1220_EXACS_mappings.xml

inflating: /u01/oracle/patch_stage_area/db/cloud/txk_R1220_EXACS_base_bugs.xml

inflating: /u01/oracle/patch_stage_area/db/cloud/txk_R1220_DBCS_RAC_mappings.xml

inflating: /u01/oracle/patch_stage_area/db/cloud/txk_R1220_DBSI_base_bugs.xml

inflating: /u01/oracle/patch_stage_area/db/cloud/txk_R1220_VMDB_RAC_mappings.xml

inflating: /u01/oracle/patch_stage_area/db/cloud/txk_R1220_DBSI_mappings.xml

inflating: /u01/oracle/patch_stage_area/db/cloud/txk_R1220_DBCS_mappings.xml

inflating: /u01/oracle/patch_stage_area/db/cloud/txk_R1220_EXABM_base_bugs.xml

inflating: /u01/oracle/patch_stage_area/db/onprem/txk_R1220_DB_mappings.xml

inflating: /u01/oracle/patch_stage_area/db/onprem/txk_R1220_DB_base_bugs.xml

inflating: /u01/oracle/patch_stage_area/db/onprem/txk_R1220_GRID_base_bugs.xml

inflating: /u01/oracle/patch_stage_area/mw/txk_R1220_MT_base_bugs.xml

inflating: /u01/oracle/patch_stage_area/mw/txk_R1220_MT_mappings.xml

inflating: /u01/oracle/patch_stage_area/README.txt

inflating: /u01/oracle/patch_stage_area/db/cloud/txk_R1220_EXACC_base_bugs.xml

inflating: /u01/oracle/patch_stage_area/db/cloud/txk_R1220_EXACC_mappings.xml

Current version: txk_R1220_MT_mappings.xml 120.0.12020000.35 2021/01/21

[WARNING] ETCC Patch 17537119 is more than 30 days old.

Check if a newer version of ETCC Patch 17537119 is available in My Oracle Support.

If available, download patch under stage area and unzip using '-o' option.

Current stage area: /u01/oracle/patch_stage_area

Enter 'Yes' to Continue (Yes/No):

Yes

Continuing using txk_R1220_MT_mappings.xml 120.0.12020000.35 2021/01/21

*******************************************

Enter patch stage area:

/u01/oracle/patch_stage_area

*******************************************

Validating patch stage area...

Patch stage area exists: /u01/oracle/patch_stage_area