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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SGA,PGA exceeds the memory and oracle is not working

Hussien SharafDec 28 2015 — edited Jan 5 2016

Hi,

I have wrongly set the following:

ALTER system SET sga_max_size=1500M scope=spfile;

ALTER system SET SGA_TARGET=1400M scope=spfile;

ALTER SYSTEM SET PGA_AGGREGATE_TARGET = 9000M scope=spfile;

My total memory is 16 GB, Win8

When I restarted the oracle , it couldn't startup and I m sure 100% that these memory sizes are the problem.

Now I can't login to the DB to fix these memory sizes.

How can I modify the SGA, PGA while the whole oracle is down? It is not only the DB instance that is nt working. It s the whole oracle.

Is there a way to modify the spfile from a text editor?

I d appreciate your fast replies.

Regards,

Hussien Sharaf

Message was edited by: 3008910

This post has been answered by Chizzle Pack on Dec 28 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2016

Added on Dec 28 2015

#general-database-discussions, #oracle

36 comments

16,878 views