ORA-00838 error after increasing MEMORY_TARGET

oracle

I've increased MEMORY_TARGET in pfile and then create spfile. I'm getting the same problem as before: 

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

The memory_target in pfile is 3084M.

I've already increased tmpfs on /dev/shm to 5Gb. And no idea what to do next?

Best Answer

Set MEMORY_TARGET to at least the recommended value. 

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

What OS are you using?

Related Question