Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center