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 - Platform:
- 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
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Log in or register to comment.