Friday, March 12, 2010

Listener log parsing for unique connections

A small one liner to check out the unique IP addresses (or hostnames) from the listener.log.

cat /opt/oracle/10R2/network/log/listener.log | awk -F"=" {'print $10'} | sed -e 's/......$//g' | sort -k 1,1 -u
cat /opt/oracle/10R2/network/log/listener.log | awk -F"=" {'print $12'} | sed -e 's/......$//g' | sort -k 1,1 -u

No comments:

Post a Comment