chalie001
asked on
ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 5243264M
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
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?
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?
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.