For some technical reasons, recently I had to rollback the bundle patch Oracle Database SAP Bundle Patch 12.1.0.2.170418 – 201705. I followed exactly the steps from the guide, but when trying to start the database back, after the deinstallation, I got this error:
SQL> startup ORACLE instance started. Total System Global Area 1.4596E+10 bytes Fixed Size 6952656 bytes Variable Size 4362078512 bytes Database Buffers 1.0201E+10 bytes Redo Buffers 26599424 bytes Database mounted. ORA-01092: ORACLE instance terminated. Disconnection forced ORA-04024: self-deadlock detected while trying to mutex pin cursor 0x3BD887D18 Process ID: 21912 Session ID: 301 Serial number: 50635
The solution to this problem can be found in the note 2392622. To summarize it, the self deadlock will be solved by adding the fix control ‘9550277:ON’.
Note for more information:
2392622 – ORA-01092 and ORA-04024 after SBP deinstallation when trying to startup database to execute rmsbp
Related