EBS R12.2 - Check available Managed Server in Run and Patch filesystem

 In my case application servee is running on two nodes

Patch File System Managed Server on both nodes

SQL> set heading off
SQL> set pagesize 300;

SQL> SELECT
extractValue(XMLType(TEXT),'//oa_service_name[@oa_var="s_adminservername"]'),
extractValue(XMLType(TEXT),'//oacore_server_ports'),
extractValue(XMLType(TEXT),'//forms_server_ports'),
extractValue(XMLType(TEXT),'//oafm_server_ports'),
extractValue(XMLType(TEXT),'//forms-c4ws_server_ports'),
extractValue(XMLType(TEXT),'//oaea_server_ports')
from fnd_oam_context_files
where name not in ('TEMPLATE','METADATA')
and (status is null or status !='H')
and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type')='patch'
and CTX_TYPE = 'A'; 

 Node 1

AdminServer
oacore_server2:7201
forms_server2:7401
oafm_server2:7601
forms-c4ws_server2:7801

Node 2

AdminServer
oacore_server1:7201
forms_server1:7401
oafm_server1:7601
forms-c4ws_server1:7801

Run File System Managed Server on both nodes

SQL>  SELECT
extractValue(XMLType(TEXT),'//oa_service_name[@oa_var="s_adminservername"]'),
extractValue(XMLType(TEXT),'//oacore_server_ports'),
extractValue(XMLType(TEXT),'//forms_server_ports'),
extractValue(XMLType(TEXT),'//oafm_server_ports'),
extractValue(XMLType(TEXT),'//forms-c4ws_server_ports'),
extractValue(XMLType(TEXT),'//oaea_server_ports')
from fnd_oam_context_files
where name not in ('TEMPLATE','METADATA')
and (status is null or status !='H')
and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type')=' run';

Node 1

 AdminServer
oacore_server1:7202,oacore_server3:7204
forms_server1:7402
oafm_server1:7602
forms-c4ws_server1:7802

 Node2

AdminServer
oacore_server2:7202,oacore_server3:7204
forms_server2:7402
oafm_server2:7602
forms-c4ws_server2:7802