ORA-04024 error at SAP bundle patch rollback

Posted on


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



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *