Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

1.3.1) EBS Technology Codelevel Checker

Use EBS Technology Codelevel Checker (ETCC) to check if all required database patches have been applied.

Download patch 17537119. Unzip patch and run script ./checkDBpatch.sh

>>All the required one-offs are present in Oracle Database Home

Run script for APPS tier:

[applmgr@tvmdb19 ETCC]$ ./checkMTpatch.sh

Script reported that patch 22107540 is missing in FMW webtier 11.1.1.9, though DOC 1594274.1 claims that it's included in startCD v51.

Apply patch using opatch, setting necessary environment variables:

[applmgr@tvmdb19 22107540]$ which opatch

/u01/app/apps/fs1/FMW_Home/webtier/OPatch/opatch

[applmgr@tvmdb19 22107540]$ ls

etc  files  README.txt

[applmgr@tvmdb19 22107540]$ opatch apply

egrep -i "error|fail|ora-|ac-|rc-"   /u01/app/apps/fs1/FMW_Home/webtier/cfgtoollogs/opatch/22107540_Mar_22_2016_10_56_20/apply2016-03-22_10-56-19AM_1.log

After that script reports no patches required to be applied:

1.3.2) Pre-patch analysis

[-]20745242 (R12.AD.C.Delta.7)

[-]22123818:R12.AD.C

[-]20784380 (R12.TXK.C.Delta.7)

[-]22363475:R12.TXK.C

[-]22495069:R12.TXK.C

Pre-steps:

20745242, 22123818:

Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.

 Usage:

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

 2. Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin

    to that in patch directory.

 3. Copy the higher version of adgrants.sql (UNIX) to

    $ORACLE_HOME/appsutil/admin.

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

 5. Use SQL*Plus to run the script:

    UNIX:

    $ sqlplus /nolog

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

1.3.3) Patches application

Pre-steps:

20745242, 22123818:

Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.

 Usage:

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

 2. Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin

    to that in patch directory.

 3. Copy the higher version of adgrants.sql (UNIX) to

    $ORACLE_HOME/appsutil/admin.

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

 5. Use SQL*Plus to run the script:

    UNIX:

    $ sqlplus /nolog

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

On the run edition application tier file system, use hotpatch mode to apply Patch 20745242 (R12.AD.C.Delta.7).

$ adop phase=apply patches=20745242 hotpatch=yes

Apply Patch 22123818:R12.AD.C in hotpatch mode.

$ adop phase=apply patches=22123818 hotpatch=yes

Applying patch 22123818.

   Log: /u01/app/apps/fs_ne/EBSapps/log/adop/2/apply_20160324_011756/PROD_tvmdb19/22123818/log/u22123818.log

AutoPatch error:

Please apply adgrants.sql file in database tier before applying this patch

Solution:

I applied adgrants.sql script from 20745242 patch. This script was lower version that the one supplied with 22123818. Need to re-execute correct adgrants.sql once more.

Note: The above patches must be applied in the order mentioned above.

On the run edition application tier file system, use hotpatch mode to apply Patch 20784380:R12.TXK.C.Delta.7 merged with Patch 22363475:R12.TXK.C and Patch 22495069:R12.TXK.C (plus additional critical patches - see note box).

$ adop phase=apply patches=20784380,22363475,22495069 hotpatch=yes merge=yes

Note: As per subsection 4.2 Critical TXK Patches, you should also add any applicable TXK patches to the list of patches in this command.

Source the run edition environment file.

UNIX:

$ . <EBS_ROOT>/EBSapps.env run

Update all database tier nodes with the latest code, by performing the following steps:

On the Application Tier (as the APPLMGR user):

Run AutoConfig on the run file system.

Execute the admkappsutil.pl utility to create the appsutil.zip file in <INST_TOP>/admin/out.

$ perl <AD_TOP>/bin/admkappsutil.pl

On the Database Tier (as the ORACLE user):

Source the environment variables for RDBMS ORACLE_HOME.

UNIX

$ cd <RDBMS ORACLE_HOME>

$ . ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME>.env

Copy or FTP the appsutil.zip file to <RDBMS ORACLE_HOME>.

Uncompress appsutil.zip, under <RDBMS ORACLE_HOME>.

$ cd <ORACLE_HOME>

$ unzip -o appsutil.zip

Run AutoConfig on <RDBMS ORACLE_HOME>.

Source: Internet