Out of Memory

[Sylvie Vezina]

Hi,
I'm trying to startup Oracle database and I received this error msg:
SVRMGR> startup
ORA-27102: out of memory
HP-UX Error: 12: Not enough space
I performed a swapinfo:
#swapinfo
Kb Kb Kb PCT START/ Kb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4145152 0 4145152 0% 0 - 1 /dev/vg00/lvol2
reserve - 3100312 -3100312

Could you help me on this?

[Jean-Louis Phelix]

Hi,

I'm not an Oracle expert, but I think that your sga could be too big. I think that it could be related to parameters in tour initX.ora file.

Regards.

[John Palmer · Accepted solution]

Are you using 32 bit Oracle? If so, you're probably hitting the 1.75Gb limit for default shared memory.

You can check shared memory segments with ipcs -am (look at the SEGSZ column).

You can get around this by utilising Memory Windows (providing your are using HP-UX 11.00 or later). Search the forums for 'memory windows'.

Regards,
John

[A. Clay Stephenson]

Errno 12 (ENOMEM) typically is a result of maxdsiz (or its 64-bit cousin, maxdsiz_64bit) being set too small. This may also mean that shmmax needs to be increased. Finally, it may indicate that while the limits have not been reached there is no contigious memomy chunk available to grant the allocation request. Check these kernel parameters and then rebuild the kernel if needed.