Oracle proactive services team has provided the tool for analyzing the patch log files in a readable html format. This is very helpful for the DBA’s to quickly read the log files for huge patching activity.
The purpose of this log parser is to consolidate the log files and report in html format spotting issues and warning with clear messages. The tool locates errors in the main adpatch log file, then correlates and joins that error to point-in-time messages within the other logs, such as the adrelink log, the adworker logs and any request file (.req) logs
Installation:
$ cp PatchLogParser<date>.zip <installation directory of your choice>
$ cd <installation directory>
$ unzip PatchLogParser<date>.zip
How to run it?
- To analyze multiple patch log files
$perl parse.pl u1235467.log u89056445.log adpatch.log
- To zip the patch logs and analyze log in html format.
$perl parse.pl u1223567.log u89102345.log adpatch.log zip
- To analyze real time failures.
$perl dig.pl
