ASM Is Unable To Start On AIX Due To [ORA-27102: out of memory : IBM AIX RISC System/6000 Error: 12: Not enough space] (Doc ID 1301182.1)

Last updated on FEBRUARY 14, 2013

Applies to:

Oracle Database - Standard Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.

Symptoms

After reboot the AIX box, ASM instance is unable to start due to the next errors:


$ >export ORACLE_SID=+ASM
$ > sqlplus /nolog

SQL*Plus: Release 10.2.0.5.0 - Production on Thu Mar 3 16:27:52 2011

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

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-27102: out of memory
IBM AIX RISC System/6000 Error: 12: Not enough space



1) Oracle Error description:


27102, 00000, "out of memory"
// *Cause: Out of memory
// *Action: Consult the trace file for details




2) OS error description:


$> /usr/include/sys> pwd
/usr/include/sys
$> grep 12 errno.h
#define ENOMEM 12 /* Not enough space



3) RAM was checked and it has the correct size (> 2GB):


# /usr/sbin/lsattr -HE -l sys0 -a realmem
attribute value description user_settable
realmem 6291456 Amount of usable physical memory in Kbytes False



4) Also swap area was correctly set as described in the next formula:


If RAM = 1024MB to 2048Mb
then 1.5 times RAM
elseif RAM > 2048MB and < 8192MB
then match RAM
else RAM > 8192MB
then .75 times RAM





# /usr/sbin/lsps -a
Page Space Physical Volume Volume Group Size %Used Active Auto Type Chksum
hd6 hdisk0 rootvg 8192MB 1 yes yes lv 0




5) Shared memory segments and semaphores table was not saturated:


# ipcs -a
IPC status from /dev/mem as of Thu Mar 3 17:49:14 GMT-05:00 2011
T ID KEY MODE OWNER GROUP CREATOR CGROUP CBYTES QNUM QBYTES LSPID LRPID STIME RTIME CTIME
Message Queues:
q 0 0x4107001c -Rrw-rw---- root printq root printq 0 0 4194304 0 0 no-entry no-entry 16:24:15
T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME
Shared Memory:
m 1048576 0x01000011 --rw------- pconsole system pconsole system 1 10485760 327928 327928 16:24:44 16:24:44 16:24:44
m 1048577 0x7800000b --rw-rw-rw- root system root system 1 268435456 315560 393358 16:24:41 17:39:43 16:24:41
m 1048578 0x7800000a --rw-rw-rw- root system root system 1 16777216 315560 393358 16:24:41 17:39:43 16:24:41
T ID KEY MODE OWNER GROUP CREATOR CGROUP NSEMS OTIME CTIME
Semaphores:
s 1 0x6202a5cf --ra-r--r-- root system root system 1 16:24:06 16:24:06
s 6 0xffffffff --ra------- root system root system 2 no-entry 16:24:40
s 7 0x0100d1cf --ra-ra-ra- root system root system 2 16:24:40 16:24:40
s 1048589 0x01000012 --ra------- pconsole system pconsole system 3 16:25:57 16:24:44
s 14 0x0102a41f --ra------- root system root system 1 16:24:58 16:24:58
#

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms