EBS workflow agent 出现状态System Hold, Fix Manager before resetting counters

最新推荐文章于 2021-04-09 21:10:47 发布

转载最新推荐文章于 2021-04-09 21:10:47 发布 · 159 阅读

本文提供了一套详细的步骤来清理Oracle中间件服务中的并发管理器表，包括停止所有中间件服务、数据库操作、运行CMCLEAN.SQL脚本以及重新启动服务等关键步骤。

1. Stop all middle tier services including the concurrent managers.
Please make sure that no FNDLIBR, FNDSM, or any dead process is running.

2. Stop the database.

3. Start the database.

4. Go to cd $FND_TOP/bin
$ adrelink.sh force=y "fnd FNDLIBR"
$ adrelink.sh force=y "fnd FNDFS"
$ adrelink.sh force=y "fnd FNDCRM"
$ adrelink.sh force=y "fnd FNDSM"

5. Run the CMCLEAN.SQL script. from the referenced note below (don't forget to commit).
Article- ID : 134007.1
Title: CMCLEAN.SQL - Non Destructive Script. to Clean Concurrent Manager Tables

6. Execute the following SQL:
select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME like 'FNDSM%';

7. Start the middle tier services including your concurrent manager.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-717132/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-717132/