How to add an Oracle database over a secured connection in ALM 12.21 Patch 04 and later

  • KM02722194
  • 07-Feb-2017
  • 07-Feb-2017

Summary

The article provides with the steps to add an Oracle database over a secured connection in ALM 12.21 Patch 04 and later.

Question

Starting in ALM 12.21 Patch 4, you can install ALM and create projects on Oracle and MS SQL databases configured with TLS 1.2.

After creating Site Administration schema on an MS SQL database using TLS 1.2, an error occurs when adding an Oracle database over TLS 1.2 using the Oracle Wallet certificate.

Answer

Oracle uses a “wallet” as an authentication key (.p12 certificate) while ALM works with the .jks formatted certificate.
Convert the .p12 formatted certificate to .jks.
 
If you cannot convert directly from .p12 to .jks, import the wallet file to your Windows certification store, export the certificate, and then convert it to .jks.
 
To convert from .p12 to .JKS:
 

  1. In the Certificate Import Wizard, under Import options, select Mark this key as exportable.
    • image text
  2. Open the Windows certification store and export all keys from the wallet file:
  •  image text
     3.   Use the CMD prompt and the keytool.exe (included in Java JRE) to import both certificates to .jks file:
  1.  keytool -importkeystore -scrkeystore {filepath\Client.pfx} -srcstoretype PKCS12 -srcstorepass {password} -destkeystore {filepath\keystore.jks}
  2. keytool -importcert -file {filepath\Serv.cer} -keystore {filepath\keystore.jks}