[ORACLE-DB] Modify spfile setting in case unable to startup instance when parameter in spfile is wrong

$sqlplus / as sysdba

sql> create pfile='pfile.ora' from spfile='spfileORCL.ora';

Modify wrong parameter in pfile.ora and start your instance using this new configuration:

sql> startup pfile='pfile.ora';

You can then save your settings back to an spfile with the following command:

sql> create spfile='spfileORCL.ora' from pfile='pfile.ora';

And shutdown/start your database as usual:

sql> shutdown immediate;

sql> startup;