Home » Oracle » Adop(Ad online patching utility) explained R12.2

Adop(Ad online patching utility) explained R12.2

Adop (Ad online patching utility)  is used in R12.2 to apply the patches online with out any downtime.it is the new utility which to apply patches in online patching mode .It is Perl script and call adpatch  internally to apply the patch. It is not recommended to apply the patches directly using adpatch in R12.2

For online patching to work Oracle Apps make use of 11g database feature called as “Edition Based Redefinition”, under this feature. On the Applications side, there will be two file systems, one called as patch and other called as run file system. Both are identical to each other and services will be running out of run file system. During patching process, patches are applied to patch file system, which does not require any downtime. For the patch changes to come to effect, patch file system is switched as run file system and vice versa, and services are restarted. In essence, Downtime will be only for the time duration during which services are restarted.

A complete patching cycle is following while applying the patches with adop. It consists of many phases

Complete R12.2 online patching cycle and phases(Ad online patching utility)

1.Prepare: This syncs the current patch file system with run file system, to make sure patch file system is up to date compared to run file system and ready for the patches to get applied. This also created a new patch edition in the database. This syncing process is incremental process to be efficient.

Adop online patching prepare phase (Ad online patching utility)

$ adop phase=prepare

Detailed Description can be found at below link

See also  Steps to upgarde 11i Application database to 11gR1

what happens in the adop phase prepare

2.Apply   : Patches are applied to patch file system during this phase, we can apply as many patches we want during this phase. Changed code objects are from patch edition of database. Changes to oracle tables are stored in new columns which are only visible from patch edition of the database.

Adop online patching apply phase(Ad online patching utility)

$ adop phase=apply patches=<patch no>
  • Multiple patches can be applied, including customization’s
  • Patches are applied to the copy (Patch Edition)
  • The production application is unaffected by the changes
  • Users are connected to the Application and can perform their work unaffected by the patch
  • Changes are made in the isolation of an Edition
  • The running application is unaffected by these changes

Downtime and Hotpatch apply mode in adop R12.2

3.Finalize: This phase involves compiling of invalid objects etc.

Adop online patching finalize phase

$ adop phase=finalize

4. Cutover : This phase configures the patch file system as new run file system and patch edition of the database as new run edition. Restart application services from new run file system of Apps. This is where downtime is required.

Adop online patching cutover phase

$ adop phase=cutover

Detailed Description can be found at below link

what happens in cutover phase of adop in R12.2

5.Cleanup: Deletes obsolete code objects and columns from earlier patch edition are removed at  Oracle database.

Adop online patching cleanup phase

$ adop phase=cleanup

Some more things about adop

1)Online Help

To obtain help about the basics of adop operation, enter the command:

adop -help

2)   Enabling maintenance mode is not required in R12.2; it’s not applicable for online patching.

3) There are also three special phases, for use when needed.
Special phases:
abortAbort the current patching cycle.
actualize_all – Create new copies of all code objects in the patch edition.
fs_clone – Copy the run file system to the patch file system.

See also  How to check failed login attempts in Oracle

4)The adop logfiles are located on the non-editioned file system (fs_ne), under:
s_ne_base/EBSapps/log/adop//__/ext_name>/log
For example, if s_ne_base was /u01/apps/R122_EBS/fs_ne, the session ID was 20, and the
was sunxy_test, the path to the adop log files from 1th July 2013 would resemble this:
/u01/apps/R122_EBS/fs_ne/EBSapps/log/adop/20/apply_20130701_112226/sunxy_testsys/log

5)
You can obtain a brief report for the current patching session by running the command:

$adop -status

This will display information that includes phases completed and the time taken

Oracle has provided few videos for ADOP. Please check below metalink note

E-Business Suite – ADOP Basic Usage Training Videos [Video] (Doc ID 2103131.1)

Conclusion

ADOP(Ad online patching utility)  is a wonderful tool provided by Oracle. Now we can patch the system online and Bounce the system at low activity time to activate the patches. Organization often need to apply patches for bug-fixes but they have to wait for long time to find the downtime window to apply the patches . Online patching solves this problem

Related Articles on R12.2
40 question you must know about R12.2
Important stuff about R12.2
Installation of an EBS 12.2 Vision Instance
oracle ebs tutorials
How to rollback the patch after failed cutover phase in R12.2
31 Useful adop (AD online patching ) command line for R12.2

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top