Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-29024: Certificate validation failure error on DB ver 12.1.0.2

Aizat Akmal RamliMar 29 2023 — edited Mar 29 2023

Hi

I'm having an issue accessing HTTPS webservices through PL/SQL. While importing the TLS certificates i have executed these command

  1. cd $ORACLE_HOME/appsutil/wallet

  2. orapki wallet create -wallet . -auto_login -pwd <password>

  3. Upload the .crt file onto the server

  4. orapki wallet add -wallet . -trusted_cert -cert test.crt -pwd <password>

  5. orapki wallet display -wallet.

  6. Whitelist proxy

  7. Create the ACL by these APIs:

     DBMS\_NETWORK\_ACL\_ADMIN.CREATE\_ACL  
 DBMS\_NETWORK\_ACL\_ADMIN.ADD\_PRIVILEGE  
 DBMS\_NETWORK\_ACL\_ADMIN.ASSIGN\_ACL

But yet i'm still encountered ORA-29024: Certificate validation failure error. This led me to believe that the certificates imported are invalid. I've downloaded the certs via the browser export function in Base 64 encoded X.509 format. In the .crt file there are chains of certificates and as understood from the Oracle support, 12.1.0.2 only requires Root and Intermediate certs. How may i know the certs that i have downloaded are the valid TLS Root and Intermediate certs?

Your feedback is highly appreciated

Comments

Post Details

Added on Mar 29 2023
2 comments
245 views