Home » Infrastructure » Linux » ORA-27102 out of memory and Linux Error: 28: No space left on device
ORA-27102 out of memory and Linux Error: 28: No space left on device [message #169226] Tue, 25 April 2006 16:23 Go to next message
vinman
Messages: 2
Registered: April 2006
Location: Montreal
Junior Member
Getting error:

ORA-27102: out of memory
Linux Error: 28: No space left on device

when trying to startup another database with a shared_pool_size of 1.3 gb or higher.

I suspect that the problem is the shmmax and/or the shmall kernel parameters of the SUSE LINUX setup. I have checked through much documentation but nothing is very specific in calculating the parameter values for a very large system.

We have a 4 CPU, dual core system, with 30GB of RAM, with 46 Oracle instances running on it. Here are some parameter values that I captured. What should these be set to optimally? Asktom sites shows:
shmmax = total RAM
shmall = ceil (shmmax/OS block size)

Oracle states:
shmmax = total RAM % 2
shmall = ceil (shmmax/OS block size)


I'm not sure what to set and what the impact could be if I just max out these parameters. I cannot tell eith how to calcualte how much shared memory I am using. I tried using the ipcs -m
command and found that the memory used there totalled to 4841197712 bytes. This is not including the database I want to bring up with shared_pool_size of 1.3gb. Now that number exceeds my shmmax, so how do I know what limits I am hitting? Can anyone help?


I am running on SUSE LINUX 9
The Oracle database version used is 9.2.0.6

$uname -a
Linux holland 2.6.5-7.97-bigsmp #1 SMP Fri Jul 2 14:21:59 UTC 2004 i686 i686 i386 GNU/Linux


$/proc/sys/kernel> cat shmall
2097152
$/proc/sys/kernel> cat shmmax
3294967296
$/proc/sys/kernel> cat shmmni
4096
$/proc/sys/kernel> cat sem
1250 32000 100 256

$ulimit -l
unlimited

$ipcs -lm
------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 3217741
max total shared memory (kbytes) = 8388608
min seg size (bytes) = 1

$getconf PAGE_SIZE
4096

$cat meminfo
MemTotal: 31197540 kB
MemFree: 364976 kB
Buffers: 104916 kB
Cached: 26857704 kB
SwapCached: 325640 kB
Active: 12351632 kB
Inactive: 17776628 kB
HighTotal: 30539332 kB
HighFree: 356992 kB
LowTotal: 658208 kB
LowFree: 7984 kB
SwapTotal: 16723624 kB
SwapFree: 15726720 kB
Dirty: 238380 kB
Writeback: 0 kB
Mapped: 5582468 kB
Slab: 451316 kB
Committed_AS: 15340340 kB
PageTables: 165140 kB
VmallocTotal: 112632 kB
VmallocUsed: 69692 kB
VmallocChunk: 42672 kB
HugePages_Total: 0
HugePages_Free: 0
Hugepagesize: 2048 kB


$free
total used free shared buffers cached
Mem: 31197540 30854968 342572 0 105068 26886348
-/+ buffers/cache: 3863552 27333988
Swap: 16723624 996892 15726732

$ipcs -m
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x000044b4 196609 root 666 86160 2
0x7a876784 212795394 fs89qa 640 140509184 8
0xaac26c60 212828163 odsdev 640 7081984 6 locked
0x0500c640 212893701 helptst 640 71303168 35
0x97a4a804 212926470 treasury 640 188874752 6 locked
0xb5762d6c 164069386 ps8dmo 640 50581504 6 locked
0xef3482cc 212992011 limsdev 640 111149056 7
0x1400a900 213024780 cmstst 640 375390208 14
0x10ed81e0 213057549 ias10gdv 640 147337216 120
0xcfae4004 213155855 ias10gdv 640 147337216 80
0x03fad87c 213188624 icfsdev 640 505413632 17
0x2bfad4f8 213221393 mincoupg 640 239075328 40
0x9ededf88 213254162 arbdemo 640 110485504 7 locked
0xb8a5a368 213286932 aribatst 640 110354432 8 locked
0xf2076328 213319701 ccrtedev 640 110346240 8 locked
0x6f9a57c4 213385239 mincodev 640 306184192 30
0xf79d0350 213450777 apps2dev 640 38535168 6 locked
0x4f03e428 213483546 ccrlkdev 640 259690496 7 locked
0xa6ee41f4 213581853 pmtsdev 640 255852544 30
0x221a5aa8 213614622 ps89dev 640 140509184 34
0xa4be3df0 213647391 ps89dmo 640 140509184 21
0xb2ed491c 213778467 psfkd7dv 640 85065728 8 locked
0x00bffd2c 213811236 ptrdbook 640 155402240 7 locked
0xefef72b8 213844005 mincotst 640 113246208 45
0xa6e48c00 213876774 mincidev 640 142606336 85
0x6e6ecb90 213909543 falcoarc 640 169869312 13
0xbdd4e9ec 214040619 maitdev 640 30658560 7 locked
0xacf68780 214073388 metdwtst 640 113246208 40
0x520a4674 214106157 ntrandev 640 100663296 30
0x2533d1bc 214138926 psfrq7dv 640 118882304 13 locked
0x4a98c8b4 212762671 treasdev 640 165675008 7
0x00000000 28999729 root 644 151552 2 dest
0x00000000 29032498 root 644 122880 2 dest
0x00000000 29065267 root 644 790528 2 dest
0x89fe2880 214171700 psfsd7dv 640 68673536 7 locked
0x8ebfea34 214204469 ps89tst 640 119537664 22



[Updated on: Tue, 25 April 2006 16:25]

Report message to a moderator

Re: ORA-27102 out of memory and Linux Error: 28: No space left on device [message #169275 is a reply to message #169226] Wed, 26 April 2006 00:54 Go to previous messageGo to next message
madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india
Member
increase shmall to 4194304

Thanks
Madhu
Re: ORA-27102 out of memory and Linux Error: 28: No space left on device [message #169421 is a reply to message #169275] Wed, 26 April 2006 14:26 Go to previous messageGo to next message
vinman
Messages: 2
Registered: April 2006
Location: Montreal
Junior Member
Thanks for the reply.
How did you come up with this value?
Re: ORA-27102 out of memory and Linux Error: 28: No space left on device [message #454256 is a reply to message #169226] Tue, 04 May 2010 11:46 Go to previous messageGo to next message
mzainal
Messages: 54
Registered: March 2010
Location: Malaysia
Member
I also had this problem. Still cannot start my database.
Re: ORA-27102 out of memory and Linux Error: 28: No space left on device [message #454262 is a reply to message #454256] Tue, 04 May 2010 12:48 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ALWAYS
Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version

We don't know what you have.
We don't know what you do.
We don't know what you see.
use COPY & PASTE so we can see what you do & how Oracle responds.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Previous Topic: need patch 4198954
Next Topic: CRONTAB IS NOT RUNNIG MY SCRIPT ON LINUX
Goto Forum:
  


Current Time: Thu Mar 28 03:21:44 CDT 2024