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!

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

Comments

277993
See Enterprise Manager SNMP Support Reference Guide

http://download-uk.oracle.com/docs/cd/B16240_01/doc/em.102/b16244/toc.htm
637909
I can't found an Oracle SNMP configuration guide that has the specific steps for the Oracle and Linux version of my case anyway I follow general steps and I have this message in master_peer.out
snmp bind failure: Address already in use
smux bind failure: Address already in use
./master_peer: error processing configuration
and in encap_peer.out:
trap bind failure: Address already in use
./encap_peer: error opening manger-role port(s)
Finally please I need to know if It is necesary to add in /etc/services a line reference of 1161 port.
23ai
This link http://download-uk.oracle.com/docs/cd/B16240_01/doc/em.102/b16244/toc.htm is not really very useful.

It seems Oracle does not provide enough documentation on the SNMP Configuration.

I am having the same problem and no idea?

Any idea guys..
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 2 2016
Added on Dec 28 2015
#general-database-discussions, #oracle
36 comments
17,733 views