Target node/queue unavailable

 

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/，如需轉載，請註明出處，否則將追究法律責任。