Call: +44 (0)1904 557620 Call

Pete Finnigan's Oracle Security Weblog

This is the weblog for Pete Finnigan. Pete works in the area of Oracle security and he specialises in auditing Oracle databases for security issues. This weblog is aimed squarely at those interested in the security of their Oracle databases.

[Previous entry: "Howard Rogers has started a new Oracle forum"] [Next entry: "Frank has an example on simple J2EE form based authentication"]

Nice listener.log error parsing script

I saw a good post on the Oracle-l list last night where the poster in a thread titled "tcl script for listener alert" asked if anyone had a TCL script to parse the listener.log file for error messages. He said that OEM came with a handy alert check for the alert log in the event library.

Dave posted a reply to the same thread where he tells us that he also couldn't find a TCL version so he wrote a Korn Shell script to parse the listener.log file. He says he has not had time to modify the script to deal with the listener being down for an extended time and a few other bits. Dave kindly included the source code for his KSH log parser.

This is a useful post that is worth reading and also to get the source code. I have not tried it yet purely due to time constraints.