Forum Stats

  • 3,741,181 Users
  • 2,248,384 Discussions
  • 7,861,664 Comments

Discussions

Bug :( Oracle Wallet 19.3c on Win

fatehcis-JavaNet
fatehcis-JavaNet Member Posts: 821
edited Aug 10, 2020 6:30PM in General Database Discussions

Hello,

After upgrading from 18.3c to 19.3c Standard Edition on Windows server 2016, when performing

apex_web_service.make_rest_request

we started getting

ora-29263 http protocol error

Which has nothing to do with

*Action: Check the HTTP server that the HTTP operation was performed tomake sure that it follows the HTTP protocol standard.

Because Certificates were working fine before the upgrade and tested again on Oracle 18.3 EX and they working fine.

What makes it weird is that in some cases, after creating the wallet >> moving the wallet into another directory >> It works  ONLY for one time, then it returns the error:

ora-29263 http protocol error

. And for 19.3c there is no recommended patches on the Support website.

Answers

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,464 Red Diamond
    edited Aug 6, 2020 2:42AM

    Try to isolate the error, with manually testing wallet access with the UTL_HTTP package API.

    I would create a new schema, assign the same network ACL to it used for the APEX schema,  and use a test web browser function (like ) to try to troubleshoot and isolate the error.

    fatehcis-JavaNet
  • fatehcis-JavaNet
    fatehcis-JavaNet Member Posts: 821
    edited Aug 6, 2020 5:48PM

    Thanks for your reply,

    I just installed 19.3c Standard Edition on Windows 2012, and I got the same error; whereas it is working fine on XE 18.

    So, it looks like a clear bug. --- Disappointing to find repeated bugs. This bug was in previous releases as well.

  • JohnWatson2
    JohnWatson2 Member Posts: 4,267 Silver Crown
    edited Aug 7, 2020 1:59AM

    What is the URL request you are making? It may be that it is using a certificate that 19.3 does not like. I have had problems with that a couple of times caused by Oracle supporting (or desupporting) different cipher suites in different releases. A work around has been to configure an Apache proxy: Oracle talks to Apache, and Apache forwards the request on.

    fatehcis-JavaNet
  • fatehcis-JavaNet
    fatehcis-JavaNet Member Posts: 821
    edited Aug 7, 2020 5:08PM

    Hi John,

    Thanks for your reply. You are right, we noticed that the HTTPS calls work fine for some domains e.,g https://www.googleapis.com/ works fine.

    But it returns this error

    ora-29263 http protocol error

    when calling these domains

    https://www.propertyfinder.ae/

    https://www.bayut.com/

    Unfortunately, these two domains  do not allow reverse  proxy.

  • JohnWatson2
    JohnWatson2 Member Posts: 4,267 Silver Crown
    edited Aug 8, 2020 2:08AM

    I said "proxy", not "reverse proxy". You install the proxy at your site, and it forwards requests to the remote site. It is simple to do, a standard fix for this sort of thing.

    However, those URLs work for me no problem:

    atest> select apex_web_service.make_rest_request('https://www.propertyfinder.ae','GET') from dual;

    APEX_WEB_SERVICE.MAKE_REST_REQUEST('HTTPS://WWW.PROPERTYFINDER.AE','GET')

    --------------------------------------------------------------------------------

    <!DOCTYPE html>

    <html><head><script>

          window.dataLayer = [];

          window.l

    atest> select apex_web_service.make_rest_request('https://www.bayut.com','GET') from dual;

    APEX_WEB_SERVICE.MAKE_REST_REQUEST('HTTPS://WWW.BAYUT.COM','GET')

    --------------------------------------------------------------------------------

    <!DOCTYPE html><html lang="en" dir="ltr" itemscope="" mobilechatbutton="bubble_b

    atest> select * from v$version;

    BANNER

    --------------------------------------------------------------------------------

    BANNER_FULL

    -----------------------------------------------------------------------------------------------------------------------------

    BANNER_LEGACY                                                                        CON_ID

    -------------------------------------------------------------------------------- ----------

    Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production

    Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production

    Version 19.7.1.0.0

    Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production                    0

    atest>

    fatehcis-JavaNet
  • fatehcis-JavaNet
    fatehcis-JavaNet Member Posts: 821
    edited Aug 10, 2020 1:28PM

    Hello and thanks for your attention,

    The issue is very weird, and I think it is not about the Wallet as we are facing strange behavior. 

    *** It is 19.3c on Win Server 2016

    1- Sometimes the https request work and in most cases do not work.

    2- When it works (with or without Proxy) the JSON response sometimes has problems eg., it replaces  " for ?. When calling Google APIs.

    Best solution is to downgrade back to 18c and work with the support.

    Even this solution on Oracle Support did not work.

  • JohnWatson2
    JohnWatson2 Member Posts: 4,267 Silver Crown
    edited Aug 10, 2020 2:16PM

    Perhaps you need to apply the July RU (or RUR) as I have.

    fatehcis-JavaNet
  • fatehcis-JavaNet
    fatehcis-JavaNet Member Posts: 821
    edited Aug 10, 2020 6:30PM

    Thanks again,

    Could you pls share the patch number since I did not find any recommended patch for 19.3c on Windows..

    Regards

  • user6216988
    user6216988 Member Posts: 1 Red Ribbon

    Try this one p32738356_19900201020WINDBBP_MSWIN-x86-64

Sign In or Register to comment.