Issue : ORA-00821: Specified value of sga_target 2512M is too small

Issue while starting the Database with SGA_TARGET value after OS Migration is done...

Casue: Due to higher Mainmemory settings incorporated in new machine, older values are having issue. This is one of them.



Detials :
-bash-3.2$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 22 11:17:22 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-00821: Specified value of sga_target 2512M is too small, needs to be at least 3808M


Solution: -
===========
Took backup of the pfile
changed the sga_target value to the one recommended. Here we changed it to 4000M and then tried starting the Database
Database got started without any issues.

Issue is resolved....

Ref Note/URL: http://oradbablog.blogspot.com/2007/03/ora-00821-specified-value-of-sgatarget.html