Notes from the field: DB doesnt start after changing spfile on ASM

If you changed your spfile with

alter system set =.... scope=spfile;

shutdown immediate;

startup;

The database refuses to startup. The spfile is on ASM storage, so you don't have a filesystem to visit and modify it.

Steps to follow to revert spfile to original:

In $ORACLE_HOME/dbs

. oraenv

sqlplus "/ as sysdba"

startup nomount

create pfile='recoverinit.ora' from spfile
/
shutdown immediate
exit

Edit the newly created pfile to change the parameter which caused trouble, to its original value

Save the pfile

sqlplus "/ as sysdba"

startup pfile='recoverinit.ora' (or whatever you called it in step one).

create spfile='+DATA/ORACLE_SID/spfileORACLE_SID.ora' from pfile='recoversp'
/
Note:The name of the spfile is in your original init.ora so adjust to suit

shutdown immediate
startup
exit