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).
Need an Oracle query to get the Oracle Home directory for a particular instance
oracle
oracle
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).
Best Answer
You can do this from a Unix shell, like so: