Oracle Database

Extracting IP’s From Oracle Listener Log

There may be times when you want to extract all the client and host IP’s from the listener log to see who’s connecting to a particular database or service.

I was interested in a particular service so the following will extract all IP’s connecting in to that service. Please not that our listener logs are rotated and zipped.

You could tweak it and pipe it to nslookup to get actual hostname but for my requirements the above was enough.

Leave a Reply

Your email address will not be published. Required fields are marked *

CAPTCHA * Time limit is exhausted. Please reload CAPTCHA.