AdnanDBA

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00604: error occurred at recursive SQL level 2

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

I was performing a clone from a cold backup in a 12c SE2 (12.1.0.2) environment and was stuck with the errors (ORA-04024 and ORA-01092). The database restore was completed but while performing the ‘alter database open resetlogs’ it was giving the errors mentioned above. Below are the steps followed and resolution for the same.

Issue:

After cloning database

SQL> alter database open; alter database open * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00604: error occurred at recursive SQL level 2 ORA-04024: self-deadlock detected while trying to mutex pin cursor 0x0F1DF73A8 Process ID: 17383 Session ID: 414 Serial number: 58778

Cause:

It is a bug in 12.1.0.2 version of DB

Resolution:

SQL> startup mount; ORACLE instance started. Total System Global Area 2634022912 bytes Fixed Size                  3714296 bytes Variable Size            2046821128 bytes Database Buffers          570425344 bytes Redo Buffers               13062144 bytes Database mounted. SQL> alter system set "_fix_control"='9550277:ON'; System altered. SQL> alter database open; Database altered.