Search Blog Post

Saturday, September 7, 2013

Find concurrent manager nodes on Oracle Apps

1- Use the following query:
  SQL> select node_name from apps.fnd_nodes where support_cp='Y';

NODE_NAME
------------------------------
GDDEVCM1

So, basically my concurrent managers reside on GDDEVCM1 node  in my case.


2- Check the variable < TIER_NODE oa_var="s_isConc" >YES< / TIER_NODE> on the context file:
    $ grep s_isConc $CONTEXT_FILE
    YES means that this node is a concurrent manager node.

oraDEV@gddevcm1:/mnt/DEVapps/trccomn/admin/scripts/TRCDEV_gddevcm1 ->cd $APPL_TOP/admin

oraDEV@gddevcm1:/mnt/DEVapps/trcappl/admin ->grep s_isConc TRCDEV_gddevcm1.xml
         <TIER_NODE oa_var="s_isConc">YES</TIER_NODE>
         <TIER_NODEDEV oa_var="s_isConcDev">YES</TIER_NODEDEV>


3- Check for the foundation library (FNDLIBR) processes
     $ ps -ef  | grep FNDLIBR

4- Check the report server processes:
      $ ps -ef | grep ora_rw

No comments:

Post a Comment