OraFAQ Forum: Linux » ora-27102 out of memory

Home » Infrastructure » Linux » ora-27102 out of memory (oracle,11g,linux)

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

ora-27102 out of memory [message #526632]

Wed, 12 October 2011 02:17

crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi

Member

Hi All,

Getting Error .. when trying to startup the database with some changes in the SGA ..

Current Values :-

NAME TYPE VALUE
---------------------------------------------------------
sga_target big integer 0
sga_max_size big integer 1952M
pga_aggregate_target big integer 0
memory_target big integer 2G
memory_max_target big integer 2G

made below changes as below :-
sga_target=4092m
memory_target=4831838208

I suspect that the problem is the shmmax and/or the shmall kernel parameters. went through documentation but nothing is very specific in calculating the parameter values for a very large system.

free
total used free shared buffers cached
Mem: 16628888 15630272 998616 0 104416 9901472
-/+ buffers/cache: 5624384 11004504
Swap: 17434828 1698236 15736592

Paramter value for shmmax & shmall
kernel.shmmax = 4294967295
kernel.shmall = 268435456

We have 16GB of RAM ... and CPU E5620 @ 2.40GHz ...

I'm not sure what to set and what the impact could be if I just max out shmmax & shmall parameters.
please suguest how to proceed ..

Regards,
Vimlendu

Report message to a moderator

Re: ora-27102 out of memory [message #526638 is a reply to message #526632]

Wed, 12 October 2011 02:43

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-27102: out of memory
 *Cause: Out of memory
 *Action: Consult the trace file for details

Regards
Michel

[Updated on: Wed, 12 October 2011 04:27]

Report message to a moderator

Re: ora-27102 out of memory [message #526650 is a reply to message #526632]

Wed, 12 October 2011 04:10

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Are you using 32bit or 64bit Linux?

Report message to a moderator

Re: ora-27102 out of memory [message #526652 is a reply to message #526650]

Wed, 12 October 2011 04:32

crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi

Member

How can i check ..

Here i can give you the uname -a info ..

Linux xxxxx 2.6.18-194.el5PAE #1 SMP Mon Mar 29 20:19:03 EDT 2010 i686 i686 i386 GNU/Linux

Report message to a moderator

Re: ora-27102 out of memory [message #526670 is a reply to message #526652]

Wed, 12 October 2011 06:17

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

You are using 32bit Linux. Using more than about 2.7G for Oracle is complicated. Much easy to reinstall the server, using 64bit Linux, and start again.

Report message to a moderator

Re: ora-27102 out of memory [message #526680 is a reply to message #526670]

Wed, 12 October 2011 07:41

crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi

Member

Apart from reinstall the server ,using 64bit linux .. do we have any other option to release the issue .. ?

Report message to a moderator

Re: ora-27102 out of memory [message #526684 is a reply to message #526680]

Wed, 12 October 2011 08:08

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Well, you don't have to use a 64bit operating system. Instead you can compile and boot the hugemem linux kernel, configure hugepages, and start using indirect data buffers instead of automatic memory management.
I know what I would do.

Report message to a moderator

Previous Topic:	How to get READ command working in LINUX.
Next Topic:	High Load Avarage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 05:00:33 CST 2024