昨天发现一台DB无法连接,原因是当前的已经达到了Oracle设置的最大连接数。刚好前几天看了一个shell能监控这个问题：
#!/bin/bash
#This shell can monitor the connection number for one service.
SERVICE_PORT="1521"
SERVICE_IP="172.16.219.193"
DEFINE_MAX_CONNECTION=1
MAIL_TO_USER="admin@abc.com"
#main function
check_connection()
{
netstat -na |grep ESTABLISH |grep $SERVICE_IP:$SERVICE_PORT |awk '{print $5}' |awk -F':' '{print $1}'|sort |uniq -c|awk '{print $1"="$2}'
}
for remote_ip in $(check_connection)
do
if [ $(echo $remote_ip|awk -F'=' '{print $1}') > $DEFINE_MAX_CONNECTION ]
then
ip=$(echo $remote_ip|awk -F'=' '{print $2}')
message="There are more than $DEFINE_MAX_CONNECTION from $ip to $SERVICE_IP:$SERVICE_PORT, I want to drop it, please check it ASAP!"
echo $message|mail $MAIL_TO_USER -s "A warning mail from $SERVICE_IP!"
fi
done
|
