I need to run a select against all our databases, which are running on a separate server each.
I found this:
which seemed to be doing the trick, but it relies on /etc/oratab, but in our environment this file
is not in use, i.e.
/var/opt/oracle/oratab - this file has comments only and does not contain any real entries
/oracle/<SID>/11203/install/oratab - this file has 0 size