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

 

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    --------->this is for AD

33602997:u33602997.drv    --------->this is for TXK

Let's start:

First, copy Arabic & English AD/TXK patches to the PATCH_TOP of both the nodes and unzip it. 

steps:

1. Create $ORACLE_HOME/appsutil/admin on database server.

2. Compare version of adgrants.sql in $APPL_TOP/admin to version in patch directory.

[applprod@deverpapp01 oracle]$ cd $APPL_TOP/admin

[applprod@deverpapp01 admin]$ adident Header adgrants.sql

 

[applprod@deverpapp01 ] $ cd $PATCH_TOP/33600809/admin

[applprod@deverpapp01 admin]$ adident Header adgrants.sql

3. Copy whichever is the higher version of adgrants.sql to $ORACLE_HOME/appsutil/admin.

[applprod@deverpapp01 admin]$ scp adgrants.sql oraprod@deverpdb01:/oraprod/oracle/db/12.1.0/appsutil/admin/

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

[oraprod@deverpdb01 12.1.0]$ . UPG_deverpdb01.env

[oraprod@deverpdb01 12.1.0]$ cd $ORACLE_HOME

5. Run the adgrants.sql script using SQL*Plus:

[oraprod@deverpdb01 12.1.0]$ sqlplus /nolog

     SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS     ------àAPPS is schema name here

6. When running the adgrants.sql script

    SQL> ALTER USER EBS_SYSTEM ACCOUNT UNLOCK;

The initial password for EBS_SYSTEM must the same as the SYSTEM password. To change the      password, run the following command:

   SQL> ALTER USER EBS_SYSTEM IDENTIFIED BY <PASSWORD>

[applprod@deverpapp01 oracle]$ adop phase=apply patches=33600809:u33600809.drv,33600809_AR:u33600809.drv,33602997:u33602997.drv,33602997_AR:u33602997.drv

If any patch failed then you can rerun the apply command with additional parameter as shown below.

[applprod@deverpapp01 oracle]$ adop phase=apply patches=33600809:u33600809.drv,33600809_AR:u33600809.drv,33602997:u33602997.drv,33602997_AR:u33602997.drv abandon=yes restart=no     --àhere apply will take around 3 hours.

-----------------------END---------------------