Hi

From within a shell script my mailx doesnt seem to work...can somebody tell me what is wrong...

#!/bin/ksh
#Script to verify wheather all databases listed are up and running
#Script works with Oracle8 and above databases
#Script has to be run by ./scriptname
DBA=xiamin@unix.com
echo $DBA
PLATFORM=`uname`
if [ ${PLATFORM} != "SunOS" ]; then
ORATAB="/etc/oratab" #Digital Unix
else
ORATAB="/var/opt/oracle/oratab" #SunOS
fi
ALL_DATABASES=`cat $ORATAB|grep -v "^#"|grep -v "N$"|cut -f1 -d: -s`
for DB in $ALL_DATABASES
do
unset TWO_TASK
export ORACLE_SID=$DB
echo $ORACLE_SID
export ORACLE_HOME=`grep "^${DB}:" $ORATAB|cut -d: -f2 -s`
echo $ORACLE_HOME
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib;
echo "---> Database $ORACLE_SID, using home $ORACLE_HOME"
STATUS=`sqlplus -s system/manager <<EOF
set pagesize 0 feedback off verify off heading off echo off
select status from v\\$instance;
exit;
EOF`
if [[ $STATUS = "OPEN" ]]; then
echo "Dude Database $ORACLE_SID on `uname -n` is Down check it " \
>>/tmp/db_status.log
fi
done
echo $PATH
if [[ -s $db_status.log ]]; then
mailx -s "Database status from `uname -n`" $DBA <db_status.log
fi

it does not mail me the file db_status.log at all..whereas from the command prompt using mailx i can send mails to myslef..

regards
xiamin