Shulou(Shulou.com)06/01 Report--

Oracle startup encounter ORA-27102: out of memory how to do, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

OS: linux 2.6.9-103.ELsmp # 1 SMP

DB: 10205, 4-node RAC

Background:

Node 1 restarted maintenance a few days ago, two of the three instance were up, and the third TEST03N1 kept reporting errors when it started.

$$ORACLE_HOME/bin/sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0-Production on Mon Sep 16 04:30:06 2013

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL > startup nomount

ORA-27102: out of memory

Linux-x86_64 Error: 28: No space left on device

Diagnostic ideas:

The first thing that comes to mind is that the shared memory is running out.

$ipcs-a

-Shared Memory Segments-

Key shmid owner perms bytes nattch status

0xa637e870 0 oracle 640 132120576 17

0x00000000 131073 oracle 660 4297064448 1 dest

0x09c77ebc 229378 oracle 660 4297064448 36

0x9b377f58 262147 oracle 640 4297064448 38

According to the number of current instance processes, the first line belongs to ASM, the last two are the other two instance, and the second line is not occupied, which should be caused by the failure of linux to reclaim the shared memory segment when TEST03N1 is closed.

$cat / proc/sys/kernel/shmmax

12884901888

$cat / proc/sys/kernel/shmall

4194304

The PAGESIZE is 4K, and the maximum allowed shared memory is 41943044096 = 17179869184. Currently, it has occupied 429706444831323313920, leaving 4156555264 = 3964m.

And TEST03N1's SGA_MAX_SIZE/SGA_TARGET=4G, so it will be reported to out of memory.

And ipcrm doesn't work.

$ipcrm-m 131073

After a series of tests, the maximum SGA_MAX_SIZE/SGA_TARGET allowed to be set is 3952m.

Shared memory segment usage at this time

$ipcs-a

-Shared Memory Segments-

Key shmid owner perms bytes nattch status

0xa637e870 0 oracle 640 132120576 17

0x00000000 131073 oracle 660 4297064448 1 dest

0x09c77ebc 229378 oracle 660 4297064448 40

0x9b377f58 262147 oracle 640 4297064448 40

0x7ede1a40 557060 oracle 640 4146069504 43

There is about 10m left.

SQL > select to_char (17179869184-4297064448003-132120576-4146069504) from dual

TO_CHAR (

-

10485760

SQL > select 10485760 Universe 1024 from dual

10485760/1024/1024

-

ten

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.