Forum Stats

  • 3,874,866 Users
  • 2,266,782 Discussions
  • 7,911,988 Comments

Discussions

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

User_RXNCF
User_RXNCF Member Posts: 51 Red Ribbon
edited Aug 16, 2018 6:37PM in Multitenant

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

[email protected]>SHOW PDBS

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PDBTST                                  READ ONLY  NO

SYS>

Thanks

DBA

Answers

This discussion has been closed.