listener.log extract

[cruser3]

Hi,

Does any1 have a script to extract ip's (HOST=) and (PORT=)
values from a listener.log file?

We need to extract IP's and Port. nos from listener.logs.


TIA

[LKBrwn_DBA]

Check out this article.

[tomcat]

Awesome article...

[cruser3]

Hi,
Tx. - did my due diligence and got this article but was looking for a
shell script/unix utility - maybe based on sed or awk that can write what we need to a text file.

Rgds

[LKBrwn_DBA]

Try this:

#!/bin/ksh
awk '/HOST=/ && /PORT=/ {
i=match($0,"HOST="); i=i+RLENGTH; h0=substr($0,i); 
i=match(h0,")"); host=substr(h0,1,(i-1));
i=match($0,"PORT="); i=i+RLENGTH; h0=substr($0,i); 
i=match(h0,")"); port=substr(h0,1,(i-1));
print "Host="host", Port="port;
}' listener.log| \
sort -u

[yxez]

Hi all, i also want to capture all IP's that access my database(as a security audit). Is it available in listener.log? I thought it will reflect the client-server connections only...and not the web based using
apache http connect

[Bore]

Sure you can't see the browser's accessing the Apache via the database logs, since all the connections come to the database from the Apache and all you can see there is the IP of the apache machine.
Take a look into the Apache's access.log file

[yxez]

Thanks dear do u have similiar monitoring script like the one given by LnkBrwn_DBA used for apache logs. What others logs can
i monitor database access?