本文记录了在OracleEBS R12环境下遇到的中文Patch安装问题及解决过程。通过使用ADController工具检查Worker状态并调整表空间设置，最终成功解决了系统处于维护模式无法退出的问题。
最近安装了一套 Oracle EBS R12,在打中文Patch时，报如下错误。
FAILED: file FNDNLINS.sql on worker 1.
FAILED: file JTFNLINS.sql on worker 3.
退出ADADMIN后，无法进入ERP,报如下错误。
The system has not been taken off maintenance mode completely. Please contact your System Administrator.
重新启动AP，无效。折腾了一上午，仍然未搞定。
在网上搜了很久，未找到合适的方法，都说是要进ADADMIN关掉维护模式，可是根本就进不了ADADMIN。
无意中发现一篇文章是说可以用adctrl进入AD Controller查看Worker运行的状态，在输入ADCTRL之后，进入如下画面：
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
选择【1】
Enter your choice [1] :
Control
Worker Code Context Filename Status
------ -------- ----------------- -------------------------- --------------
1 Run Generic R120 FNDNLINS.sql Restarted
2 Run Generic R120 Wait
3 Run Generic R120 PERNLINS.sql Restarted
4 Run Generic R120 Wait
5 Run Generic R120 Wait
6 Run Generic R120 Wait
7 Run Generic R120 Wait
8 Run Generic R120 Wait
Review the messages above, then press [Return] to continue.
忘记是在那里看到是说表空间不做，赶快将所有表空间改为自动扩展后，再在 AD Controller中选[2],发现ADADMIN在跑了，哈哈，看到希望啦！
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
扫一扫
215
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
