Oracle EBS Log Parser
As anyone who has ever performed an Oracle E-Business suite clone knows it can be a complex time consuming task, any error during the cloning process may result in a considerable amount of time been spent reviewing multiple clone log files in various directories on the Apps & Database tiers. To assist with this challenge the Oracle Proactive Support Team developed the ‘Log Parser’, this utility is able to consolidates error information from the 12 seperate clone log files into a easy to read HTML report. The ‘Log Parser’ also perform some basic configuration checks and reports this along with useful recommendations and the Oracle support pages links.
The Log parser analyses the following logs:
- 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
The installation couldn’t be much simpler – download, extract, run
You can download the ‘Log Parser’ directly from ‘My Oracle Support’ – E-Business Suite Clone Log Parser Utility (Rapid Clone 11i,12.0, 12.1) (Doc ID 1447553.1)
Database Tier
Download the ‘Log Parser’ zip file into /tmp and unzip the file into $ORACLE_HOME/appsutil/clone
Once you have unzipped the Log Parser your a ready to navigate to the LogParser directory and run the LogParser perl script.
On completion you will have a new HTML report available for your review
Transfer this back to your desktop an open in your preferred browser, click on the ‘Show Details’ links in the various sections to expand the report.
Applications Tier
Download the ‘Log Parser’ zip file into /tmp and unzip the file into <COMMON_TOP>/clone
Once you have unzipped the Log Parser your a ready to navigate to the LogParser directory and run the LogParser perl script.
On completion you will have a new HTML report available for your review, as before click on the ‘Show Details’ to expand the report.
Transfer this back to your desktop an open in your preferred browser.
In a future post I will walk through the Log Parser report and review the output.
Oracle EBS and Delphix
The Delphix EBS solution provides AppsDBA’s, functional consultants, test teams and business users the ability to perform Self Service on-demand EBS environment (Database, Database Tier & AppsTier) clones. This dramatically reduced the end-to-end provision time coming down from multiple weeks to a mater of minutes.
In a couple of previous posts I have provided a walkthrough of how to Virtualise your EBS environment and also how to create a new Virtual EBS environment.