Steps to add Oracle wallet and configure TCPS on Oracle listener

Products

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

Issue/Introduction

Steps to add Oracle wallet and configure TCPS on Oracle listener  to be used in TDM and FDM

Environment

TDM 4.11.2003 and above

Resolution

Step 1 : Browse to the directory where you want to generate the wallet files

Example : C:\Oracle_Wallet

Step 2 : Open command prompt in the above directory and type the below command to create a new wallet

orapki wallet create -wallet . -pwd <password> -auto_login

sample command -> orapki wallet create -wallet . -pwd oracle123 -auto_login

After executing the above command the below 4 files will be generated in the current directory :

-> cwallet.sso
-> cwallet.sso.lck
-> ewallet.p12
-> ewallet.p12.lck

Step 3 : Create a self signed certificate in the wallet by executing the below command

orapki wallet add -wallet . -pwd <password> -dn CN=<server-hostname> -keysize 2048 -self_signed -validity <validity-in-days>

sample command -> orapki wallet add -wallet . -pwd oracle123 -dn CN=Hostname/IPaddress -keysize 2048 -self_signed -validity 3650

This will generate a self signed certificate which is valid for 10 years

Step 4 : Now we will export the self signed certificate to a .cert file so we can add it later to the java cacerts file , type the below command

orapki wallet export -wallet . -dn CN=<server-hostname> -cert ./<certificate-file-name>.cert

sample command -> orapki wallet export -wallet . -dn CN=Hostname/IPaddress -cert ./oracle-certificate.cert

Step 5 : Place these generated files in the oracle home directory , look for the environment variable called "TNS_ADMIN" and place the generated files in the corresponding path

sample value for the environment variable TNS_ADMIN -> "C:\dbfree\dbhomeFree\network\admin\"

Here "C:\dbfree\dbhomeFree\" is the oracle home directory and corresponds to the environment variable "ORACLE_HOME"

Go to the path "C:\dbfree\dbhomeFree\network\admin\"

Now copy the oracle wallet files generated in step 4 to this directory

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 Certificate in TDM and FDM CACERTS please follow the KB : Oracle Certificate in TDM and FDM CACERTS