#!/bin/ksh
# Loop through each database name
# on the host /etc/oratab . . .
for db in `cat /etc/oratab|egrep ':N|:Y'|\
grep -v \*|cut -f1 -d':'`
do
  # Get the ORACLE_HOME for each database
  home=`cat /etc/oratab|egrep ':N|:Y'|\
grep -v \*|grep ${db}|cut -f2 -d':'`
  echo " "
  echo "database is $db"
  cd $home/network/admin
  ln -s /etc/tnsnames.ora\
        $home/network/admin/tnsnames.ora
done