"FATAL: Connection Requires A Valid Client Certificate" Error When Testing a PostgreSQL Data Server with SSL Certificate
(Doc ID 2622849.1)
Last updated on MARCH 22, 2023
Applies to:Oracle Data Integrator - Version 188.8.131.52.6 and later
Oracle Data Integrator on Marketplace - Version 184.108.40.206.200123 and later
Information in this document applies to any platform.
When attempting to test an Oracle Data Integrator (ODI) connection to a PostgreSQL data server over SSL, the following error occurs. This is happening when testing with both Local (No Agent) and a remote agent. Customer is able to connect from command line in server but not from ODI Studio which is causing this issue.
Customer created a PostgreSQL data server and in the tab JDBC, in the Properties section, he added keys to define the certificates like in the following image:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!