Tuesday, April 14, 2020

dbalarm Script Updated!

I've added one more feature to the system monitoring script dbalarm to monitor the inodes number on each mounted filesystem on the system to provide an early warning before the inodes number get exhausted.

I've published one post explaining the impact of getting inodes number exhausted:
http://dba-thoughts.blogspot.com/2020/04/no-space-left-on-device-error-while.html

To download the final version of dbalarm script:
https://www.dropbox.com/s/a8p5q454dw01u53/dbalarm.sh?dl=0

To read more about dbalarm script and how it monitors the DB server:
http://dba-tips.blogspot.com/2014/02/database-monitoring-script-for-ora-and.html

Soon I'll update the same in the bundle tool as well.

Here is the GitHub version:

4 comments:

  1. im getting the below while nothing is currently running
    Please make sure the following sessions are completed before running dbalarm script: [ps -ef|grep -v grep|grep -v vi|grep dbalarm]

    ReplyDelete
  2. Do you get any output when running this command?
    ps -ef|grep -v grep|grep -v vi|grep dbalarm

    ReplyDelete
  3. Then please hash the following lines in the script from line 87 to 97:

    # Check if there is another session of dbalarm is running: [Avoid performance impact]
    DBALARMCNT=`ps -ef|grep -v grep|grep -v vi|grep dbalarm|wc -l`
    if [ ${DBALARMCNT} -gt 2 ]
    then
    echo -e "\033[32;5mdbalarm.sh script is currently running by another session.\033[0m"
    echo ""
    echo "Please make sure the following sessions are completed before running dbalarm script: [ps -ef|grep -v grep|grep -v vi|grep dbalarm]"
    ps -ef|grep -v grep|grep -v vi|grep dbalarm.sh
    echo "Script Terminated !"
    echo
    exit
    fi

    ReplyDelete