[原创]Oracle EBS 打补丁中(如停电等)出现意外,如何处理后,可以再继

laozhu

今天一个网友问的,现在整理一下...供大家参考!


A. 首先要停掉worker 进程
D:\oracle\zhucomn\admin\scripts\ZHU_oratest>adctrl
                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA
                                 AD Controller
                                 Version 11.5.0
此处省略了很多。。。
....................................................
...................................................
Enter the ORACLE username of Application Object Library [APPLSYS] :
Enter the ORACLE password of Application Object Library [APPS] : apps
......................................................

                    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] : 3
Enter the worker number(s)/range(s) or 'all' for all workers,
or press [Return] to go back to the menu : all
Control code changed to 'Quit' for worker 1.
Control code changed to 'Quit' for worker 2.
Control code changed to 'Quit' for worker 3.
Control code changed to 'Quit' for worker 4.
Control code changed to 'Quit' for worker 5.
Control code changed to 'Quit' for worker 6.
Review the messages above, then press [Return] to continue.


B. 解决方法：（参考的METALINK：175485.1）
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 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;
3.  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_back;
       select count(*) from AD_DEFERRED_JOBS;
4.  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_back
    c. mkdir restart
5.  Drop the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table.
    a. sqlplus applsys/<password>
    b. drop table FND_INSTALL_PROCESSES;
    c. drop table AD_DEFERRED_JOBS;
6.  Reapply the patch 2451368
   - adpatch 回车后，都按DEFAULT 的输入，
   在Please enter the name of your AutoPatch driver file : c2451368.drv（此方法是正常的方法)
   一路下来，没报任何错误，
   - 再次运行adpatch 回车后，都按DEFAULT 的输入
   在Please enter the name of your AutoPatch driver file : d2451368.drv
   一路下来，没报任何错误，
    哈哈。。这样patch 就打成功了。。
   
7.  Restore the .rf9 files located in $APPL_TOP/admin/<SID>/restart_back
    directory.
    a. cd $APPL_TOP/admin/<SID>
    b. mv restart restart_<patchnumber>
    c. mv restart_back restart
8. 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_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/<password>
    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. adadmin 中 disable mantaince model 修改
12. 启动CM(并发管理器） adcmctl start apps/apps