Thursday, March 13, 2014

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

Reason: This exception occurs when the user is trying to allocate an SGA or PGA size more than what is allocate to the database. This may also occur when the user is trying to allocate the database less memory than the minimum requirement.

Solution:

1)      First create a temporary pfile from current spfile:
2)      Sql command : Create  pfile=<filepath>/filename from spfile;
3)      Open the pfile and edit value of MEMORY_TARGET and set to required value, then create spfile from this modified pfile:
4)      Sql command: create spfile from pfile=<filepath>/filename
5)      Restart the database using SQL command: Startup

No comments:

Post a Comment