Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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?

This post has been answered by EJ-Egyed on Jul 17 2020
Jump to Answer

Comments

Post Details

Added on Jul 16 2020
6 comments
583 views