5 Replies Latest reply on Jul 20, 2020 11:58 AM by Bo A

    ORDS 19.4 to 19.4.6 causes massive concurrency in the database

    Bo A

      Hello everyone,

                              I'm running into this issue in our current test instance where during ORDS upgrade process, it would cause a massive concurrency in the database. Eventually

       

      Eventually, it errored out with the following error message in the ords_upgrade log.
      ORA-20103: Cannot revoke EXECUTE on SYS.DBMS_UTILITY from ORDS_PUBLIC_USER. ORA-04021: timeout occurred while waiting to lock object

       

      I've never run into this issue before during the previous ORDS upgrade. (We have been running our ORDS inside a docker containers since ORDS 18.2 (we upgraded to 19.4 with no issue).

      Has anyone had this issue with a 19.4.6 upgrade on non-docker instance, also?