How to i apply new patch while Adpatch is running.

How to Apply an 11i Patch When adpatch is Already Running =============================================== 1. Using the adctrl utility, shutdown the workers. a. adctrl b. Select option 3 "Tell worker to shutdown/quit" 2. Backup the FND_INSTALL_PROCESSES, AD_DEFERRED_JOBS table which is owned by the APPLSYS schema a. sqlplus applsys/ b. create table fnd_Install_processes_back as select * from fnd_Install_processes; c. The 2 tables should have the same number of records. select count(*) from fnd_Install_processes_back; select count(*) from fnd_Install_processes; 3. Backup the AD_DEFERRED_JOBS table. a. sqlplus applsys/ b. create table AD_DEFERRED_JOBS_back as select * from AD_DEFERRED_JOBS; c. The 2 tables should have the same number of records. select count(*) from AD_DEFERRED_JOBS_back; select count(*) from AD_DEFERRED_JOBS; 4. Backup the .rf9 files located in $APPL_TOP/admin//restart directory. At this point, the adpatch session should have ended and the cursor should be back at the Unix prompt. a. cd $APPL_TOP/admin/ b. mv restart restart_back c. mkdir restart 5. Drop the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table. a. sqlplus applsys/ b. drop table FND_INSTALL_PROCESSES; c. drop table AD_DEFERRED_JOBS; 6. Apply the new patch. Restore backup files 7. Restore the .rf9 files located in $APPL_TOP/admin//restart_back directory. a. cd $APPL_TOP/admin/ b. mv restart restart_ c. mv restart_back restart 8. Restore the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema. a. sqlplus applsys/ b. create table fnd_Install_processes as select * from fnd_Install_processes_back; c. The 2 tables should have the same number of records. select count(*) from fnd_Install_processes; select count(*) from fnd_Install_processes_back; 9. Restore the AD_DEFERRED_JOBS table. a. sqlplus applsys/ b. create table AD_DEFERRED_JOBS as select * from AD_DEFERRED_JOBS_back; c. The 2 tables should have the same number of records. select count(*) from AD_DEFERRED_JOBS_back; select count(*) from AD_DEFERRED_JOBS; 10. Re-create synonyms a. sqlplus apps/apps b. create synonym AD_DEFERRED_JOBS for APPLSYS.AD_DEFERRED_JOBS; c. create synonym FND_INSTALL_PROCESSES FOR APPLSYS.FND_INSTALL_PROCESSES; 11. Start adpatch, it will resume where it stopped previously. Note:175485.1 ====== while running patch Dropping FND_INSTALL_PROCESSES table... Connecting to APPLSYS......Connected successfully. DROP TABLE fnd_install_processes DELETE FROM ad_timestamps WHERE TYPE = 'FND_INSTALL_PROCESSES' FND_INSTALL_PROCESSES table dropped. Dropping AD_DEFERRED_JOBS table... DROP TABLE AD_DEFERRED_JOBS AD_DEFERRED_JOBS table dropped. Done generating forms. Connecting to APPS......Connected successfully.