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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s