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.

Wallet setup for utl_http https call

Pavel_pFeb 4 2018 — edited Feb 19 2018

Hello,

please, can anybody describe how to properly import site's certificate into a wallet? The following query

select utl_http.request('https://community.oracle.com', null, 'file:/u01/app/oracle/product/12.2/db_1/owm/wallets/oracle', 'MyWalletPwd') from dual;

produces this output

SQL11.sql: Error (8,8): ORA-29024: Certificate validation failure

ORA-06512: at "SYS.UTL_HTTP", line 1501

ORA-06512: at "SYS.UTL_HTTP", line 380

ORA-06512: at "SYS.UTL_HTTP", line 1441

ORA-06512: at line 1

My wallet looks like this

DB version (prebuilt database development VM) is

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

PL/SQL Release 12.2.0.1.0 - Production

CORE 12.2.0.1.0 Production

TNS for Linux: Version 12.2.0.1.0 - Production

NLSRTL Version 12.2.0.1.0 - Production

I've tried to export site's certificate to all possible formats (with or without chain) and still getting the same error.

Any help would be highly appreciated.

Regards,

Pavel

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 18 2018

Added on Feb 4 2018

11 comments

3,229 views