Shell Programming and Scripting

 
for line in `awk -F"[#:*]" 'NF==3&&$1~/./{print $1}' /wload/clht/app/etc/oratab` ; do
ps -ef|grep $line|grep pmon  > /dev/null
if [ $? -eq 0 ] ; then
echo "DB $line is up and running"
else
echo "DB $line is not running"
#Your DB startup script goes in here I would say set ORACLE_SID to $line before you startup
fi
done

for line in `awk -F"[#:*]" 'NF==3&&$1~/./{print $1}' /var/opt/oracle/oratab` ; do
ps -ef|grep $line|grep pmon > /dev/null
if [ $? -eq 0 ] ; then
echo "DB $line is up and running"
else
echo "DB $line is not running"
fi
done

 sh -x script_name

awk -F[#:*] NF==3&&$1~/./{print $1} /var/opt/oracle/oratab

host $ sh -x test.ksh
+ awk -F[#:*] NF==3&&$1~/./{print $1} /var/opt/oracle/oratab