Home » SQL & PL/SQL » SQL & PL/SQL » Fatal SSL error calling secure web service from 11g (Oracle 11.2 on Windows.)
Fatal SSL error calling secure web service from 11g [message #597987] Wed, 09 October 2013 10:26 Go to next message
chris_a
Messages: 2
Registered: October 2013
Junior Member
Hi,

Any help with this would be very much appreciated as I'm struggling to see the issue.

I have successfully created a wallet and called a secure web service in Oracle 10.2.0.2. The situation is a little more complex as I am using a self signed server certificate with private key issued by the publisher of the secure service. I imported the server certificate into the wallet using orapki (jks_to_p12) and then imported other certificates from the certification path. All of this works fine in 10g on UNIX.

I am now trying to use this in 11g on Windows so I have extracted the wallet which works in 10g and placed it in a suitable location on the windows server. I am able to query other https sites from 11g but not the one that requires the self signed server certificate.

The error I get when trying to call the secure site is.

ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-28860: Fatal SSL error
ORA-06512: at line 1

I have confirmed that the number of bytes in the wallet on the unix box matches the number of bytes on the windows box.

Any ideas?

Thanks,
C
Re: Fatal SSL error calling secure web service from 11g [message #609813 is a reply to message #597987] Wed, 12 March 2014 10:54 Go to previous messageGo to next message
gusmenp
Messages: 6
Registered: June 2013
Location: Caracas
Junior Member
Hi Chris,

I'm very sorry not answer your question on my topic at time. I post the solution for my problem for everybody that need it. Check it and i hope you've found the solution for this.

Regards,

Gusmen.
Re: Fatal SSL error calling secure web service from 11g [message #609815 is a reply to message #609813] Wed, 12 March 2014 12:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I post the solution for my problem for everybody that need it. Check it


Where?

Re: Fatal SSL error calling secure web service from 11g [message #609816 is a reply to message #609815] Wed, 12 March 2014 12:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Ah! Found it there
Note that in your answer you talked about a bug in 11.1 that is fixed in 11.2 and OP is using 11.2, so it does not seem it is the same issue.



Re: Fatal SSL error calling secure web service from 11g [message #609877 is a reply to message #609815] Thu, 13 March 2014 10:23 Go to previous messageGo to next message
gusmenp
Messages: 6
Registered: June 2013
Location: Caracas
Junior Member
Michel Cadot wrote on Wed, 12 March 2014 12:45

Quote:
I post the solution for my problem for everybody that need it. Check it


Where?



In my topic, like i said.
Re: Fatal SSL error calling secure web service from 11g [message #609878 is a reply to message #609816] Thu, 13 March 2014 10:30 Go to previous message
gusmenp
Messages: 6
Registered: June 2013
Location: Caracas
Junior Member
Michel Cadot wrote on Wed, 12 March 2014 12:47

Ah! Found it there
Note that in your answer you talked about a bug in 11.1 that is fixed in 11.2 and OP is using 11.2, so it does not seem it is the same issue.





Yes, but he asked in my topic, so I thought it appropriate say that I found the solution to my problem, just in case

Regards.

Gusmen.
Previous Topic: Retrieve All Columns With Specific Value
Next Topic: Execute Immediate with DDL and Nested table
Goto Forum:
  


Current Time: Thu Mar 28 07:21:19 CDT 2024