Installing TrueSight Operations Management Report Engine with Oracle database


 This section provides installation information for BMC TrueSight Operations Management Report Engine, with Oracle as the Reporting database. You must install the Report Engine on a computer different from the one on which SAP BusinessObjects Enterprise is installed.

This topic includes information for:

Before you begin

Before installing the Report Engine, ensure that:

  • You are logged in as an administrator (Windows) or a root user (Linux) on the host on which you are installing.
  • You have installed BMC TrueSight Infrastructure Management Server and the Oracle database on different computers.
  • You have access to the installation files.
  • You have created tablespaces and a user for the Oracle database.
  • If you are installing more than one Report Engine, ensure that you install the Report Engines one after another instead of installing them simultaneously.
  • By default, the Report Engine is installed with AES 256-bit encryption key size. If you want to set this to 128-bit encryption key size, set the following environment variable before installing the Report Engine to:
    AES_ENCRYPTION_KEY_SIZE=128


To install BMC TrueSight Operations Management Report Engine on the first computer

  1. Navigate to the Reports/ReportEngine/platform folder, where the platform is Linux or Windows.

    Note

    If there is not enough space in the temporary directory, the system prompts you to select an alternate directory. On UNIX-based computers, you can set the IATEMPDIR environment variable to an alternate directory which has enough space.

    • For Windows, double-click ReportEngine10.7.00_buildnumber.exe.
    • For Linux, at the command line, run the following command: ReportEngine10.7.00_b buildnumber .bin

      Note

      For Linux installations, the installation file supports only the graphical user interface (GUI) mode. There is no support for the console or silent mode installation methods.

  2. In the Welcome page, click Next.
  3. In the License Agreement page, click I agree to the terms of the license agreement.
  4. IIn the Feature Selection page, select the appropriate features that you want to install.
    Selecting the BMC TrueSight Operations Management Report Engine Installation check box selects both the Install BMC TrueSight Operations Management Report Engine 10.7.00 and Import universe and reports 10.7.00 check boxes.

    Note

    When you select the Import universe and reports check box, it imports the BMC TrueSight Operations Management Reporting universe and reports into the SAP BusinessObjects Enterprise automatically. It eliminates the manual process of importing them into SAP BusinessObjects Enterprise. If you are installing BMC TrueSight Operations Management Report Engine for the first time, BMC recommends you to import the universe and reports automatically.

  5. In the Database Selection page, select Oracle Standard Edition or Oracle Enterprise Edition and provide the necessary information using the values that you populated in the Planning sheet for installation and configuration, and click Next.

    Note

    If you have Oracle Enterprise Edition without partitioning, select the Oracle Standard Edition option and provide Enterprise Edition database details. 

  6. In the BMC TrueSight Operations Management Report Engine Database page, enter the following information:

    • Fully-Qualified Database Host Name: Oracle database host
    • Port: Oracle Server instance port number (by default, the port number is 1521)
    • Database SID or Service Name: Oracle database SID or service name. 
    • Database Login: the login name for the Oracle database you created.
    • Database Password: password for the Oracle database you created.
    • Confirm Database Password: password for the Oracle database you created. 

    Note

    If you are using an Oracle RAC system and plan to use a JDBC connection URL, enter the following information:

    • Fully qualified database host name of any one of nodes in the Oracle RAC
    • Corresponding database instance name of the node
    • Listener port for the database
    • Database user credentials

    If you are using Oracle RAC and have a SCAN IP address, enter the SCAN IP address in the Fully-Qualified Database Host Name field

    After the Report Engine installation is complete, follow the post-installation configuration steps for Oracle Real Application Cluster (RAC) systems.

  7. Click Next.
  8. In the Time Zone Selection page, select an appropriate time zone, and click Next.
  9. In the Directory Selection page, accept the default directory or select a different directory to install BMC TrueSight Operations Management Report Engine, and click Next.
  10. In the BMC Truesight Infrastructure Management Server Details page, enter the following information:
    • Details for Host Name: Enter the BMC TrueSight Infrastructure Management Server name
    • Protocol: Select the network protocol that the TSIM uses (default protocol: HTTP)
    • HTTP/S Port: TSIM port  (default port: 443)
    • Username: BMC TrueSight Infrastructure Management Server user name
    • Password: BMC TrueSight Infrastructure Management Server password
  11. In the BMC TrueSight Infrastructure Management Server Registration page:
    • If the BMC TrueSight Infrastructure Management Server is connected to an Oracle database, review all of the data that was automatically entered and make any necessary changes. Then, enter the password for the database user.
    • If the BMC TrueSight Infrastructure Management Server is connected to a Sybase database, review all of the data that was automatically entered and make any necessary changes. The database user password is the default password. You can enter a new password if it is different than the default.
    • If you are working with a TrueSight Infrastructure Management Server that is earlier than version 10.7, the Registration page fields must be completed.

      Click here for instructions to complete the Registeration page fields......
      • BMC TrueSight Infrastructure Management Server name: Enter the name of the BMC TrueSight Infrastructure Management Server.
      • BMC TrueSight Infrastructure Management Server cell name: Enter the name of the BMC TrueSight Infrastructure Management Server cell.

        Note

        Provide the cell name of the same BMC TrueSight Infrastructure Management Server which you want to register.

      • Select the BMC TrueSight Infrastructure Management Server database type:
        • Sybase
        • Oracle
        • Oracle RAC
      • Fully qualified BMC TrueSight Infrastructure Management Server database host name: Enter a fully-qualified database host name.
      • BMC TrueSight Infrastructure Management database port: Enter a database port. The default Sybase port number is 2638.
      • Database login: Enter the BMC TrueSight Infrastructure Management database user name. The default Sybase username is dba.
      • Database password: Enter the password for the BMC TrueSight Infrastructure Management database user.


      Note

      By default, the Enable Event and Impact reporting option is selected. This means that the report engine installation automatically registers event gateway and cell information with the BMC TrueSight Infrastructure Management server. If this option is not selected, the event gateway and cell information is not automatically registered.

  12. In the BusinessObjects Information page, provide the necessary information using the values that you entered in thePlanning sheet for installation and configuration, and click Next.

    Note

    If you deselect the Import Universe and Reports checkbox on the Feature Selection page, the BusinessObjects Information page is not displayed. Post-installation, you can import the TrueSight_DataMart.lcmbiar universe file manually using the steps described in Manually-importing-the-BMC-TrueSight-Operations-Management-universe-and-reports-into-supported-SAP-BusinessObjects.

  13. In the Installation Preview page, click Install

    Note

    If you have BMC Impact Manager version earlier than 9.5.00, ensure to add the following entries in the gateway.reportengine file located in the  BMCProactiveNetServerInstallDir\pw\server\etc directory and restart BMC Impact Manager before proceeding with the installation:

    add.new=[cell_name=$CNAME]
    add.mod=[cell_name=$CNAME]


    The installer begins the installation process. 

  14. Click Done.
  15. Apply the Hotfix_1070000010 hotfix.This is a mandatory hotfix, which resolves the issue where information about daylight saving information for the period after 31 December 2019 is not present in the Report Engine database.

    For more information, see Adding-daylight-saving-information-in-the-Reporting-database.


Note

If the Enable Event and Impact reporting option was not selected during the Report Engine installation, you must configure the BMC TrueSight Infrastructure Management cells for event and impact reporting by configuring BMC TrueSight Infrastructure Management cells.

To install BMC TrueSight Operations Management Report Engine on the second or subsequent computers

Note

You do not have to create a tablespace and a database user for the second or subsequent computers because, the other instances of Report Engine use the same database user.

  1. To install the Report Engine, run the file located in the \Reports\ReportEngine folder, relevant to the operating system.
    • (Windows) Run the ReportEngine10.7.00_buildNumber.exe file
    • (Linux) Run the  ReportEngine10.7.00_buildNumber.bin command
  2. Follow the instructions on the wizard pages. You need to enter the following information:
    • Installing the Report Engine and importing the latest universe and reports.
    • Database connection information such as the database computer name, default port number 1521, and account details of the user that you created at Creating table spaces and user.

      Note

      The Time Zone selection page is not displayed when you install the second (or multiple instances of) Report Engine.

    • Directory in which you want to install the product.
    • TrueSight Infrastructure Management Server registration details. You can register the current version of TrueSight Infrastructure Management Server.
    • Details of the server in which BMC Reporting Foundation is installed, and the SAP BusinessObjects user who has administrator rights (if you select the Import universe and reports 10.7.00 check box)
  3. In the Installation Preview page, click  Install.  The installer begins the installation process.

 

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