Oracle Database connection over TLS fails in Aria Orchestrator Workflow

Products

• VCF Automation
• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

• In Aria Orchestrator, a workflow which is adding a connection for an Oracle Database is failing with the following error:
  

  • item: '##########/item#', state: 'failed', business state: 'null', exception: 'com.vmware.o11n.plugin.database.DatabaseException: java.sql.SQLRecoverableException: ORA-17002: I/O error: IO Error PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target, connect lapse 5 ms., Authentication lapse 0 ms."

Environment

• Aria Orchestrator 8.18
• Aria Automation 8.18

Cause

• Certificate details do not match or no longer match the provided Certificate Information.

Resolution

• Ensure that all details of the provided SSL Certificate are correct such as the Common Name (CN) and Subject Alternative Name (SAN) are correct.

 

• If any changes occur in any of these details such as a change of Common Name (CN), i.e.: the Fully Qualified Domain Name (FQDN) of the server then a new certificate is required to be generated.