2. execute EXEC FND_CONC_CLONE.SETUP_CLEAN.
3. Execute autoconfig at all nodes.
4. Run the below mentioned queries:
SELECT EXTRACTVALUE(XMLTYPE(text),'//*[@oa_var="s_contextfile"]')
S_CONTEXTFILE,
EXTRACTVALUE(XMLTYPE(text),'//*[@oa_var="s_contextname"]') S_CONTEXTNAME,
EXTRACTVALUE(XMLTYPE(text),'//*[@oa_var="s_contexttype"]') S_CONTEXTTYPE,
EXTRACTVALUE(XMLTYPE(text),'//*[@oa_var="s_systemname"]') S_SYSTEM_NAME,
EXTRACTVALUE(XMLTYPE(text),'//*[@oa_var="s_hostname"]') S_HOSTNAME,
EXTRACTVALUE(XMLTYPE(text),'//*[@oa_var="s_domainname"]') S_DOMAINNAME,
EXTRACTVALUE(XMLTYPE(text),'//*[@oa_var="s_apps_user"]') S_APPS_USER,
name AS NAME FROM fnd_oam_context_files
WHERE (status is null OR status != 'H')
AND (name NOT IN ('METADATA','TEMPLATE'));
Or
select EXTRACTVALUE(sys.XMLType(TEXT),'//file_edition_name'), EXTRACTVALUE(sys.XMLType(TEXT),'//APPL_TOP[@oa_var="s_at_adconfig"]'), EXTRACTVALUE(XMLType(TEXT),'//ORACLE_HOME[@oa_var="s_tools_oh"]'), EXTRACTVALUE(XMLType(TEXT),'//TWO_TASK[@oa_var="s_tools_twotask"]'), EXTRACTVALUE(XMLType(TEXT),'//APPLFENV'), path, EXTRACTVALUE(XMLType(TEXT),'//APPLTMP'), EXTRACTVALUE(XMLType(TEXT),'//APPLREP'), EXTRACTVALUE(XMLType(TEXT),'//LD_LIBRARY_PATH[@oa_var="s_tools_ldlib"]'), EXTRACTVALUE(XMLType(TEXT),'//NE_BASE[@oa_var="s_ne_base"]'), EXTRACTVALUE(XMLType(TEXT),'//patch_jdbc_connect_alias[@oa_var="s_apps_patch_alias"]'), EXTRACTVALUE(XMLType(TEXT),'//JAVA_TOP'), EXTRACTVALUE(XMLType(TEXT),'//oa_context_name[@oa_var="s_contextname"]'), EXTRACTVALUE(XMLType(TEXT),'//jdbc_url[@oa_var="s_apps_jdbc_connect_descriptor"]'), EXTRACTVALUE(XMLType(TEXT),'//patch_jdbc_url[@oa_var="s_apps_jdbc_patch_connect_descriptor"]') from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F'))
and EXTRACTVALUE(sys.XMLType(TEXT),'//oa_context_name[@oa_var="s_contextname"]') = 'SMNH2I_vmohsmnhm062';
