ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Clarity connectivity with TCPS(SSL) enabled Oracle server
Article ID: 130284
Clarity PPM On PremiseClarity PPM SaaS
Steps to enable TCPS(SSL) connectivity from Clarity to Oracle RDBMS server.
Clarity 15.5,15.5.1, 15.6, 15.7
Make sure that Client Authentication is turned off on the listener. If it's turned on, you need to perform additional steps of importing the client certificate into the Server truststore to establish connectivity. The following steps are assuming the SSL Client Authentication is turned off.
Import the Oracle server certificates (including the root certs) to a keystore file of format PKCS12. Following is an example to do that. keytool -importcert -file server_cert.cer -keystore oracle_store.p12 -storetype PKCS12 -alias servercrt -storepass password
Once you have imported all the certificates to a PKCS12 keystore, copy the keystore to a location on the Clarity server where the user running Clarity has access.
Open up NSA and navigate to the "Database" tab.
Ensure that "Specify URL" is checked.
Add the following Parameter to the URL to make it TCPS(SSL) compatible.