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!

sga_target greater than sga_max_size issue

625619May 19 2010 — edited May 19 2010

Hi,
I accidentally changed the values of sga_target with large value than the sga_max_size and did a shutdown immediate.

Now when I'm trying to bring the instance up, it is giving the below error.

[oracle@linuxappdev bin]$ ./sqlplus /nolog

SQL*Plus: Release 11.1.0.7.0 - Production on Wed May 19 22:27:13 2010

Copyright (c) 1982, 2008, Oracle. All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORA-00823: Specified value of sga_target greater than sga_max_size
SQL>

How do I bring the instance up?
I'm new to the oracle, please help.

Thanks,
Ram

Edited by: user622616 on May 19, 2010 7:50 PM

This post has been answered by sulimo on May 19 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 16 2010

Added on May 19 2010

#general-database-discussions

8 comments

8,685 views