Fatal SSL error utl_http.request

[Huy Nguyen]

Hi everyont

This write is very helpful for me to understand detail about error of get SSL.
http://ermanarslan.blogspot.com/2019/01/rdbms-analyzing-https-ssl-errors-ora.html

But now I use oracle 12.2, it fix bugs of 11.2. When I select utl_http.request from sni.cloudflaressl.com, it shows me fatal SSL error. As before, I called some API web services successfully. Can you help me to solve that? Thank you for your time.

[ErmanArslansOracleBlog]

Hi,

Please send me the error.. The full message..

Thanks.

[Huy Nguyen]

You quickly reply to me. Thank you for that. I give you the full error message when I select.


I use the code below if you need
select utl_http.request(url => ,wallet_path =>
         directory,wallet_password => ,https_host =>
         'sni.cloudflaressl.com') from dual;


When I used that query on some web, it was fine.

[ErmanArslansOracleBlog]

It seems you are hitting the Internal Bug 26040483.
Apply patch 26040483 and retry.

[Huy Nguyen]

Thank you. I will try your method and quickly respond to u

[Huy Nguyen]

I use Oracle server on Windows. Now I found the patch fix bug 26040483. That patch I give you as image below:



But I dont't know how to install patch. I have never had experience to install patch. Can you help me install that on Window server. Thank you.

[ErmanArslansOracleBlog]

You patch your database with opatch utility.
Download the patch.
Put it in your db server.
Unzip it.
Follow the instructions in the readme file and apply the patch..
Also read some documents about database patching with opatch..
If this is a production db, it is risky to patch it without having any patching experience/knowledge.. be careful.

[Huy Nguyen]

Thank you for your quickly guide. I don't have experience to install patch via OPatch. So I decided to find another way. do not call web source.  Thank you again.

[ErmanArslansOracleBlog]

:) okay.

[Huy Nguyen]

Hi Erman again ;)),

Many method I tried but it was unsuccessfully. So I come back to you ^_^

I search on MOS  patch 26040483, it not included platform win 10 64 bit. So can I apply patch for my Oracle DB by another way?

You see my picture above in old comment,  I download it and apply and  now it shows me below

Patch ( 26040483 ) is not applicable on current platform.

[ErmanArslansOracleBlog]

You may consider upgrading your database to 18C or 19C. It seems this bug is fixed in 18.1

Ref: UTL_HTTP call to https site fails ORA-28750: Unknown Error after Upgrade To 12.2, But works in 12.1 DB (Doc ID 2459858.1)

[Huy Nguyen]

I also  think about your great idea. Thank you for your time.