Operating System - HP-UX
1748164 Members
3661 Online
108758 Solutions
New Discussion

Re: Not able to start up the Oracle DB.

 
Nagesh410
Occasional Contributor

Not able to start up the Oracle DB.

Dear Tech Leads,

I am not able to start up my oracle DB. Its showing the error 
ORA-27102 - out of memory

HPUX-ia64 Error: 12: Not enough space.

RAM size is 20GB.

Please guide me to resolve this issue.

1 REPLY 1
Bill Hassell
Honored Contributor

Re: Not able to start up the Oracle DB.

The error is likely errno12 or ENOMEM. Oracle is unable to get the amount of RAM that it needs. However, it is likely due to a kernel parameter that is limiting the amount of RAM that a program can request rather than a system-wide shortage. This is likely a shared memory allocation failure, a detail that Oracle fails to disclose. If the database was working OK but the size of the SGA was recently increased by your DBA, this would cause the error. 

The good news is that it is easy to fix. The kernel parameter is SHMMAX and you can see the value with:

kctune shmmax

(note: you did not specify the HP-UX version. If you are running 11.11, the command is kmtune)

Change the SHMMAX parameter to double the current value. If this allows Oracle to run, ask your DBA to let you know if further increases to SGA are planned. There is no problem in making SHMMAX much larger (10 GB for example) as it is just a limit and has no effect unless a program asks for a larger amount.



Bill Hassell, sysadmin