Applying one-off patches using adop in oracle ebs r12.2

 

A.     Patch Installation Plan:

Note: Kindly first take the backup of application & DB tier and then start patching.

On Application Primary Node:

1.       Source the environment file.

[applprod@prodapp ~]$ cd /applprod/oracle/

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

[applprod@prodapp oracle]$

 

2.       Run adop fs_clone

[applprod@prodapp ~]$ adop phase=fs_clone

 

3.       Run Prepare phase

[applprod@prodapp ~]$ adop phase=prepare

 

4.       Download and unzip the below patches and move it to the PATCH_TOP of both the application nodes

p33463852_R12.PO.D_R12_ar.zip

p33463852_R12.PO.D_R12_LINUX.zip

p33885151_R12.PO.D_R12_ar.zip

p33885151_R12.PO.D_R12_LINUX.zip

p34708635_R12.TXK.C_R12_GENERIC.zip

p31530798_R12.PON.D_R12_GENERIC.zip

 

5.       Apply Patches

[applprod@prodapp scripts]$ cd $PATCH_TOP

 

6.       [applprod@prodapp patch]$ adop phase=apply patches=33885151:u33885151.drv,33885151_AR:u33885151.drv,33463852:u33463852.drv,33463852_AR:u33463852.drv

[applprod@prodapp ~]$ adop phase=apply patches=34708635

[applprod@prodapp patch]$ adop phase=apply patches=31530798

 

7.       [applprod@prodapp ~]$ adop phase=finalize

 

Note: shutdown the services of all application nodes as below, before step 8

 

[applprod@prodapp ~]$ cd $ADMIN_SCRIPTS_HOME

[applprod@prodapp ~]$./adstpall.sh

[applprod@prodsupplier ~]$ cd $ADMIN_SCRIPTS_HOME

[applprod@prodsupplier ~]$./adstpall.sh

 

8.       [applprod@prodapp ~]$ adop phase=cutover

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

[applprod@prodapp oracle]$ cd $ADMIN_SCRIPTS_HOME

[applprod@prodapp scripts]$ ./adstrtal.sh

[applprod@prodsupplier ~]$./adstrtal.sh

[applprod@prodapp scripts]$ adop –status

 

9.       [applprod@prodapp ~]$ adop phase=cleanup

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

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

Image
  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 ======================================================================== ***************************************************************************...
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