Oracle proactive services team has provided the tool for analyzing the clone log files in a readable html format. This is very helpful for the DBA’s to quickly read the log files in rapid cloning.

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 below log files.

  • StageDBTier.log
  • StageAppsTier_.log
  • ApplyDBTier.log
  • ApplyDatabase.log
  • ApplyDBTechStack.log
  • ApplyAppsTechStack.log
  • ApplyAppsTier.log
  • CloneContext.log
  • make_.log, make.log
  • adconfig.log
  • ohclone.log
  • adcrdb_.txt
  • NetServiceHandler.log
  • setup_stubs.log
  • Central/Global oraInventory/logs directory and all sub-directories, for any files with a .err, .log or .txt extension

Installation in DB:

$ cp LogParser.zip $ORACLE_HOME/appsutil/clone
$ cd $ORACLE_HOME/appsutil/clone
$ unzip LogParser.zip

 

Installation in Application:

$ cp LogParser.zip <COMMON_TOP>/clone/
$ cd <COMMON_TOP>/clone/
$ unzip LogParser.zip

Log Parser will look for all the latest logs for each log type. If there are 2 (or more) log files of the same type and name, the Log Parser will determine which file was created most recently and disregard the older file.

Usage:

$ cd LogParser
$ perl LogParser.pl

There are other usage and those can be explored and used effectively.

Recommended Posts

Start typing and press Enter to search