Error: Unable to Validate Certificate

Issue

The connector fails. The following error appears:

Unable to validate certificate. dbCertificateValidation2: java.sql.SQLRecoverableException: 10 Error: Undefined Error

Environment

• Connector: Oracle
• Connection method: Direct

Resolution

To resolve this issue, ensure the following:

1. TLS is enabled on your database.
2. The required TLS certificates are correctly installed and configured.
3. Your database is configured to accept TLS connections.
4. You have created a database user for Fivetran's exclusive use and granted the user read-only access to the data you want to sync. For more information, see steps 2 and 3 of our Oracle setup guide.

Cause

To connect directly to Fivetran, you must have TLS enabled on your Oracle database. This issue occurs when TLS is not enabled or configured correctly in your database.