Script To Monitor Filesystem (Mount Point) Space or Utilization

Pre-requisites to Run the script:

Make sure mailx  is installed on your OS, also check below environements/file is created prior to execute the scripts.

This script is tested on Linux Server.

This script needs to be deployed in database node/server.

#Base location for the DBA scripts
DBA_SCRIPTS_HOME=$HOME/DBA_MON

#OS User profile where database environment file is set
$HOME/.bash_profile

Create Custom .sysenv file for scripts

Download(.sysenv)

Download .sysenv file and save it under $HOME/DBA_MON
$ chmod 777 .sysenv

$ cat $HOME/DBA_MON/.sysenv

export DBA_SCRIPTS_HOME=$HOME/DBA_MON
export PATH=${PATH}:$DBA_SCRIPTS_HOME
export DBA_EMAIL_LIST=kiran.jadhav@domain.com,jadhav.kiran@domain.com
#Below parameter is used in script, whenever there is planned downtime you can set it to Y so there will be no false alert.
export DOWNTIME_MODE=N

Script to check Filesystem space and send notification if filesystem usage% is more than given threshold..



Download(FSMon.sh)

Download FSMon.sh and save it under $HOME/DBA_MON/bin/
$ chmod 755 FSMon.sh

#!/bin/bash

############################################################
# Script Name : FSMon.sh                                   # 
#                                                          #
# Description:                                             # 
# Script to check Filesystem space and send notification   #
# if filesystem usage% is more than given threshold.       #                                                                          
#                                                          #
# Usage : sh <script_name> <Used% Threshold>               #
# For example : sh FSMon.sh 90                             #
#                                                          #
# Created by : Kiran Jadhav -(https://h2hdba.blogspot.com) #
############################################################

# Initialize variables

THRESHOLD=$1
HOST_NAME=`hostname | cut -d'.' -f1`
PROGRAM=`basename $0 | cut -d'.' -f1`
export DBA_SCRIPTS_HOME=$HOME/DBA_MON
LOG_DIR=$DBA_SCRIPTS_HOME/logs/$HOST_NAME
OUT_FILE=$LOG_DIR/`echo $PROGRAM`.out
LOG_FILE=$LOG_DIR/`echo $PROGRAM`.log
ERR_FILE=$LOG_DIR/`echo $PROGRAM`.err
LOG_DATE=`date`


# Source the env
. $HOME/.bash_profile
. $DBA_SCRIPTS_HOME/.sysenv

if [ $? -ne 0 ]; then
   echo "$LOG_DATE" > $LOG_FILE  
   echo "Please pass correct environment : exiting the script  \n" >> $LOG_FILE
   cat $LOG_FILE
   exit
fi

if [ -s $OUT_FILE ]; then
 echo "$LOG_DATE" > $LOG_FILE
 echo "Deleting existing output file $OUT_FILE" >> $LOG_FILE
 rm -f $OUT_FILE
 cat $LOG_FILE
fi

if [ $DOWNTIME_MODE = "Y" ]; then
 echo "$LOG_DATE" >> $LOG_FILE
 echo "Host: $HOST_NAME | Instance: $ORACLE_SID is under maintenance: exiting the script" >> $LOG_FILE
 cat $LOG_FILE
 exit
fi

usage()
{
 echo "$LOG_DATE" > $LOG_FILE
        echo "Script to monitor OS Filesystem"  >> $LOG_FILE
        echo "Usage   : sh <script_name> <Used% Threshold>  " >> $LOG_FILE
 echo "For example : sh $PROGRAM.sh 90" >> $LOG_FILE
        echo
}

if [ $# -lt 1 ]; then
    usage
    echo "Error : Insufficient arguments." >> $LOG_FILE
 cat $LOG_FILE
    exit
fi


/bin/df -h|grep -ivE '^Filesystem|tmpfs|cdrom|vol' | awk '{print $(NF-1),"\t",$NF}'| while read output;
do
  #echo $output
  usep=$(echo $output | awk '{ print $1}' | cut -d'%' -f1  )
 # partition=$(echo $output | awk '{ print $1 }' )
  filesystem=$(echo $output | awk '{ print $2 }' )
  if [ $usep -ge $THRESHOLD ]; then
    echo "Filesystem: \"$filesystem\"   is \"($usep%)\"   FULL" >> $OUT_FILE
  fi
done 

if [ -s $OUT_FILE ]; then
 mailx -s "Critical: Filesystem usage is more than $THRESHOLD% on $HOST_NAME" $DBA_EMAIL_LIST < $OUT_FILE
else 
 echo "Disk Space Usage is normal" > $LOG_FILE  
fi

Logs and Out files will be generated under $DBA_SCRIPTS_HOME/logs/$HOST_NAME
So make sure to create logs/$HOST_NAME directory under $DBA_SCRIPTS_HOME before executing 
the script.

Once the script is ready, then as per the requirement please schedule it in crontab/OEM.

Execute the Script as below:

Syntax :  sh <script_name> <Used% Threshold>  

$ cd $HOME/DBA_MON/bin
$ sh FSMon.sh 90

This script will send the notification with details if any of the mount point usage 

reached to 90% or Above.