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.
|
No comments:
Post a Comment