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:
Import Shell Script For Importing Data On Oracle
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]
Do you get any output when running this command?
ps -ef|grep -v grep|grep -v vi|grep dbalarm
nop
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 " 33[32;5mdbalarm.sh script is currently running by another session. 33[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