I can never remember how to do this so its getting dumped here.
SQL>startup ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 1172M SQL> create pfile='/tmp/pfile.bkp' from spfile; File created. $ vi /tmp/pfile.backup *.memory_target=2048m
Start sqlplus, and import the pfile settings into the spfile
SQL> create spfile from pfile='/tmp/pfile.bkp'; File created.
Ye’ should be golden!