#!/bin/ksh
# Loop through each host name . . .
for host in `cat ~oracle/.rhosts|\
cut -d"." -f1|awk '{print $1}'|sort -u`
do
  echo " "
  echo "************************"
  echo "$host"
  echo "************************"
  # Loop through each database name
  #    /etc/oratab (AIX & HPUX) or
  #    /var/opt/oracle/oratab in Solaris
  for db in `rsh $host\
 "cat /etc/oratab|egrep ':N|:Y'|\
grep -v \*|cut -f1 -d':'"`
  do
     # Get the ORACLE_HOME for each database
     home=`rsh $host "cat /etc/oratab|\
egrep ':N|:Y'|grep -v \*|grep ${db}|\
cut -f2 -d':'"`
     echo " "
     echo "database is $db"
  done
done