How can we overcome or prevent this ORA-29770: global enqueue on Oracle 11gR2 RAC v.11.2.0.4 on RHEL
Hi,
We have a 2 Node Oracle 11gR2 RAC Setup with v.11.2.0.4 on RHEL and since 1 week we have started facing this ORA-ERROR i.e. ORA-29770: global enqueue process LMD0 (OSID 104694) is hung for more than 70 seconds then the instance is getting terminated.
When we have installed and configured this 11gR2 RAC version we have used the latest PSU/RUP and since this was the last terminal patch set. There won't be any patch available to apply now.
So what can we do in order to prevent this issue/error to occur now ? Please advise.
Sat Apr 08 02:00:00 2023
Closing scheduler window
Closing Resource Manager plan via scheduler window