Steps to add Oracle Certificate in TDM and FDM CACERTS for TCPS Connection

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Steps to add Oracle Certificate in TDM portal and FDM CACERTS

Environment

TDM 4.11.2003 and above

Resolution

Step 1 : Go to the Java installation directory :

TDM- C:\Program Files\CA\CA Test Data Manager Portal\jre\lib\security\

FDM - C:\Program Files\Grid-Tools\FastDataMasker\jre\lib\security\

Step 2 : You will find the cacerts file in the security folder , open command prompt in the above directory and execute the below command to add the certificate to the truststore

>> keytool -import -noprompt -trustcacerts -alias orakey -file <certificate_location> -keystore cacerts

sample command: keytool -import -noprompt -trustcacerts -alias orakey -file C:\test_certificate\oracle-certificate.cert -keystore cacerts

Step 3 : Enter the following password when prompted after executing the command in step 2 : "changeit"

Step 4 : There will be a message on the console that the certificate was added successfully

 

Note: please make a copy of the original cacerts file in case it gets corrupted. 

 

On the Oracle Connection Profile you want the secured connection, after doing the above make sure you set the Advanced Authentication to true and save the profile.

Additional Information

** We assume you have configured the Oracle listener to accept TCPS Connections as per the KB: 

Oracle listener to accept TCPS connections

To configure Oracle wallet and configure TCPS on Oracle listener : Oracle wallet and configure TCPS on Oracle listener