Apply ADOP Patches on R12.2

How to apply ADOP patches?

Simple way to apply ADOP patches:

0 -           Read the readme of patch.

0 -           Check patch weather already applied or not. ( select * from ad_bugs where bug_number =’no’;)

0 -           Check invalid objects ( select count(*) from dba_objects where status=’INVALID’)

0 -           Compile invalid objects using ADADMIN if necessary.

0 -           Copy unzip patch to fs_ne.  (For Eg: /u01/oracle/R1224/fs_ne/EBSapps/patch)

1 -           Source the Environment of Run File System. ( /u01/oracle/R1224/EBSapps.env run )

2 -           adop phase=prepare

3-            adop phase=apply patches=20901129 workers=24

4 -           adop phase=finalize

5 -           adop phase=cutover

6 -           Source the Environment of Run File System. (/u01/oracle/R1224/EBSapps.env run)

 

7 -           adop phase=cleanup

 

8 -           adop phase=fs_clone

Phases:

1. adop phase=prepare  :  Copies the application code.
2. adop phase=apply      :  Apply patches to PATCH Environment.
3. adop phase=finalize   :  Makes ready the system for cutover
4. adop phase=cutover  :  Bounce the system and does file system switch over.  
5. adop phase=cleanup  :  Remove obsolete objects.
6. adop phase=fs_clone  : Synchronize file systems.

Error handling:

1-    Cutover Phase Failed with Status 1 while starting application, again run cutover with:

        

Solution:

        

        Again run cutover with : adop phase = cutover mtrestart = no

        OR

        Bounce Server and run cutover again : adop phase = cutover

Other Helpful ADOP commands:

Hotpatch:

adop phase=apply hotpatch=yes patches={patch[,patch…]}

Retry (if failed):

adop phase=apply patches={patch[,patch…]} restart=yes abandon=no

Abort (if failed and cannot be fixed, you can abort the patching cycle):

adop phase=abort

If you are low on memory you can reduce the number of workers:

adop phase=apply {hotpatch=yes} patches={patch[,patch…]}  workers=1

           

Check Patch Cycle Status:

                        adop –status   

                        OR

                        adop –status -details

            Running Multiple ADOP Phases:

                        adop phase = prepare, apply patches = {patch no1, .., patch no. N} workers=10

 

ADOP Link:

   http://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm