ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 5243264M

chalie001
chalie001 used Ask the Experts™
on
hi am geting this error in database 12c in solaris i did this

Enter user-name: /as sysdba

Connected to an idle instance.

 

 

SQL> startup

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 5243264M

SQL> create pfile from spfile;

 

 

File created.

 

 

SQL> startup

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 5243264M

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
johnsoneSenior Oracle DBA

Commented:
This is the documentation page that details the error.  You need to scroll down quite a way.

Essentially, it is telling you that the SGA_TARGE, PGA_AGGREGATE_TARGET and MEMORY_TARGET variables are not set up correctly.  As it seems you generated a pfile, if you could post that (in a code block), someone could probably help more.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
If you are unable to locate the pfile you created:
create pfile '/tmp/mypfile.ora' from spfile;

Then post /tmp/mypfile.ora  again, in code blocks and replace anything that you don't want posted on a public website.


More important, what were you trying to do before you started receiving this error?
HuaMin ChenProblem resolver

Commented:
Try to manually adjust the value like

SQL> CREATE PFILE FROM SPFILE;
MANUALLY EDIT PFILE & CORRECT MEMORY_TARGET VALUE
SQL> CREATE SPFILE FROM PFILE;
SQL> STARTUP

Open in new window

Database Administrator
Commented:
After you do these two steps:
SQL> CREATE PFILE FROM SPFILE;
MANUALLY EDIT (this new) PFILE & CORRECT MEMORY_TARGET VALUE

Open in new window


Your "STARTUP..." command must include "PFILE=[your new pfile location and name]

Slightwv gave you a good way to make that easy:
create pfile '/tmp/mypfile.ora' from spfile;

Open in new window


Then your startup should be:
STARTUP PFILE='/tmp/mypfile.ora'

Open in new window


If that is successful:
CREATE SPFILE from PFILE='/tmp/mypfile.ora'

Open in new window


Then, do a shutdown and another "STARTUP" (with no options) to run from your new spfile.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial