Installing TrueSight Smart Reporting with Oracle

Where you are in the Installation process

1Complete the planning activities.
2Prepare for TrueSight Smart Reporting installation.

Install TrueSight Smart Reporting . (You are here)


Install the TrueSight Operations Management Report Engine.


Complete the post-installation activity.

To install TrueSight Smart Reporting with Oracle

Do the following:

  1. Log in to the host computer where you want to install  TrueSight Smart Reporting .

  2. On the host computer, ensure that you have Administrator privileges.

  3. Download the  TrueSight Smart Reporting  files on the host computer.

  4. Ensure that JDK version 1.8 or a later version of 1.8 exists on the host computer, and the JAVA_HOME environment variable is set.

    1. Download and save the JDK executable file on the computer where you want to install TrueSight Smart Reporting.
    2. Run tun the JDK executable file to complete the installation.
    3. Open the Windows explorer, and right-click This PC.
    4. Click Properties > Advanced system settings.
    5. Click the Environment Variables button. 
    6. Under System variables, click New.
    7. In the New System Variable window, add the following details:
      • In the Variable name field, add JAVA_HOME
      • In the Variable value field, browse to the location where the JDK executable file is saved. For example, C:\Program Files\Java\jdk1.8.0_152.
    8. Select the Path variable, and click Edit.
    9. In the Edit environment variable window, click New, and type %JAVA_HOME%\bin.
    10. Click OK to save your changes.

  5. Do one of the following:

    • (Windows) Launch the  TrueSight Smart Reporting   installer from the location where you have downloaded the installation files. The TrueSight Smart Reporting is an executable jar file that you can run by using Java.
    • (Linux) Run the following command:
      "java -jar TrueSight-SmartReporting-11.3.01.jar -gui”

  6. In the Language Selection box, select a language for installation, and click Next.

  7. Read the information on the next page, and click Next.

  8. On the licence agreement page, select I accept the terms of this licence agreement. and click Next.

  9. On the General Options page, do the following:

    1. Enter the web server port number. The default number is 8443.
    2. If you want to install  TrueSight Smart Reporting  as a Windows service, select the Install Windows service check box.
      Installing  TrueSight Smart Reporting  as a Windows service enables it to automatically run when the server starts.
    3. Click Next.

  10. On the Truesight Smart Reporting Database Details page, select Oracle as the database type, and click Next.
  11. On the next page, do the following:

    • Enter the server host name and port number. The default port number is 1521.

    • Select one of the following options:
      • Connect using Oracle SID. If you select this option, in the SID field, enter the Oracle Database instance name.
      • Connect using Oracle Service Name. If you select this option, in the Service field, enter the Oracle service name.
    • Enter the Oracle database user name and password for  TrueSight Smart Reporting .
  12. Click Next. On the Validate Connection details window, click Yes.

  13. You can see the success message. Click OK.

  14. Browse to the path for installation, and click Next.
    If you are installing in a custom directory, manually add the name of the directory to the installation path. For example, if you want to install in the C:\Program Files\TrueSight Smart Reporting directory, browse to C:\Program Files, and add \TrueSight Smart Reporting manually to the installation path. 

  15. On the confirmation message, click OK.

  16. On the next window, you can view the  TrueSight Smart Reporting  installation details. Click Install to complete the installation process.

  17. On Windows, start the TrueSightSmartReporting service and change its startup type to Automatic.


    In non-English locales, the TrueSightSmartReporting service appears as the Yellowfin service.

  18. On Linux, give the execute permissions to the file by using one of the following commands:

    • ./
    • sh

Next step in the Installation process

Now that you have successfully installed Smart Reporting, install Report Engine with Oracle.

Was this page helpful? Yes No Submitting... Thank you


  1. Alfredo Luna

    Hello, In EPD what is dispossed for download is a .zip file with no .jar inside. What I needed to do was change the file extension puting .jar instead of .jar and it worked. Please, that shouldbe corrected or notified at the install doc.

    Jun 07, 2019 02:33
    1. Mukta Kirloskar

      Thank you for the comment, Alfredo. I will talk to the team and update the documentation if required.

      Jun 07, 2019 06:41
      1. Mukta Kirloskar


        This is not an issue any more. The file on the EPD is a .jar file, and the installation starts once you download and run it.

        Thank you.

        Oct 28, 2020 02:36
  2. Alfredo Luna

    Hello: if a too much new version of Java is used in Windows, it wont create Windowes Service. Doc says that JDK v1.8 or later must be used. But I tryed to install Smart Reporting with JDK v12 and it didn´t work. I had to use a 1.8 version.

    Jun 07, 2019 05:44
    1. Mukta Kirloskar

      Thank you for the comment, Alfredo. Let me check with the team and confirm this scenario.

      Jun 07, 2019 06:39
      1. Mukta Kirloskar


        You must use the JDK version 1.8 or a later version of 1.8. We have updated the documentation.

        Thank you.

        Jul 10, 2020 01:25