Siebel Database Upgrade Guide > Reviewing the Siebel Upgrade Log Files >

Summarizing Siebel Log Files Using the Logparse Utility

Upgrades from: All Supported Siebel releases.

Environments: Development, production test, production.

Platforms: Windows and UNIX only. Does not apply to IBM z/OS.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

Use the Logparse utility to analyze and summarize the log files created when you run the Upgrade Wizard.

The Logparse utility writes its findings to a summary file:

Windows: SIEBEL_ROOT\log\PROCESS\summary.html

UNIX: $SIEBEL_ROOT/log/PROCESS/summary.html


Process is the upgrade process you want to review, for example, upgrep_dev_77

The Logparse utility also writes a summary.txt file that contains the same information as summary.html. Use the summary.txt file if you do not have a browser.

After writing the output files, the Logparse utility opens summary.html automatically.

Table 33 lists the command line syntax for the Logparse utility.

Table 33. Command Line Syntax for the Logparse Utility



Full path to the parent directory of SIEBEL_ROOT ($SIEBEL_ROOT). For example, if SIEBEL_ROOT is C:\sba80\siebsrvr, then install_dir is C:\sba80.

Enclose the path in quotes.




The language in which the Upgrade Wizard ran. This is called the resource language, and typically is the language in which you ran the Siebel Installation Wizard. For example, if the resource language is English, the language code is enu.




Name of the schema process for which you want to generate a summary file, for example upgrep_dev_77.

To obtain the schema process name, look in \siebsrvr\log. The subdirectory names in \log are the schema process names.




Name of the Logparse log file.




Maximum number of longest-running SQL to display in the summary.

Default value=10



Threshold time for longest running SQL, in the format hh:mm:ss.

Default value= 00:10:00

(By default, SQLs that run longer than 10 minutes are displayed)



Maximum number of errors to display in the summary.

Default = 8

To run the Logparse utility

  1. Navigate to the following directory:

    Windows: SIEBEL_ROOT\bin


  2. Run the following command. Use the syntax in Table 33:

    logparse /s install_dir /g LANGUAGE_CODE /r PROCESS /l LOGPARSE_FILENAME

    Windows example (Upgrade Wizard language is English):

    logparse /s C:\sea7xx /g enu /r upgrep_dev_704 /l logparse.log /n 10 /t 00:00:10
    /e 10

  3. Review the Logparse log and verify that Logparse ran without errors.

    Windows: SIEBEL_ROOT\bin\logparse.log

    UNIX: $SIEBEL_ROOT/bin/logparse.log

Related Topics

About the Siebel Database Upgrade Log Files

Reviewing Siebel Upgrade Log Files for Errors

Siebel Database Upgrade Guide Copyright © 2008, Oracle. All rights reserved.