Need an Oracle query to get the Oracle Home directory for a particular instance I am searching for a query to get the Oracle Home for a particular instance name, say Eagle (if there are more than one instance on the host).
You can do this from a Unix shell, like so:

[oracle@node1 ~]$ grep "^YOURSID:" /etc/oratab | cut -d: -f 2
/u01/app/oracle/product/11.2.0/dbhome_1
[oracle@node1 ~]$