Some Useful Links / Queries

How to Synchronize the AD tables FND_NODES, ADOP_VALID_NODES, and FND_OAM_CONTEXT_FILES in 12.2 when adop fails. (Doc ID 2064223.1)

12.2 E-Business Suite Applications Manager Non SSL HTTP URL Displayed When Selecting Self Service / HTML OAM Client Links (Like Workflow Or License Manager) Causing 'Page Not Found' Errors (Doc ID 2257838.1)

Find CPU details

select STAT_NAME,to_char(VALUE) as VALUE ,COMMENTS from v$osstat where stat_name IN ('NUM_CPUS','NUM_CPU_CORES','NUM_CPU_SOCKETS') 

UNION

select STAT_NAME,VALUE/1024/1024/1024 || ' GB' ,COMMENTS from v$osstat where stat_name IN ('PHYSICAL_MEMORY_BYTES');