从listener.log统计连接数据库的ip

cat listener.log|grep -i "establish"|awk -F "HOST=" '{print $2,$3}'|awk -F ")" '{print $1,$6,$7}'|awk -F "(" '{print $1,"=",$2}'|sort|uniq

cat listener.log|grep -i "establish"|awk -F '*' '{print $3}'|awk -F ')' '{print $2}'|awk -F '=' '{print $2}'|sort|uniq

取ip的前三段

cat listener.log|grep -i "establish"|awk -F '*' '{print $3}'|awk -F ')' '{print $2}'|awk -F '=' '{print $2}'|awk -F '.' '{print $1"."$2"."$3}'|sort|uniq



cat listener.log|grep -i "establish"|awk -F '*' '{print $3}'|awk -F ')' '{print $2}'|awk -F '=' '{print $2}'|awk -F '.' '{print $1"."$2"."$3".x"}'|sort|uniq