Configuring TrueSight Smart Reporting repository database with TLS-enabled Oracle database

If you are using a TLS-enabled Oracle database, do the following to configure TrueSight Smart Reporting:

1. Navigate to the <install_dir>/appserver/bin/ folder and run one of the following commands to stop the TrueSightSmartReporting service:
   • (Windows)shutdown.bat
   • (Linux)./shutdown.sh
2. Open the <Smart Reporting install directory>\appserver\webapps\ROOT\WEB-INF\lib file.
3. Replace the ojdbc5.jar JDBC driver file  with the attached ojdbc7_12.1.0.2_patched.jar file.

4. Create a keystore certificate for the TLS-enabled database host.
   
   

   Do the following:

   1. Download the keystore certificate of the TLS-enabled database host.
   2. Save the certificate in the <Smart Reporting>\appserver\conf directory.
   3. Open the command prompt, and navigate to the <Smart Reporting>\appserver\conf.
   4. Run the following command:
      “keytool -importcert -file <certificate file name>.crt -keystore tsr.keystore -alias "newtsrkey"”
   5. Enter the defaut password when prompted, and enter y when asked Trust this certificate.
      The default password is changeit.
5. Open the <Smart Reporting install directory>\appserver\webapps\ROOT\WEB-INF\web.xml file.

6. Change the value of the JDBCUrl parameter to the following:

   jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCPS)(HOST = <Fully Qualified Domain name of the TLS Enabled Database Host>)(PORT = <Port Number of the TLS Enabled Database(Default:2484)>)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = <Service Name of the TLS Enabled Database on which user has been created>)))
7. Navigate to the <install_dir>/appserver/bin/ folder and run one of the following commands to stop the TrueSightSmartReporting service:
   • (Windows) startup.bat
   • (Linux) ./startup.sh