I am running into this error in a system at work, and I feel like I've read the entire internet on the subject and I'm still stumped. Googling the error itself only returns some email thread without a good answer from who knows how long ago, lol.
Here's the documentation:
https://docs.oracle.com/cd/A97385_01/appdev.920/a96612/d_alert.htm
In our trace logs, which I admittedly have a difficult time reading in any way that would be meaningful to a human being, I believe this is the SQL that is running when this error is thrown:
UPDATE DBMS_ALERT_INFO SET CHANGED = 'Y', MESSAGE = :B2 WHERE NAME = UPPER(:B1 )
Here is the error:
ORA-20000: ORU-10001: lock request error, status: 2
ORA-06512: at "SYS.DBMS_ALERT", line 424
[... proprietary code ...]
Oracle Server Version : Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Can anyone help me out?
Thanks,
Amanda