Shell Programming and Scripting

#!/bin/ksh

##-To load Oracle user profile

##./monitor_io.ksh
##./test.ksh

SCP_DIR=/export/home/yani_m/scripts


LOG_DIR=${SCP_DIR}/log/IOSTATS
BAD_DIR=${SCP_DIR}/bad/IOSTATS
CTL_FILE=${SCP_DIR}/IOSTATS
PAR_FIL=${SCP_DIR}/parfile/IOSTATS.par
DSC_DIR=${SCP_DIR}/discard/IOSTATS
BCK_UP_DIR=${SCP_DIR}/BCK_UP_DIR_IOSTATS

##-Check if there is no current instance of this script is running

Check_Proces ()
{
PS_NAME=`echo $0 | awk -F/ '{ print $NF }' | awk '{ print $1 }'`
ACTIVE=`ps -ef |grep $PS_NAME |grep -v "sh -c" |grep -v grep |wc -l`
echo $PS_NAME $ACTIVE
if [ $ACTIVE -ge 2 ];  then
   echo "An instance of the script is already running : " $PS_NAME
   exit
fi
}

##-Check if the file to load exist in the directory and load it

Load_Stats()
{
cd ${SCP_DIR}

for file in `ls -1|grep FILE_TO_LOAD.dat`
do
   if(test -s $file)
   then
       sqlldr parfile=${PAR_FIL}/$file.par control=${CTL_FILE}/$file data=${DATA_FIL}/$file LOG=${LOD_DIR}/$file.log BAD=${BAD_DIR}/$file.bad
   fi
##-send notification if loader fails
   if [ $? -eq 1 ]
   then
     echo "LOADER FAILED TO LOAD THE FILE"
   fi

##-check for errors in the log file

  ORAerr=`cat ${LOG_DIR}/${file}.log | grep ORA- |grep -v ORA-00001`
      ORAerrtmp=`echo $ORAerr| awk '{print substr($1,1,3)"-"}'`
      if [ $ORAerrtmp == "ORA-" ];
      then
         echo"File not loaded sent to discard directory"
         mv ${file}/$DSC_DIR}
     exit
     else
         mv $file ${BCK_UP_DIR}
    fi
done
}

Check_Process
Load_Stats

Check_Proces ()