What is the most appropriate way to discover Oracle Resources on a host?
Hi,
I want to have a host inventory,then discover Oracle resources on every hosts like ORACLE_SID, dbhome, gridhome etc. Then i want to automate some DBA related stuff using ansible. Is /etc/oratab the best way to accomplish that or is there a better way to do it? As i understand Enterprise Manager does something similar to what i am looking for.