Oracle source endpoint connection working with TCP (port:1521) but not working with TCPS (port: 2484)

[SaidSayyad]

Hello Team,

We are using using Oracle RAC as source system, while connecting to source connection is working fine with TCP port:1521 and connection is not working with TCPS port : 2484.

Error: ORA-29024: Certificate validation failure

Logfile error:

2023-09-29T10:23:09:916589 [SERVER ]V: Oracle error code is '29024' (oracle_endpoint_conn.c:811)

02256045: 2023-09-29T10:23:09:916620 [SERVER ]T: ORA-29024: Certificate validation failure [1022307] (oracle_endpoint_conn.c:811)

02256045: 2023-09-29T10:23:09:916668 [SERVER ]T: Free component test_database (oracle_endpoint.c:51)

02256045: 2023-09-29T10:23:09:916620 [SERVER ]E: ORA-29024: Certificate validation failure [1022307] (oracle_endpoint_conn.c:811)

Thanks,

Said Sayyad

[john_wang]

Hello @SaidSayyad ,

Thanks for reaching out to Qlik Community!

The certificate sent by the other side could not be validated. This may occur if the certificate has expired, has been revoked, or is invalid for another reason.

please refer the below link with respect to above error:

ORA-29024: Certificate validation failure tips
It's better to work with the Oracle DBA to troubleshoot the issue by using SQLPlus.

Hope this helps,

John.