if you wish for your Unix Oracle user to be able to connect to the remote server named prodwest, then the prodwest server must contain an .rhosts file in its Oracle user’s home directory. This file must contain an entry allowing the remote Oracle user to connect. Your system administrator can help you configure your .rhosts file.
# 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 & HP-UX) 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