Call: +44 (0)7759 277220 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.

Home » Archives » March 2005 » Nice listener.log error parsing script

[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

March 8th, 2005 by Pete

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.

  • PFCLScan

    Simply connect PFCLScan to your Oracle database and it will automatically discover the security issues that could make your Oracle database vulnerable to attack and to the potential loss of your data.

  • PFCL Obfuscate PFCLObfuscate

    PFCLObfuscate is the only tool available that can automatically add license controls to your PL/SQL code. PFCLObfuscate protects your Intellectual Property invested in your PL/SQL database code.

  • PFCL Training PFCLTraining

    PFCLTraining is a set of expert training classes for you, aimed at teaching how to audit your own Oracle database, design audit trails, secure code in PL/SQL and secure and lock down your Oracle database.

  • PFCL Services PFCLServices

    Choose PFCLServices to add Ltd to your team for your Oracle Security needs. We are experts in performing detailed security audits, data security design work and policy creation