通过分析Oracle监听日志，判断连接数据库情况 ### 分析监听日志 ``` #检查监听日志，登录情况，检查21点分布 fgrep "20-AUG-2018 21" listener.log|fgrep "establish" |awk '{print $1 " " $2}' |awk -F: '{print $1 ":" $2 }' |sort |uniq -c #检查每个小时 fgrep "29-FEB-2020" listener_hzcrksjk1.log|fgrep "establish" |awk '{print $1 " " $2}' |awk -F: '{print $1 }' |sort |uniq -c #通过IP分组 检查 grep "20-AUG-2018" listener.log >> listener20180820.log grep -i -o -E -r -e "([0-9]{1,3}\.){3}[0-9]{1,3}" listener.log| sort -n | uniq -c | sort -nr grep -i -o -E -r -e "([0-9]{1,3}\.){3}[0-9]{1,3}" $SH_HOME/listener`date +'%Y%m%d'`.log | sort -n | uniq -c | sort -nr ```