Step 2: Installing and configuring Reporting database

Before the BMC TrueSight Operations Management Report Engine is installed, you must install and configure Oracle or SQL Server database so that it can be used as the Reporting database. Perform the following tasks according to the database you want to use:

• Oracle
  1. Install the Oracle Database. For more details, see the Oracle manuals at the Oracle site.

  2. Create the Oracle Database instance. For more details, see the Oracle manuals at the Oracle site.

     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 as described in Creating-tablespaces-and-user-on-Oracle-database. 
• SQL Server
  1. Install the SQL Server Database. For more details, see the SQL Server manuals at the Microsoft site.

  2. Create SQL Server database and user as described in Creating-database-and-user-on-SQL-Server.

     Note

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