oracle ORA-29024: 证书验证失败

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/16079738/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-19 01:35:17  来源:igfitidea点击:

ORA-29024: Certificate validation failure

sqloraclesslhttpsoracle11g

提问by eric.itzhak

I've followed the following tutorials : Create wallet,Create ACL

我遵循了以下教程: 创建钱包创建 ACL

And I am still getting ORA-29024: Certificate validation failureerror.

我仍然收到ORA-29024: Certificate validation failure错误。

I'm trying this query :

我正在尝试这个查询:

    UTL_HTTP.set_wallet('file:/home/oracle/wallet', 'password');
  l_http_request  := UTL_HTTP.begin_request('https://somedomain.co.il');
  l_http_response := UTL_HTTP.get_response(l_http_request);

Now i've added to the ACL : *.somedomain.co.il,somedomain.co.il

现在我已经添加到 ACL 中:*.somedomain.co.il,somedomain.co.il

And I've downloaded the certificate as DER encoded, as I've read somewhere that this is the one needed and didn't get any errors in the proccess of generating the wallet.

我已经下载了 DER 编码的证书,因为我在某处读到这是需要的,并且在生成钱包的过程中没有出现任何错误。

Any thoughts?

有什么想法吗?

I'm using Oracle 11g

我正在使用 Oracle 11g

回答by eric.itzhak

In the end my problem was when I exported the certificate i choose DER, in my case i should have used PCKS # 7, but this won't most likley work in all cases i guess it depends on the key.

最后,我的问题是当我导出证书时,我选择了 DER,在我的情况下,我应该使用 PCKS # 7,但这不会在所有情况下都有效,我猜这取决于密钥。

So i guess if you landed here try and play with your certificate files (be sure to remove and re-add) And very important, change sessions between tries to know if it worked or not because otherwise it'll keep giving you the error all though it should work.

所以我想如果你来到这里尝试使用你的证书文件(一定要删除并重新添加)而且非常重要的是,在尝试之间更改会话以了解它是否有效,否则它会一直给你所有的错误虽然它应该工作。