OraFAQ Forum: RAC & Failsafe » increase SGA size failed.

Home » Server Options » RAC & Failsafe » increase SGA size failed.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

increase SGA size failed. [message #302330]

Mon, 25 February 2008 04:41

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?

Report message to a moderator

Re: increase SGA size failed. [message #302412 is a reply to message #302330]

Mon, 25 February 2008 09:32

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

Report message to a moderator

Re: increase SGA size failed. [message #302494 is a reply to message #302330]

Mon, 25 February 2008 23:05

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

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.

Report message to a moderator

Previous Topic:	configure LOAD BALANCER in DEDICATED SERVER
Next Topic:	How Instance Switch Occur

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 22:40:45 CST 2024