Skip to Main Content

RA-04024: self-deadlock detected while trying to mutex pin cursor 0x51F4E7FF8

User_RXNCFApr 18 2018 — edited Aug 16 2018

DB: 12.2.0.1 jan PSU 2018

Exadata: X7

On standby server (Active dataguard) we are facing below issue, let me know if any faced this issue. DG broker configured..and no errors in alert logs.

SYS>alter session set container=PDBTST;

ERROR:

ORA-00604: error occurred at recursive SQL level 2

ORA-04024: self-deadlock detected while trying to mutex pin cursor 0x51F4E7FF8

SYS@>SHOW PDBS

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 PDBTST                                  READ ONLY  NO

SYS>

Thanks

DBA

Comments
Post Details
Added on Apr 18 2018
4 comments
2,983 views