Oracle apps:Topology information



Last updated on November 23rd, 2015 at 03:32 pm

Here is the statement to find out Topology information for R12/R11i

SELECT
fn.HOST || ‘.’ || fn.DOMAIN HOSTNAME,
ftlp.PORT,
fdi.SID SID
FROM FND_DATABASES fd,
FND_DATABASE_INSTANCES fdi,
FND_TNS_LISTENERS ftl,
FND_TNS_LISTENER_PORTS ftlp,
FND_APP_SERVERS fas,
FND_NODES fn
WHERE fd.DB_GUID=fdi.DB_GUID
AND fdi.SERVER_GUID=fas.SERVER_GUID
AND ftl.LISTENER_GUID = ftlp.LISTENER_GUID
AND ftl.SERVER_GUID = fas.SERVER_GUID
AND fn.NODE_ID = fas.NODE_ID;

select NAME, SERVER_TYPE from FND_APP_SERVERS, FND_NODES where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID and SERVER_TYPE=’DB’ and FND_NODES.NODE_NAME=’&1′;


Leave a Reply