Oracle - Patching While Adpactch Is Running

Installation of a patch during another patch installation

CREATED BY: CREATED ON:

DAMIAN BROIT AUGUST, 13

PATCH INSTALLATION

CHANGE HISTORY Release
1.0

Date
13-Aug-07

Author
Damian Broit

Description
Initial Document

REVIEWERS Name
Cintia Petiet

Title/Role
Manager

COPYRIGHT STATEMENT © 2007 IT Convergence Support Services (ISS) This document may not be copiedor duplicated without the express written consent of IT Convergence Support Services.

2 OF 12

PATCH INSTALLATION

Table of Contents
Table of Contents............................................................................................................ 3 Introduction .....................................................................................................................4 Patching ........................................................................................................................... 5
Installation of a patch during another patch installation ......................................................................... 5Conclusions................................................................................................................... 11 References..................................................................................................................... 12

3 OF 12

PATCH INSTALLATION

Introduction
Sometimes it may happen that while ‘adpatch’ is running, one of the workers fails. In some cases, in order to fix this worker and continue with the patch installation, a new patch needs to be applied. Thisdocument is a step by step manual indicating the workaround procedure which has to be completed to solve the previously mentioned issue successfully.

4 OF 12

PATCH INSTALLATION

Patching
These are the steps needed to complete the procedure. They will be thoroughly explained with examples below. • • • • • • Shutdown the workers Backup FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS tables owned by‘applsys’ schema. Backup the .rf9 files Drop the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table and apply the new patch Restore the .rf9 files, FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table Re-create synonyms and Start adpatch Installation of the patch will be resumed where it stopped previously.

Installation of a patch during another patch installation
Started runningpatch 3218526 – “11i.BNE.D” and while doing so, installation was stopped in order to first install patch 4291053 “LANGUAGE FILE SETUP FOR BNE.D” which is a prerequisite of 11i.BNE.D. Follow the steps in order to deal with this situation: 1. Using the adctrl utility, shutdown the workers. a. adctrl b. Select option 3 "Tell worker to shutdown/quit"
[applvis1@itc-ba-apptest 3218526]$ adpatch . Filename[adpatch.log] : u3218526.log . Enter the directory where your Oracle Applications patch has been unloaded . The default directory is [/u02/app/patches/ATG_PF.HR5/3218526] : u3218526.drv . Enter the directory where your Oracle Applications patch has been unloaded The default directory is [/u02/app/patches/ATG_PF.HR5/3218526] : Please enter the name of your AutoPatch driver file : u3218526.drv ADController Menu --------------------------------------------------1. 2. Show worker status Tell worker to restart a failed job

5 OF 12

PATCH INSTALLATION

3. 4. 5. 6. 7.

Tell worker to quit Tell manager that a worker failed its job Tell manager that a worker acknowledges quit Restart a worker on the current machine Exit

Enter your choice [1] : 3 Enter the worker number(s)/range(s) or'all' for all workers, or press [Return] to go back to the menu : all Control Control Control Control code code code code changed changed changed changed to to to to 'Quit' 'Quit' 'Quit' 'Quit' for for for for worker worker worker worker 1. 2. 3. 4.

2. Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema a. sqlplus applsys/ b. create table fnd_Install_processes_back...