Home » Server Options » RAC & Failsafe » increase SGA size failed.
increase SGA size failed. [message #302330] Mon, 25 February 2008 04:41 Go to next message
wxfjordan
Messages: 92
Registered: December 2006
Member

My server has total 32GB RAM and I just want to increase SGA size to 16GB size.

I operate like this:

In OS:

/etc/sysctl.conf:

kernel.sysrq = 1
kernel.core_uses_pid = 1
kernel.shmmni = 4096
kernel.shmall = 4194304
net.core.rmem_default=1048576
net.core.wmem_default=1048576
net.core.rmem_max=1048576
net.core.wmem_max=1048576
kernel.sem = 2000 500000 100 250
kernel.shmmax =34359738368
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000

And then reboot server.

In Database:

alter system set processes =1000 scope=spfile sid='*';
alter system set transactions=1000 scope=spfile sid='*';
alter system set "_gc_affinity_time"=0 scope=spfile sid='*';
alter system set "_gc_undo_affinity"=false scope=spfile sid='*';
alter system set cursor_space_for_time=true scope=spfile sid='*';
alter system set sga_max_size=16g scope=spfile sid='*';
alter system set sga_target=0 scope=spfile sid='*';
alter system set shared_pool_size=4096m scope=spfile sid='*';
alter system set cursor_sharing = SIMILAR scope=spfile sid='*';
alter system set pga_aggregate_target=8192m scope=spfile sid='*';
alter system set session_cached_cursors=200 scope=spfile sid='*';

And then I shutdown immediate and startup failed. Prompt error message:


SQL> startup nomount;
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device



How to exactly increase SGA size? what problem in my command?


Re: increase SGA size failed. [message #302412 is a reply to message #302330] Mon, 25 February 2008 09:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
try below instead
#below oracle specific
kernel.shmall = 2097152
kernel.shmmax = 7956500000
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6553600
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
net.core.rmem_default=4194304
net.core.rmem_max=4194304
#end oracle specific paramters
Re: increase SGA size failed. [message #302494 is a reply to message #302330] Mon, 25 February 2008 23:05 Go to previous messageGo to next message
wxfjordan
Messages: 92
Registered: December 2006
Member

The Above can startup DB. But it can not configure 16GB SGA size.

I want to set up 16GB SGA size and startup DB normally.

How to configure these parameters?

[Updated on: Mon, 25 February 2008 23:07]

Report message to a moderator

Re: increase SGA size failed. [message #302540 is a reply to message #302330] Tue, 26 February 2008 01:29 Go to previous message
wxfjordan
Messages: 92
Registered: December 2006
Member

kernel.sysrq = 1
kernel.core_uses_pid = 1
kernel.shmmni = 4096
kernel.shmall = 8388608
kernel.shmmax =34359738368
net.core.rmem_default=1048576
net.core.wmem_default=1048576
net.core.rmem_max=1048576
net.core.wmem_max=1048576
kernel.sem = 2000 500000 100 250
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000


I have configured above parameters and successful alter 16GB SGA size.
Previous Topic: configure LOAD BALANCER in DEDICATED SERVER
Next Topic: How Instance Switch Occur
Goto Forum:
  


Current Time: Thu Mar 28 06:48:25 CDT 2024