Fixing ORA-00838: Specified value of MEMORY_TARGET is too small

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!

😀

Advertisements