Oracle Database Discussions

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!

ORA-29024 with utl_http

3678149May 29 2018 — edited Jun 1 2018

Hello.

OS is RedHat Linux 7

DB is 12.2.0.1

I am trying to allow https to a server.

I created a wallet on the db server:

orapki wallet create -wallet myWalletPath -auto_login -pwd thePassword

Oracle PKI Tool : Version 12.2.0.1.0

Operation is successfully completed.

I have taken the certificate from the http server using my browser.

The format is PKCS n°7

I sent the certificate to the db server and added it to the wallet:

orapki wallet add -wallet myWalletPath -trusted_cert -cert dCertificate.p7b -pwd thePassword

Oracle PKI Tool : Version 12.2.0.1.0

Operation is successfully completed.

I created an ACL (/....myACL.xml), assigned the host to the ACL and assigned the ACL to the wallet.

I also assigned connect, resolve, use-client-certificates, use-passwords to the dbuser.

When I run select utl_http.request ('https://theURL',null,'file:myWalletPath','thePassword') from dual

I have ORA-29024 Certificate validation failure

What did I miss?

This post has been answered by 3678149 on Jun 1 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2018

Added on May 29 2018

#general-database-discussions

3 comments

1,741 views