Search: For:
Browsing Single Category
www.dbatoolz.com ORACLE DBA Forums Solutions › Topic Id: 1542 | Permalink

how to skip an adpatch job in adctrl - use undocumented option 8

Topic ID: 1542
Created By: 2007-JAN-30 14:11:37 [Vitaliy]
Updated By: 2007-JAN-30 14:11:48 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
5080
2007-JAN-30 14:11:37
Moderator
 
 
Registered On: Mar 2006
Total Posts: 233
To skip an adpatch job in adctrl use undocumented option 8 (See below):

--------------------------------- start adctrl output -----------------------------

                    AD Controller Menu
     ---------------------------------------------------

     1.    Show worker status

     2.    Tell worker to restart a failed job

     3.    Tell worker to quit

     4.    Tell manager that a worker failed its job

     5.    Tell manager that a worker acknowledges quit

     6.    Restart a worker on the current machine

     7.    Exit




Enter your choice [1] : 8

Enter the worker number(s)/range(s) or 'all' for all workers,
or press [Return] to go back to the menu : 2

Status changed to 'Skip & restart' for worker 2.
Review the messages above, then press [Return] to continue.


Enter your choice [1] :


        Control
Worker  Code      Context                 Filename              Status
------  --------  ----------------------  --------------------  --------------
     1  Run       AutoPatch R115                                Wait
     2  Run       AutoPatch R115          bilrmfnm.sql          Skip & restart
     3  Run       AutoPatch R115                                Wait
     4  Run       AutoPatch R115                                Wait
     5  Run       AutoPatch R115                                Wait
     6  Run       AutoPatch R115                                Wait
     7  Run       AutoPatch R115                                Wait
     8  Run       AutoPatch R115                                Wait
     9  Run       AutoPatch R115                                Wait
    10  Run       AutoPatch R115                                Wait
    11  Run       AutoPatch R115                                Wait
    12  Run       AutoPatch R115                                Wait

Review the messages above, then press [Return] to continue.

Enter your choice [1] :


        Control
Worker  Code      Context                 Filename              Status
------  --------  ----------------------  --------------------  --------------
     1  Run       AutoPatch R115          asxtbrnm.sql          Assigned
     2  Run       AutoPatch R115          GMDFKCON.sql          Completed
     3  Run       AutoPatch R115          becbrco1.sql          Assigned
     4  Run       AutoPatch R115          bertgco1.sql          Assigned
     5  Run       AutoPatch R115          bomalttb.sql          Assigned
     6  Run       AutoPatch R115          cctvarr.sql           Assigned
     7  Run       AutoPatch R115          GMFFKCON.sql          Running
     8  Run       AutoPatch R115          CZ_CONFIG_PAIR_REC.x  Assigned
     9  Run       AutoPatch R115          CZ_DATE_TBL_TYPE.xdf  Assigned
    10  Run       AutoPatch R115          CZ_EXPL_PAIR.xdf      Assigned
    11  Run       AutoPatch R115          CZ_TXN_PARAMS_TYPE1.  Assigned
    12  Run       AutoPatch R115          CZ_UIREFS_INMODEL_OB  Assigned

Review the messages above, then press [Return] to continue.




--------------------------------- start adpatch output -----------------------------
....

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

    Fixed: file bilrmfnm.sql on worker  2 for product bil username BIL.
Completed: file bilrmfnm.sql on worker  2 for product bil username BIL.

Starting phase 5 (A5): con+1


There are now 92180 jobs remaining (current phase=A5):
    0 running, 51 ready to run and 92129 waiting.

  Skipped: file akcucs.sql for product ak: objects are up-to-date.
 Assigned: file asxtbrnm.sql on worker  1 for product as  username OSM.
 Assigned: file asxwobjt.sql on worker  2 for product as  username OSM.
 Assigned: file becbrco1.sql on worker  3 for product ben username BEN.
 Assigned: file bertgco1.sql on worker  4 for product ben username BEN.
 Assigned: file bomalttb.sql on worker  5 for product bom username BOM.
 Assigned: file cctvarr.sql  on worker  6 for product cct username CCT.
  Skipped: file csxren2.sql for product cs: objects are up-to-date.
 Assigned: file CZ_CONFIG_ATTRIBUTE_TYPE.xdf on worker  7 for product cz  username APPS.
 Assigned: file CZ_CONFIG_PAIR_REC.xdf on worker  8 for product cz  username APPS.
 Assigned: file CZ_DATE_TBL_TYPE.xdf on worker  9 for product cz  username APPS.
 Assigned: file CZ_EXPL_PAIR.xdf on worker 10 for product cz  username APPS.
 Assigned: file CZ_TXN_PARAMS_TYPE1.xdf on worker 11 for product cz  username APPS.
 Assigned: file CZ_UIREFS_INMODEL_OBJ_TYPE.xdf on worker 12 for product cz  username APPS.
Completed: file asxwobjt.sql on worker  2 for product as  username OSM.
 Assigned: file CZ_UIREFS_INMODEL_TBL_TYPE.xdf on worker  2 for product cz  username APPS.
Completed: file CZ_CONFIG_ATTRIBUTE_TYPE.xdf on worker  7 for product cz  username APPS.
 Assigned: file ECXGOBJ.sql  on worker  7 for product ecx username ECX.
Completed: file CZ_UIREFS_INMODEL_TBL_TYPE.xdf on worker  2 for product cz  username APPS.
Completed: file ECXGOBJ.sql  on worker  7 for product ecx username ECX.
 Assigned: file affurgos.sql on worker  2 for product fnd username APPLSYS.
 Assigned: file wfrename2.sql on worker  7 for product fnd username APPLSYS.

There are now 92174 jobs remaining (current phase=A5):
    12 running, 33 ready to run and 92129 waiting.
--------------------------------- end adpatch output -----------------------------
[edited by: Vitaliy at 14:11 (CST) on Jan. 30, 2007]