Target Node/Queue Unavailable
Posted by Roshan on Oct 02, 2017; 8:43am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Target-Node-Queue-Unavailable-tp3695.html
EBSR12.1.3
Hi Erman,
on my test instance, I am getting Target Node/Queue Unavailable on concurrent manager. I have followed (Doc ID 732709.1)
From query below, I see the node name is ERPPROD(production) despite running the steps in doc. Please advise if I need to truncate the fnd_concurrent_queues.
SQL> select node_name,target_node,control_code from fnd_concurrent_queues;
NODE_NAME TARGET_NODE C
------------------------------ ------------------------------ -
ERPPROD E
ERPPROD E
ERPPROD N
ERPPROD E
ERPPROD N
ERPPROD N
ERPPROD ERPMIGRT
ERPPROD N
ERPPROD
ERPPROD N
ERPPROD N
NODE_NAME TARGET_NODE C
------------------------------ ------------------------------ -
ERPPROD N
ERPPROD N
ERPPROD
ERPPROD N
ERPPROD N
ERPPROD N
ERPPROD N
ERPPROD
ERPPROD N
ERPPROD N
ERPPROD E
NODE_NAME TARGET_NODE C
------------------------------ ------------------------------ -
ERPPROD N
ERPPROD
ERPPROD E
ERPPROD N
ERPPROD N
ERPPROD E
ERPPROD E
ERPPROD E
ERPPROD E
ERPPROD E
ERPPROD N
NODE_NAME TARGET_NODE C
------------------------------ ------------------------------ -
ERPPROD N
ERPPROD E
ERPPROD E
ERPPROD E
ERPPROD N
ERPPROD N
ERPPROD N
ERPPROD E
ERPPROD E
ERPMIGRT E
ERPMIGRT E
NODE_NAME TARGET_NODE C
------------------------------ ------------------------------ -
ERPMIGRT E
ERPPROD N
Regards,
Roshan