Solution : https://service.sap.com/sap/support/notes/867681 (SAP Service marketplace login required)
Key words :
terms smon tt enqueue lock reason, alter tablespace psaptemp add tempfile '<, system issues analter database tempfile '<, startup mount alter database tempfile '<, symptom alter database tempfile <, alter database open, smon process holds, command hangsbrrecover hangs, brrecover session hangs, oracle versions concerned
Related Notes :
745639 | FAQ: Oracle enqueues |
491160 | Restore scenarios for lost files of oracle databases |