Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error message: ORA-00821: Specified value of sga_target 4M is too small

SadockJun 10 2011 — edited Jun 10 2011
Dear all

My database instance is down,when I am trying to start, it throw any error:
ORA-00821: Specified value of sga_target 4M is too small, needs to be at least 28M

The problems started when erroneous altered sga_target to some values without specifying the unit.
My question is, how can I resolve this issue while the database instance is down? I am using spfile

I tried to start the instance with pfile (startup pfile='D:\oracle\product\10.2.0\admin\orcl\pfile\init.ora') it throw errors:
LRM-00109: could not open parameter file 'D:\oracle\product\10.2.0\admin\orcl\pfile\init.ora'
ORA-01078: failure in processing system parameters


Please any one to help me

Regards
Sadock
This post has been answered by Gerwin Hendriksen on Jun 10 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2011
Added on Jun 10 2011
#general-database-discussions
6 comments
20,019 views