Discussions
Categories
- 384.5K All Categories
- 2.5K Data
- 551 Big Data Appliance
- 1.9K Data Science
- 451.3K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 560 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 560 SQLcl
- 4K SQL Developer Data Modeler
- 187.4K SQL & PL/SQL
- 21.4K SQL Developer
- 296.8K Development
- Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.5K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 178 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 164 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 524 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 235 Portuguese
ORDS 19.4 to 19.4.6 causes massive concurrency in the database
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?
Best Answer
-
Have you tried upgrading to ORDS 20.2? There is a very similar issue that was fixed in ORDS 20.2 and this issue could potentially be fixed as well.
https://www.oracle.com/tools/ords/ords-relnotes-202.html
Answers
-
are you an oracle employee?
are you doing a container (multitenant) install?
-
I'm not an Oracle Employee.
are you doing a container (multitenant) install?
No, My ORDS installation is on tomcat server that is running inside a docker.
Our RDMBS version is 12.1.0.2, APEX 20.1, and ORDS 19.4.
UPDATE: During ORDS upgrade from 19.4 to 19.4.6 the concurrency issue in the database was so bad that we can't even access the EBS instance anymore. Since it was non-production instance, I also tried doing ORDS upgrade with EBS front-end shutdown. Massive concurrencies still occurred in the database activity during the ORDS upgrade and eventually error out with ORA-20103: Cannot revoke EXECUTE on SYS.DBMS_UTILITY from ORDS_PUBLIC_USER. ORA-04021: timeout occurred while waiting to lock object.
-
Have you tried upgrading to ORDS 20.2? There is a very similar issue that was fixed in ORDS 20.2 and this issue could potentially be fixed as well.
https://www.oracle.com/tools/ords/ords-relnotes-202.html
-
Thank you, I supposed I could tried ORDS 20.2.0 instead. Thank you and will let you know.
-
I don't see the same concurrency issue in the database when going from 19.4 to 20.2.0. Thank you.
-
Hello,
We just ran into the same issue, but with
20.4.3.r0501904ORA-20103: Cannot revoke EXECUTE on SYS.DBMS_UTILITY from ORDS_PUBLIC_USER. ORA-04021: timeout occurred while waiting to lock objectThe SYS session is waiting on "Revoke: get object" while running the revoke.
At the same time we see many other sessions suddenly getting blocked on cursor: pin S wait on X. This is a 2 node RAC on rdbms 19.11
I guess we will have to request downtime to upgrade to this new ORDS.
regards