Apply Latest CPU Patch of April 2024 on Oracle EBS R12.2.7 Application and Database 19c

 

Ref: Oracle E-Business Suite Release 12.2 Critical Patch Update Availability Document (April 2024) (Doc ID 3007752.1)

As mentioned in the above document, before applying the Latest CPU patch we need to run ECPUC tool to identify any missing patches at Application node. To run ECPUC, download Patch 35583866 and follow the instructions in the patch Readme.txt file.

3.2.1 EBS CPU Patches and Security Fixes 

[applprod@upgapp03 oracle]$ . EBSapps.env run

[applprod@upgapp03 scripts]$ cd $PATCH_TOP

[applprod@upgapp03 patch]$ pwd

/applprod/oracle/fs_ne/EBSapps/patch

[applprod@upgapp03 patch]$ cd ECPUC/

[applprod@upgapp03 ECPUC]$ unzip p35583866_R12_GENERIC.zip

[applprod@upgapp03 ECPUC]$ sqlplus apps/apps@UPG

SQL> @ECPUC.sql

SECTION-2 Oracle E-Business Suite (EBS): Instance Information

========================================================================

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

Instance Summary

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

EBS Release            EBS CPU Level

-----------                  -------------

12.2.7                       pre 2020.01

Instance Name                  Database          Database Version

----------------                       ----------------     ------------------

UPGCDB                               UPG                 19.21.0.0.0

ATG Product  Product Name                             Code Level

------------ ---------------------------------------- ----------

ad           Applications DBA                         C.14

txk          Oracle Applications Technology Stack     C.14

atg_pf       Oracle Applications Technology Family    C.7

fwk          Oracle Applications Framework            C.7

==============================================================================

SECTION-3 Required EBS CPU and Security Fixes

========================================================================

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

The following output is a list of required patches and security fixes

that are missing in your environment.

It is strongly recommended that you apply all of the listed patches as soon as possible.

If no patches (no rows) are listed then no additional action is required

at this time as your environment includes all patches for this EBS CPU.

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

The following patches are required for this EBS CPU

--------------------------------------------------------------

36271505:12.2.0  ---> CPU PATCH FOR APRIL 2024

36337060:R12.AHL.C

35362524:R12.IGI.C

34979060:R12.MSC.C

35736182:R12.FWK.C

35411549:R12.FND.C

31206584:R12.FND.C

32980025:R12.AK.C

33245199:R12.OAM.C

34212478:R12.JTT.C

35951856:R12.BNE.C

34291981:R12.UMX.C

36050661:R12.OWF.C

36298760:R12.BNE.C

29662975:R12.EAM.C

34870379:R12.POS.D

32004048:R12.OKC.C

32636526:R12.HZ.C

33254651:R12.WSH.C

33457157:R12.HXT.C

30448458:R12.HXT.C

34904567:R12.CSR.C

 

Patch

Execution

36337060

[applprod@upgapp03 patch]$ cd /applprod/oracle/

[applprod@upgapp03 oracle]$ . EBSapps.env run

[applprod@upgapp03 patch]$ cd $PATCH_TOP

[applprod@upgapp03 patch]$ unzip p36337060_R12.AHL.C_R12_GENERIC.zip

[applprod@upgapp03 oracle]$ adop phase=fs_clone

[applprod@upgapp03 oracle]$ adop phase=prepare

[applprod@upgapp03 oracle]$ adop phase=apply patches=36337060

35362524

[applprod@upgapp03 oracle]$ cd $PATCH_TOP

[applprod@upgapp03 patch]$ unzip p35362524_R12.IGI.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 35362524/

[applprod@upgapp03 35362524]$ adop phase=apply patches=35362524

 

34979060

[applprod@upgapp03 patch]$ unzip p34979060_R12.MSC.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 34979060/

[applprod@upgapp03 34979060]$ adop phase=apply patches=34979060

35736182

[applprod@upgapp03 patch]$ unzip p35736182_R12.FWK.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 35736182/

[applprod@upgapp03 35736182]$ adop phase=apply patches=35736182

36271505

(CPU PATCH FOR APRIL 2024)

[applprod@upgapp03 patch]$ unzip p36271505_12.2.0_R12_LINUX.zip

[applprod@upgapp03 patch]$ cd 36271505/

[applprod@upgapp03 36271505]$ adop phase=apply patches=36271505

Post install steps:

[applprod@upgapp03 scripts]$ cd /applprod/oracle/

[applprod@upgapp03 oracle]$ . EBSapps.env run

[applprod@upgapp03 oracle]$ cd $ADMIN_SCRIPTS_HOME

[applprod@upgapp03 scripts]$ ./adautocfg.sh

[applprod@upgapp03 scripts]$ cd /applprod/oracle/

[applprod@upgapp03 oracle]$ . EBSapps.env run

[applprod@upgapp03 oracle]$ echo $AD_TOP

/applprod/oracle/fs1/EBSapps/appl/ad/12.0.0

[applprod@upgapp03 oracle]$ perl /applprod/oracle/fs1/EBSapps/appl/ad/12.0.0/bin/admkappsutil.pl

Starting the generation of appsutil.zip

Log file located at /applprod/oracle/fs1/inst/apps/UPG_upgapp03/admin/log/MakeAppsUtil_05021303.log

output located at /applprod/oracle/fs1/inst/apps/UPG_upgapp03/admin/out/appsutil.zip

MakeAppsUtil completed successfully.

[applprod@upgapp03 oracle]$

On DB Tier:

[oraprod@upgdb03 ~]$ cd /oraprod/oracle/db/19.3.0/

[oraprod@upgdb03 19.3.0]$ . UPG_upgdb03.env

[oraprod@upgdb03 19.3.0]$ unzip -o appsutil.zip

[oraprod@upgdb03 19.3.0]$ cd appsutil/scripts/UPG_upgdb03/

[oraprod@upgdb03 UPG_upgdb03]$ ./adautocfg.sh

35411549

[applprod@upgapp03 patch]$ unzip p35411549_R12.FND.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 35411549/

[applprod@upgapp03 35411549]$ adop phase=apply patches=35411549

31206584

[applprod@upgapp03 patch]$ unzip p31206584_R12.FND.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 31206584/

[applprod@upgapp03 31206584]$ adop phase=apply patches=31206584

32980025

[applprod@upgapp03 patch]$ unzip p32980025_R12.AK.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 32980025/

[applprod@upgapp03 32980025]$ adop phase=apply patches=32980025

33245199

[applprod@upgapp03 patch]$ unzip p33245199_R12.OAM.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 33245199

[applprod@upgapp03 33245199]$ adop phase=apply patches=33245199

34212478

[applprod@upgapp03 patch]$ unzip p34212478_R12.JTT.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 34212478/

[applprod@upgapp03 34212478]$ adop phase=apply patches=34212478

35951856

[applprod@upgapp03 patch]$ unzip p35951856_R12.BNE.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 35951856/

[applprod@upgapp03 35951856]$ adop phase=apply patches=35951856

34291981

[applprod@upgapp03 patch]$ unzip p34291981_R12.UMX.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 34291981/

[applprod@upgapp03 34291981]$ adop phase=apply patches=34291981

36050661

[applprod@upgapp03 patch]$ unzip p36050661_R12.OWF.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 36050661/

[applprod@upgapp03 36050661]$ adop phase=apply patches=36050661

36298760

[applprod@upgapp03 patch]$ unzip p36298760_R12.BNE.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 36298760/

[applprod@upgapp03 36298760]$ adop phase=apply patches=36298760

29662975

[applprod@upgapp03 patch]$ unzip p29662975_R12.EAM.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 29662975/

[applprod@upgapp03 29662975]$ adop phase=apply patches=29662975

34870379

[applprod@upgapp03 patch]$ unzip p34870379_R12.POS.D_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 34870379/

[applprod@upgapp03 34870379]$ adop phase=apply patches=34870379

32004048

[applprod@upgapp03 patch]$ unzip p32004048_R12.OKC.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 32004048/

[applprod@upgapp03 32004048]$ adop phase=apply patches=32004048

32636526

[applprod@upgapp03 patch]$ unzip p32636526_R12.HZ.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 32636526/

[applprod@upgapp03 32636526]$ adop phase=apply patches=32636526

33254651

[applprod@upgapp03 patch]$ unzip p33254651_R12.WSH.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 33254651/

[applprod@upgapp03 33254651]$ adop phase=apply patches=33254651

33457157

[applprod@upgapp03 patch]$ unzip p33457157_R12.HXT.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 33457157

[applprod@upgapp03 33457157]$   adop phase=apply patches=33457157

30448458

[applprod@upgapp03 patch]$ unzip p30448458_R12.HXT.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 30448458/

[applprod@upgapp03 30448458]$ adop phase=apply patches=30448458

34904567

[applprod@upgapp03 patch]$ unzip p34904567_R12.CSR.C_R12_GENERIC.zip

[applprod@upgapp03 patch]$ cd 34904567/

[applprod@upgapp03 34904567]$ adop phase=apply patches=34904567

 

[applprod@upgapp03 patch]$ adop phase=FINALIZE,CUTOVER,CLEANUP

[applprod@upgapp03 oracle]$ . EBSapps.env run

[applprod@upgapp03 oracle]$ adop phase=fs_clone

-Run the ECPUC tool again to check for any missing pre-requisite patches for April 2024 CPU patch.

[applprod@upgapp03 oracle]$ . EBSapps.env run

[applprod@upgapp03 scripts]$ cd $PATCH_TOP

[applprod@upgapp03 patch]$ pwd

/applprod/oracle/fs_ne/EBSapps/patch

[applprod@upgapp03 patch]$ cd ECPUC/

[applprod@upgapp03 ECPUC]$ unzip p35583866_R12_GENERIC.zip

[applprod@upgapp03 ECPUC]$ sqlplus apps/apps@UPG

SQL> @ECPUC.sql

Note: after applying all the above patches we found no missing pre-requisite patches. See the output below.





Applying Latest CPU on DB:

3.2.2 Security Patches for Technology Stack Components With a New Patch in This CPU

- Refer this document “Critical Patch Update (CPU) Program Apr 2024 Patch Availability Document (DB-only) (Doc ID 3000005.1)” for applying Latest CPU patch of April 2024 on Database 19c.

- Download and install the patch p36209492_190000_Linux-x86-64.zip as this patch is the latest CPU patch of April 2024 for EBS database 19c.

[oraprod@upgdb03 19.3.0]$ cd OPatch

[oraprod@upgdb03 OPatch]$ unzip p36209492_190000_Linux-x86-64.zip

[oraprod@upgdb03 OPatch]$ cd 36209492

[oraprod@upgdb03 36209492]$

-          Note, this patch “36209492” has two patches 36233263 & 36199232. First Apply 36233263 then 36199232.

Installing patch 36233263:

[oraprod@upgdb03 36233263]$ /oraprod/oracle/db/19.3.0/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

[applprod@upgapp03 scripts]$ ./adstpall.sh

[oraprod@upgdb03 36233263]$ lsnrctl stop UPGCDB

[oraprod@upgdb03 36233263]$ sqlplus / as sysdba

SQL> shut immediate;

SQL> exit

[oraprod@upgdb03 36233263]$ /oraprod/oracle/db/19.3.0/OPatch/opatch apply

[oraprod@upgdb03 36233263]$ sqlplus /nolog

SQL> connect / as sysdba

SQL> startup

SQL> alter pluggable database all open;

SQL> quit;

[oraprod@upgdb03 36233263]$ cd $ORACLE_HOME/OPatch

[oraprod@upgdb03 OPatch]$ ./datapatch –verbose

-Note: The datapatch utility runs the necessary apply scripts to load the modified SQL files into the database. An entry is added to the dba_registry_sqlpatch view reflecting the patch application. In the dba_registry_sqlpatch view, verify that the status for the APPLY is SUCCESS.

SQL> select * from dba_registry_sqlpatch;

SQL>select count(*) from dba_objects where status = 'INVALID'; à ran this as apps and we found 30 invalid objects after executing the datapatch so we need to execute below steps to remove this invalid objects.

[oraprod@upgdb03 OPatch]$ export PATH=$PATH:$ORACLE_HOME/bin

[oraprod@upgdb03 OPatch]$ cd $ORACLE_HOME/rdbms/admin

[oraprod@upgdb03 admin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -e -b utlrp -d $ORACLE_HOME/rdbms/admin utlrp.sql

catcon::set_log_file_base_path: catcon: See [/oraprod/oracle/db/19.3.0/rdbms/admin/utlrp*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/oraprod/oracle/db/19.3.0/rdbms/admin/utlrp_*.lst] files for spool files, if any

catcon.pl: completed successfully

[oraprod@upgdb03 admin]$

SQL>select count(*) from dba_objects where status = 'INVALID'; à again run this to verify the invalid objects. But after executing the above catcon.pl the invalid objects became 0.

Installing patch 36199232:

[oraprod@upgdb03 19.3.0]$ cd OPatch/LatestCPU/36209492/36199232/

[oraprod@upgdb03 36199232]$ sqlplus / as sysdba

SQL> shut immediate;

[oraprod@upgdb03 36199232]$ lsnrctl stop UPGCDB

[oraprod@upgdb03 36199232]$ /oraprod/oracle/db/19.3.0/OPatch/opatch apply

[oraprod@upgdb03 36199232]$ sqlplus /nolog

SQL> Connect / as sysdba

SQL> startup; SQL> alter pluggable database all open ;

SQL> quit;

[oraprod@upgdb03 36199232]$ cd $ORACLE_HOME/OPatch

[oraprod@upgdb03 OPatch]$ ./datapatch –verbose

[oraprod@upgdb03 OPatch]$ lsnrctl start UPGCDB

Note: The datapatch utility runs the necessary apply scripts to load the modified SQL files into the database. An entry is added to the dba_registry_sqlpatch view reflecting the patch application. In the dba_registry_sqlpatch view, verify that the status for the APPLY is SUCCESS.

SQL> select * from dba_registry_sqlpatch;

SQL>select count(*) from dba_objects where status = 'INVALID'; -> we did not see any invalid objects

Note: After installing the SQL portion of the patch, some packages could become INVALID. This will get recompiled upon access or you can run utlrp.sql to get them back into a VALID state.

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> @utlrp.sql

 

To verify the CPU patch level at Application Side:

1.

[applprod@upgapp03 oracle]$ . EBSapps.env run

[applprod@upgapp03 scripts]$ cd $PATCH_TOP

[applprod@upgapp03 patch]$ pwd

/applprod/oracle/fs_ne/EBSapps/patch

[applprod@upgapp03 patch]$ cd ECPUC/

[applprod@upgapp03 ECPUC]$ unzip p35583866_R12_GENERIC.zip

[applprod@upgapp03 ECPUC]$ sqlplus apps/apps@UPG

SQL> @ECPUC.sql

Start Time: 05-05-2024 15:38:13

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

E-Business Suite Critical Patch Update Checker (ECPUC)

 

ECPUC.sql may be run on any EBS 12.2 environment to identify missing

patches that are in the latest EBS CPU.

 

You can download the latest version of ECPUC via Patch 35583866.

 

Refer to the README.txt in Patch 35583866 for instructions for running

ECPUC and information regarding the generated ECPUC.lst report.

 

The checker generates the report ECPUC_YYYY-MM-DD_HH24-MI.lst that lists

recommended EBS CPU patches and security fixes for your environment

per Table 1 'CPU Patches for Oracle E-Business Suite' and

Table 2 'Additional Patches Required' documented in the

quarterly EBS CPU MOS Note.

 

Each quarterly EBS CPU MOS Note ID is unique. Refer to

My Oracle Support (MOS) Knowledge Document 2484000.1,

'Identifying the Latest Critical Patch Update for Oracle E-Business Suite

Release 12' which includes a link to the current EBS CPU MOS document.

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

====================================================================

SECTION-1 ECPUC Version

===================================================================

 

EBS CPU Checker Version

-----------------------

                2024.04

 

=========================================================================

SECTION-2 Oracle E-Business Suite (EBS): Instance Information

=========================================================================

 

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

Instance Summary

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

 

EBS Release                 EBS CPU Level

-----------                        -------------

12.2.7                            2024.04

 

Instance Name          Database                     Database Version

----------------                ----------------                ------------------

UPGCDB                      UPG                              19.23.0.0.0

 

ATG Product  Product Name                             Code Level

------------ ---------------------------------------- ----------

ad           Applications DBA                         C.14

txk          Oracle Applications Technology Stack     C.14

atg_pf       Oracle Applications Technology Family    C.7

fwk          Oracle Applications Framework            C.7

 

=========================================================================

SECTION-3 Required EBS CPU and Security Fixes

=========================================================================

 

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

The following output is a list of required patches and security fixes

that are missing in your environment.

 It is strongly recommended that you apply all of the listed patches as soon as possible.

 

If no patches (no rows) are listed then no additional action is required

at this time as your environment includes all patches for this EBS CPU.

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

no rows selected

 currently spooling to ECPUC_2024-05-05_15-38.lst

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

[applprod@upgapp03 ECPUC]$

 To verify the CPU patch level at Database Side:

 1.

select banner_full from v$version;

 2.

[oraprod@upgdb03 19.3.0]$ . UPGCDB_upgdb03.env

[oraprod@upgdb03 19.3.0]$ sqlplus / as sysdba

 SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 5 15:43:58 2024

Version 19.23.0.0.0

 

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

 

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.23.0.0.0

 

SQL>

 

3. 


 

 

·                                                                     -------------------END-----------------------

 

 


Comments

Post a Comment

Popular posts from this blog

adop phase=prepare failed with error "data dictionary corrupted"

  After fresh clone when I run adop phase=prepare then prepare phase failed with the error "data dictionary corrupted". Solution: Follow the instructions in the "Fix data dictionary corruption" section of My Oracle Support Knowledge Document 1531121.1 . *  Fix Data Dictionary Corruption ( Conditional ) Copy the script $AD_TOP/patch/115/sql/adzddmpfix.sql to the database tier. On the database tier, connect to the database as SYSDBA. Run the $AD_TOP/patch/115/sql/adzddmpfix.sql script. [oraprod@deverpdb01 12.1.0]$ sqlplus / as sysdba SQL> @adzddmpfix.sql On the application tier, run the $AD_TOP/sql/ADZDDBCC.sql script again to identify whether data dictionary corruption is still present. [applprod@deverpapp01 sql]$ cd $AD_TOP/sql [applprod@deverpapp01 sql]$ sqlplus apps @ADZDDBCC.sql a.     If no corruption is found, proceed with the upgrade or patching cycle. b.   ...
Read more

upgrade the AD/TXK Delta Patch to 14 in Oracle EBS R12.2.7

Image
  Environment: - Multi-node Applications (1 Internal Node & 1 External Node)    - Single Database Node - Version: Oracle EBS R12.2.7 and Database 19c ----------------------------------------------------------------------------------------------------------- We have to upgrade the AD/TXK level to 14. Follow the read me of AD patch 33600809 and perform all the steps as per read me and apply the patch using ADOP - Usually there will be only 2 patches to be applied to upgrade to AD/TXK. i.e. one patch for AD and another patch for TXK. But, in our environment we have Arabic Language enabled so I have to apply the AD/TXK patches for Arabic also. But, if no additional language is installed then you have to apply only English language patches which is the default. Below are the 4 patches which I have downloaded for English and Arabic If you have only English language in your setup then you have to download and install the below 2 patches only. 33600809:u33600809.drv  ...
Read more