ITPub博客

首页 > 数据库 > Oracle > Target node/queue unavailable

Target node/queue unavailable

原创 Oracle 作者:yhj20041128001 时间:2014-05-08 08:20:56 0 删除 编辑
 

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.2

EXEC FND_CONC_CLONE.SETUP_CLEAN;

COMMIT;

EXIT;

ii.3 Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers

to repopulate the required system tables.

P.S.

To run autoconfig on DB tier,you can go to $ORACLE_HOME/appsutil/scripts/SID_hostname/

./adautocfg.sh

To run autoconfig on APPS  tier you can go to $COMMON_TOP/ admin/scripts/SID_hostname/

./adautocfg.sh

iii)restart concurrent managers

     by execute $COMMON_TOP/admin/scripts/./adcmctl.sh start apps/xxx

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

上一篇: exp imp数据
请登录后发表评论 登录
全部评论

注册时间:2010-09-17

  • 博文量
    163
  • 访问量
    356261