How to configure the Oracle DB agent to communicate with mTLS ?

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

How to configure the Oracle DB agent to communicate with mTLS ? 

We have a requirement to switch Oracle DB communication through mTLS.

Environment

AE 24.4.2

Resolution

Refer below link for the functionality of the used JDBC driver: 

https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/connect-jdbc-thin-wallet.html#GUID-BE543CFD-6FB4-4C5B-A2EA-9638EC30900D

If everything is configured correctly within the oracle environment as per the above document, this must work as the jdbc connection string is the same and therefore transparent for the agent

Check the below guide for one-way TLS that includes a link to the Oracle documentation where there are examples also for mTLS via jdbc:

https://academy.broadcom.com/automation/automic-automation/securing-connections-between-automic-automation-and-oracle-databases

This setting has to be configured only within the JDBC connection string , configuration through CONN object will not work.