正德厚生,臻于至善

Oracle EBS adpatch 中出现意外后,如何再继续?

A. 首先用adctrl要停掉worker 进程
	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] : 
	......................................................
	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
		一路下来,没报任何错误,
	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 
赞(0) 打赏
未经允许不得转载:徐万新之路 » Oracle EBS adpatch 中出现意外后,如何再继续?
分享到: 更多 (0)

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏