How to execute empty patching cycle, without applying any patch.

Introduction:-

In this article, we will learn how to execute empty patching cycle in EBS. we will do the cutover to switch filesystem from fs1 to fs2 without applying any patches.

Running An Empty Patching Cycle Without Applying Patch

Some time we have to do the switch over from run to patch and vice versa. To fulfill the requireemtn here we will execute the emptly patching cycle. We are doing cutover from run to patch file system, in case of testing,switch run to patch or vice versa.

How to fix ADOP Cutover failed PRE_CUTOVER_CHECKS_COMPLETE

The steps to run an empty patch cycle is:

Quick Version:

$ cd <EBS_ROOT>

$ source EBSapps.env run

$ adop phase=prepare,finalize,cutover

$ source EBSapps.env run

$ adop phase=cleanup

 

Complete Version:

$ cd <EBS_ROOT>

$ source EBSapps.env run

$ adop phase=prepare

$ adop phase=actualize_all

$ adop phase=finalize finalize_mode=full

$ adop phase=cutover

$ source EBSapps.env run

$ adop phase=cleanup cleanup_mode=full

How to execute empty patching cycle in single command?

We can simply execute empty patching cycle in single command as below:-

$adop phase=prepare,finalize,cutover,cleanup

Status:-

$adop -status

How do you check patch is applied or not?

To check wether patches applied or not. We will have to simply check it using below query.

To find sigle patch information:-

SQL> SELECT ab.bug_number,ad_patch.is_patch_applied('R12',-1, ab.bug_number) FROM ad_bugs ab WHERE ab.bug_number='2343455';

To check multiple patches, Please use below query:

SQL>SELECT ab.bug_number,ad_patch.is_patch_applied('R12',-1, ab.bug_number) FROM ad_bugs ab WHERE ab.bug_number in ('4564335','5456765',
'3453235','2345641','23234567','34542345','67563456','4345432');

To check patches in multinode environment.

SQL> SELECT ab.bug_number,apt.node_name,ad_patch.is_patch_applied('R12', apt.APPL_TOP_ID, ab.bug_number)
FROM ad_bugs ab,
( select APPL_TOP_ID, n.node_name
from ad_appl_tops t, fnd_nodes n
where instr(UPPER(t.NAME),UPPER(n.node_name)) >= 1 ) apt
WHERE ab.bug_number in ( '&BUG_ID');

R12.2: How To Run An Empty Patching Cycle Without aply patch.

Leave a Comment