How to find out what component of u r oracle applications were installed on which node?
Xml file (context file)
Below query also tells you node information :
select node_name, support_cp as "CMNODE" , support_forms as " Forms" , support_web as "WEB" , support_admin as "ADMIN", status from fnd_nodes ;
1 comment:
select
NODE_NAME,
decode(STATUS,'Y','ACTIVE','INACTIVE') Status,
decode(SUPPORT_CP,'Y', 'ConcMgr','No') ConcMgr,
decode(SUPPORT_FORMS,'Y','Forms', 'No') Forms,
decode(SUPPORT_WEB,'Y','Web', 'No') WebServer,
decode(SUPPORT_ADMIN, 'Y','Admin', 'No') Admin,
decode(SUPPORT_DB, 'Y','Rdbms', 'No') Database
from fnd_nodes
where node_name != 'AUTHENTICATION';
Post a Comment