ORA-01078: failure in processing system parameters

This error occurs when SPFILE parameter has been set to an inappropriate value that will consume all the memory and hangs the instance from opening.

The solution is to restore the SPFILE from backup OR recreate it from PFILE.

Steps to recover SPFILE:

$ rman target / 
RMAN> startup nomount;
RMAN> restore spfile;