ORA-04024: Self-deadlock Detected While Trying To Mutex Pin Cursor on Dataguard database
(Doc ID 3047348.1)
Last updated on NOVEMBER 01, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 19.12.0.0.0 [Release 12.1 to 19]Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
In Standby db, on Dataguard env.
ORA-04024 occurs by all query. The database synchronizes without problems, but when making queries on the tables of the data dictionary and schema tables, the error occurs.
The error presented is the following:
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |