Shell Programming and Scripting

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

Hi,

If mailx is working from the command prompt, one other reason can be that the file db_status.log may not be available.

If the input file db_status.log is not available , mailx does nothing.

Regards,
raju

Hi,

You are generating the file in /tmp directory.So, are you running the script the the same directory because you are checking the file's existence in current directory and also for mailing.

One more thing is that you have used $db_status.log while checking if the file exists but while mailing you are using just db_status.log

May be you need to remove $ while checking for the existence of the file.

Regards,
raju

Hi

Raju thank you for your help..i debugged the problem by littering my code with a lot of debug statements somethin like this..

func1 ()
echo "i ma enetering func1"
lottas of cpde
...........


func2()
echo "i am enetering func2"
loattas of code
......

The problem was with the following line..
if [[ -s $db_status.log ]];

my code never reached the line below it ..i cahnged it to..

if [[ -s db_status.log ]];

now every thing works..fine...

regards
xiamin