Installing and configuring the Reporting database

The TrueSight Operations Management Reporting database acts as a central repository for all the event, impact, and performance data for one or multiple Report Engines. The Reporting database can be either Oracle or SQL Server.

To install the Oracle database

Do the following:

  1. Install the Oracle database. For more details, see the Oracle manuals on the Oracle web site (https://www.oracle.com/index.html).

  2. Create the Oracle database instance. For more details, see the Oracle manuals on the Oracle web site(https://www.oracle.com/index.html).

    Note

    While creating the Oracle database instance, specify the following character sets: 

    • Database Character Set - AL32UTF8
    • National Character Set - UTF8
    • National Character Set for Oracle 12c - AL16UTF16
  3. Create table spaces and user for the Report Engine.See Creating-tablespaces-and-user-on-the-Oracle-database-for-Report-Engine for instructions.
  4. (Optional) If you are installing TrueSight Smart Reporting, create table spaces and user for TrueSight Smart Reporting.See Creating-tablespaces-and-user-on-Oracle-database-for-TrueSight-Smart-Reporting for instructions.

Note: Avoid an error when the Oracle server and client are installed on the same computer

An error might occur when the Oracle server is installed on the same computer with Oracle client because of incorrect sequence of the Oracle path in the PATH variable. To avoid this issue, set the client entry before the Oracle server entry in the path variable. For example:

PATH : D:\oracle\product\11.2.0\client_1\bin;D:\oracle\product\11.2.0\db_1\bin;

To install the SQL Server database

Do the following:

  1. Install the SQL Server database. For more details, see the SQL Server manuals on the Microsoft site (https://www.microsoft.com/en-in/).

  2. Create the SQL Server database and user.

    Note

    Select the appropriate collation character set according to your server locale.

    See Creating-database-filegroup-and-user-on-SQL-Server-for-Report-Engine for instructions. If you are installing TrueSight Smart Reporting, you can create an SQL Server database user while installing TrueSight Smart Reporting.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*