Verifying the successful Siebel database installation

The following checkpoints exist for verification of a successful Siebel database installation:

• The HTML summary generated by the Log Parser
• Existence of tables and data in the Siebel database

In the following section, we will describe how to use the Siebel Log Parser to monitor or document Siebel Upgrade Wizard processes and we will review tables and their content to verify the Siebel database installation.

Using the Siebel Log Parser

The Siebel Log Parser is implemented as a command line utility named logparse.exe. It is situated in the BIN subdirectory of the Siebel Server installation folder.

We can open a Windows command prompt, navigate to the Siebel Server's BIN directory, and type logparse to make first contact with the utility. As some required parameters are missing, the utility reports the parameter switches on the command line.

/S Siebel Root (Required)
/G Language code of log files to be processed (Required)
/R Process Name (Required)
/L Log file for this utility (Default: logparse.log)
/N Number of longest running sqls to show (Default: 10)
/T Threshold time in hh:mm:ss format (Default: 00:10:00)
/E Max number of errors to display in steps summary (Default: 8)

The above listing is generated by the logparse utility when it is called with no input parameters. As we can see, the utility requires the path to the Siebel installation root directory (/S), the language code of the log files (/G), and the name of the Siebel Upgrade Wizard process (/R). The name of the Siebel Upgrade Wizard process is the same as the name of the log output directory entered during the configuration process.

So, a correct command line for creating a report on the install process would be as follows:

logparse /S D:\SIA8 /G ENU /R install

The utility now parses all log files in the install subdirectory of the Siebel Server's log directory and generates a set of HTML files and a text summary file. If a default browser is specified on Microsoft Windows, the start page for the HTML summary is loaded automatically. The following screenshot shows the start page in Microsoft Internet Explorer.

We can click on the Steps/Errors hyperlink to see a detailed list of all executed steps and their statuses. If all steps have a status of Complete and the Upgrade Wizard has finished successfully, this is an indicator for the successful installation of the Siebel database.

The Siebel Log Parser can be used for any process executed by the Siebel Upgrade Wizard. It is extremely useful to monitor and document complex and lengthy procedures such as upgrading a Siebel database to a newer version.

Verifying tables and data

The following SQL query can be helpful in verifying the successful Siebel database installation. We can run the select statement using the SIEBEL table owner account.

SQL> select activity_name, tgt_version from s_inst_upg_hist order by activity_ts desc;

The select statement retrieves the list of upgrade (or Siebel Upgrade Wizard) activities from the S_INST_UPG_HIST table. As this is the last action that is carried out by the Siebel Upgrade Wizard, it is a good indicator for success. The ACTIVITY_NAME column contains the name of the driver file used to run the Siebel Upgrade Wizard process.

ACTIVITY_NAME                                      TGT_VERSION
-------------------------------------------------- -----------
master_install.ucf                                 V8.2

The code above shows the contents of the S_INST_UPG_HIST table after the successful installation of Siebel 8.2.