ADOP utility in R12.2.10

 Overview of ADOP in Oracle EBS R12.2

ADOP – stands for Application DBA Online Patching which is introduced in Oracle EBS R12.2 

version to patch oracle applications while a system is available for users during Patching.

NOTE: The adop utility always runs from the run edition file system. 

Full application functionality is retained as patch execution proceeds, 

until the cutover phase is reached.

The online patching cycle consists of five of high level phases:

prepare: Prepares the environment for patching.

apply: Applies the specified patches to the environment.

finalize: Performs any final steps required to make the system ready for cutover.

cutover: Shuts down application tier services, makes the patch edition the new run edition, 

and then restarts application tier services. This is the only phase the involves a brief downtime.

cleanup: Removes obsolete code and data from old editions.

Important commands related to ADOP

FILE EDITION SWAP

[applmgr@oracle~#] echo $FILE_EDITION

run

RUN to PATCH <nothing changes in RUN>

Adop phase=prepare

Adop phase=cutover

Adop phase=CLEANUP

Adop -STATUS


RUN to PATCH <make changes in RUN>


Adop phase=FS_CLONE

Adop phase=prepare

Adop phase=cutover

Adop phase=CLEANUP

Adop -STATUS

 

SYN with RUN to PATCH

 

Adop phase=FS_CLONE   <schedule job every second Sunday>

 Or before patch trigger adop phase=FS_CONE

 

ANYTHING fails in adop cycle before cutover phase


adop phase=abort

adop phase=cleanup cleanup_mode=full

adop phase = fs_clone

Adop -STATUS

 

OR

 

adop phase=abort

adop phase=cleanup cleanup_mode=full  <Failed>

adop phase = fs_clone

Adop -STATUS

 

Try below steps:

 

adop phase=abort

adop phase=cleanup cleanup_mode=quick

adop phase = fs_clone

Adop -STATUS

 

Fixed issue and again try below command:

Adop phase=prepare

Adop phase=apply patches=(patch_no)

Adop phase=FINALIZE

Adop phase=cutover

Adop phase=CLEANUP

Adop -STATUS

 

Adop session reach 20 after that run below steps (Max adop session value is 24)

 

Actualize_All and Full Cleanup:

             adop phase=prepare

            adop phase=actualize_all

            adop phase=finalize

            adop phase=cutover

            adop phase=cleanup cleanup_mode=full


adop option

apply a patch in downtime mode:

 adop phase=apply patches=32300055 apply_mode=hotpatch

 

Restart a apply command

adop phase=apply patches=31993886 restart=yes

 

Abandon previous apply command and apply replacement

adop phase=apply patches=223456 abandon=yes

 

Restart failed fs_clone from the beginning:

             adop phase=fs_clone force=yes


No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...