How to continue the failed adpatch session

1.  Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema

a. sqlplus applsys/<password>

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;

2.  Backup the AD_DEFERRED_JOBS table.

a. sqlplus applsys/<password>

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_backup;

select count(*) from AD_DEFERRED_JOBS;

3.  Backup the .rf9 files located in $APPL_TOP/admin/<SID>/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/<SID>

b. mv restart restart_backup

c. mkdir restart

4.  Drop the FND_INSTALL_PROCESSES table and the AD_DEFFERED_JOBS table.

a. sqlplus applsys/<password>

b. drop table FND_INSTALL_PROCESSES;

c. drop table AD_DEFERRED_JOBS;

5.  Apply the new patch.

6.  Restore the .rf9 files located in $APPL_TOP/admin/<SID>/restart_backup

directory.

a. cd $APPL_TOP/admin/<SID>

b. mv restart restart_<patchnumber>

c. mv restart_backup restart

7. Restore the FND_INSTALL_PROCESSES table which is owned by the APPLSYS

schema.

a. sqlplus applsys/<password>

b. create table fnd_Install_processes

as select * from fnd_Install_processes_backup;

c. The 2 tables should have the same number of records.

select count(*) from fnd_Install_processes;

select count(*) from fnd_Install_processes_backup;

8. Restore the AD_DEFERRED_JOBS table.

a. sqlplus applsys/<password>

b. create table AD_DEFERRED_JOBS

as select * from AD_DEFERRED_JOBS_backup;

c. The 2 tables should have the same number of records.

select count(*) from AD_DEFERRED_JOBS_backup;

select count(*) from AD_DEFERRED_JOBS;

9. 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;

10. Start adpatch, it will resume where it stopped previously.