It seems that you encounter again for error Target node/queue unavailable.
Please perform again as below order:
i) So to clean FND_CONCURRENT_QUEUES,run cmclean.sql
i.1 Stop the concurrent manager via run adcmctl.sh stop apps/xxx
Notice:before run cmclean.sql,you must make sure the concurrent manager shutdown clearly.
That is :you must ensure there is no other returns after execute except itself:
To verify no FNDLIBR processes are running
you can use :
ps -ef |grep FNDLIBR
and if find there are a lot of return rows,just keep waiting,-it usually take about 10
minites,util there is only one return rows.
i.2 Connect SQLPLUS as APPS user and run @adcmclean.sql in SQLPLUS session:
!Notice:You need to issue a commit once the script is run for the changes to take effect.
ii) To rebuild FND_NODES,FND_OAM_CONTEXT_FILES, etc
ii.1 Connect SQLPLUS as APPS user,
ii.3 Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers
to repopulate the required system tables.
To run autoconfig on DB tier,you can go to $ORACLE_HOME/appsutil/scripts/SID_hostname/
To run autoconfig on APPS tier you can go to $COMMON_TOP/ admin/scripts/SID_hostname/
iii)restart concurrent managers
by execute $COMMON_TOP/admin/scripts/
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23757700/viewspace-1156394/，如需转载，请注明出处，否则将追究法律责任。