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?