Friday, June 22, 2012

oracle can not startup by error ORA-27102: out of memory

ISSUE:
Database was shutdown for maintenance but it can not be start up.

ERROR:

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

CAUSE: 
shmmax was not configured correctly. it also might cause by init file memory parameter or user limitation.

SOLUTION:
edit /etc/sysctl.conf
increate kernel.shmmar to physical memory minus 1


reference:

No comments:

Post a Comment