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.

Oracle 12c ORA-28860: Fatal SSL error

Kevin van DijkMay 31 2016 — edited Jun 7 2016

Hello,

I have a problem with calling a webservice over SSL.

The database version is 12.1.0.2.0.

I want to call the following url: https://postcode-api.apiwise.nl but I get the error ORA-28860: Fatal SSL error.

I did the following:

1) Create a oracle wallet

orapki wallet create -wallet /u01/app/oracle/wallets/ssl-wallet -pwd password

2) Export the certificates with my browser( Export -> save as Base64 encoded X.509)

3) Add the certificates to my wallet. Only the CA Certificates (COMODO RSA Domain Validation Secure Server CA, COMODO Secure)

orapki wallet add -wallet /u01/app/oracle/wallets/ssl-wallet/ -trusted_cert -cert /u01/app/oracle/wallets/ssl-wallet/comodo_rsa_domain_validation.cer

orapki wallet add -wallet /u01/app/oracle/wallets/ssl-wallet/ -trusted_cert -cert /u01/app/oracle/wallets/ssl-wallet/comodo_rsa_secure.cer

4) The certificates have been succesfully added to my Wallet.

5) I have created the necessary ACL

6)  Then I test it, but it gives me the error.

In order to simplify the problem, I run the following statemetn with SQL Developer

SELECT utl_http.request('https://postcode-api.apiwise.nl',null,'file:/u01/app/oracle/wallets/ssl-wallet/','password') from dual;

But then I get this error:

ORA-29273: HTTP request failed

ORA-28860: Fatal SSL error

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

ORA-06512: at line 1

29273. 00000 -  "HTTP request failed"

*Cause:    The UTL_HTTP package failed to execute the HTTP request.

*Action:   Use get_detailed_sqlerrm to check the detailed error message.

           Fix the error and retry the HTTP request.

Does anyone know how to fix this problem?

Kind regards,

Kevin
This post has been answered by Kevin van Dijk on Jun 7 2016
Jump to Answer

Comments

843834
i know the beta won't work with dtds. Is this feature
gone for good from jaxb or just the beta? I read the
FAQ http://java.sun.com/xml/jaxb/faq.html. and it
seems like it says dtd is gone, but doesn't come out
and clearly say so.
Hi,
The dtd feature support is no longer there in JAXB. The beta release does not support dtds and also the FCS will not be supporting it.

Thanks,
Bhakti Mehta
Sun Microsystems Inc.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 5 2016
Added on May 31 2016
18 comments
34,927 views