Skip to Main Content

ORDS 19.4 to 19.4.6 causes massive concurrency in the database

Bo AJul 16 2020 — edited Jul 20 2020

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?

Post Details
Added on Jul 16 2020