Forum Stats

  • 3,750,517 Users
  • 2,250,187 Discussions
  • 7,866,997 Comments

Discussions

ORA-29013: SSL MAC verification failure

2

Answers

  • Paul Jorstad
    Paul Jorstad Member Posts: 67 Blue Ribbon

    We have just upgraded from 19.8 to 19.10. We still have MAC verification error, but I'm not able to reproduce the "ORA-29263: HTTP protocol error" which we also got, looks like the same user8602157 describes, with responses bigger than 32K . At least I've not able to reproduce it after the upgrade to 19.10.

    So - still working on the MAC verification error then :-/

  • user8602157
    user8602157 Member Posts: 6 Bronze Badge

    We have been given OOB patch for 19.9 which from our initial testing appears to fix the issue of the corruption and don't get the MAC verification, but that part was intermittent. We did try 19.10 but still got the corruption. Planning to upgrade our development system to 19.9 and apply the OOB patch so the developers can do a more thorough test.

  • Paul Jorstad
    Paul Jorstad Member Posts: 67 Blue Ribbon

    Oracle Support says "As this is not a generic issue from the database end we will not be able reproduce the issue.", meaning there are no errors with the database regarding this. If so, what is it then? Windows? The network? I'm so confused.....

  • Janis
    Janis Member Posts: 10 Blue Ribbon

    problem is not on linux so far we had noticed, seems like windows with oracle together is some kinda problem...

  • Paul Jorstad
    Paul Jorstad Member Posts: 67 Blue Ribbon

    Ok, thanks for feedback on that Janis :-)

  • user8602157
    user8602157 Member Posts: 6 Bronze Badge

    The only information I currently have from Oracle support is "We found a not published BUG from Network team", I am waiting for more details from Oracle support. The patch itself only contains one main file which is oran19.dll. There are no scripts to run on the database afterwards.

  • Paul Jorstad
    Paul Jorstad Member Posts: 67 Blue Ribbon

    ok, that's interesting user8602157. Please let ut know the outcome, and maybe the bugnumber if you have. Also if you can send me your SR-number in PM here, I can update my SR-case with that.

  • Janis
    Janis Member Posts: 10 Blue Ribbon

    btw there is patch available for 19.9 and and 19.10 and it seems to work . Apply Patch 32738356

    have a good day!

  • Paul Jorstad
    Paul Jorstad Member Posts: 67 Blue Ribbon

    Yes, Janis, I got to know that from Oracle Support too, but we did not manage to apply it, as we got this in the log:

    [2021-05-18 11:28:30] Error: prereq checks failed!

    [2021-05-18 11:28:30] patch 32738356: XML descriptor does not exist in either the file system or SQL registry

    [2021-05-18 11:28:30] Prereq check failed, exiting without installing any patches.

    Do you happen to know what this is? (I have of course sent the log to Oracle Support, and awaiting their answer)

  • Janis
    Janis Member Posts: 10 Blue Ribbon

    do you have 19.9 or 19.10 version of oracle db? to me all worked nice, only problems still with 19.11. so i rolled some test server back to 19.3 and applied 19.10 and then this patch .