Securing Database Communication in CA UIM 9.0.2 with TLS v1.2 (Oracle)

by February 6, 2019

CA Unified Infrastructure Management 9.0.2, a leading infrastructure management monitoring solution, provides enhanced security by supporting Transport Layer Security (TLS) v1.2. In a past article, we shared how this works with Microsoft SQL Server. This article will focus on how you can support TLS v1.2 with Oracle, without compromising on the product performance.

At a high level, enabling TLS v1.2 support in CA UIM 9.0.2 is a two-step process:

  • Perform configurations on the Oracle database server.
  • Enable the TLS option and provide relevant details during installation of the UIM Server.

Supporting TLS v1.2 on Oracle

The following diagram shows the steps that are required to enable TLS v1.2 when the UIM database is Oracle 11g or 12c:

Configurations on the Database Server—Oracle

Perform the following tasks on the database server—Oracle:

Verify the FQDN System Requirement.Verify that your full computer name is FQDN (for example, VI02-E74.ca.com). If not, add the domain name (for example, ca.com) to the computer name.

Verify and Apply Patches for Oracle. For Oracle 11.2, which does not support TLS v1.2 by default, download and install the 11.2.0.4.2 DBPSU patch and p25874796_112040_MSWIN-x86-64 from Oracle Support.

Disable Previous Certificates. Change the registry keys to disable all the previous versions of certificates on the database server.

Perform Wallet Configuration for the Server: Use the Oracle Wallet Manager user interface or the orapki utility (command line) to perform the wallet configuration for the server, which includes the following tasks:

  1. Create a server wallet.
  2. Enable auto-login to true.
  3. Create a certificate request.
  4. Export the certificate request into a file and send it to Certification Authority (CA).
  5. Get the certificate from CA.
  6. Import the user certificate into the server wallet.

Perform Wallet Configuration for the Client. Use the Oracle Wallet Manager user interface or the orapki utility (command line) to perform wallet configuration for the client. Follow the same steps that you followed for the server wallet.

Set the TLS Configuration on the Database Server.Use Oracle Net Manager to set the TLS configuration details. This configuration includes the following tasks:

  1. Enter the location of the server wallet.
  2. Specify that the configuration is for the server.
  3. Set the TLS version for the server.
  4. Add listener for TLS.

Configurations on the UIM Server Computer

Perform the following tasks on the computer where you plan to install the UIM Server:

  1. Verify that Oracle Instant Client (version 12.1.0.2.0) is available on the computer where you want to install the UIM Server.
  2. Copy the client wallet folder from the database server to the computer where you plan to install the UIM Server.
  3. Provide the required client wallet location, wallet password, wallet type, and whether client authentication is needed when you install the UIM Server. The UIM Server installer copies the required wallet files from the provided location and places them in the <Nimsoft>\security folder.

After you complete the UIM Server installation, ensure that the following entries are present in the sqlnet.ora file that is available in the <Nimsoft>\security folder:

More Information

For detailed information about considerations, how to perform various tasks outlined in this article, or to view the list of enhanced probes, see the related DocOps article: Support for TLS v1.2 (Oracle).