If you are using a TLS-enabled Oracle database, do the following to configure TrueSight Smart Reporting:
- 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
- (Windows)
- Open the <Smart Reporting install directory>\appserver\webapps\ROOT\WEB-INF\lib file.
- Replace the ojdbc5.jar JDBC driver file with the attached ojdbc7_12.1.0.2_patched.jar file.
Create a keystore certificate for the TLS-enabled database host.
- Open the <Smart Reporting install directory>\appserver\webapps\ROOT\WEB-INF\web.xml file.
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>)))
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
BMC Support Resources
Case Management
Log in to Manage Support Cases ›Upgrade Assistance
The BMC Assisted Migration Offering (AMIGO) program is designed to assist customers with the planning of product upgrades to a newer version – “Success through proper planning”.
Explore AMIGO Program ›
Was this page helpful? Yes No
Submitting...
Thank you