Home » Infrastructure » Linux » ora-27102 out of memory (oracle,11g,linux)
icon5.gif  ora-27102 out of memory [message #526632] Wed, 12 October 2011 02:17 Go to next message
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
Re: ora-27102 out of memory [message #526638 is a reply to message #526632] Wed, 12 October 2011 02:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Are you using 32bit or 64bit Linux?
Re: ora-27102 out of memory [message #526652 is a reply to message #526650] Wed, 12 October 2011 04:32 Go to previous messageGo to next message
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
Re: ora-27102 out of memory [message #526670 is a reply to message #526652] Wed, 12 October 2011 06:17 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: ora-27102 out of memory [message #526680 is a reply to message #526670] Wed, 12 October 2011 07:41 Go to previous messageGo to next message
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 .. ?
Re: ora-27102 out of memory [message #526684 is a reply to message #526680] Wed, 12 October 2011 08:08 Go to previous message
John Watson
Messages: 8922
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.

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


Current Time: Thu Mar 28 05:04:37 CDT 2024