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

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

Hi friends, Recently I am installing EHP 6.0 on one of friend system, everything goes smooth. But during the time of CREATE DATABASE process it throws following error: ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device.

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

At first it seems like some space issue, I checked all mountpoints. Every monutpoints have adequate size. Then I tried to check ORACLE Database services as at the time of error CREATE DATABASE step is running. Database is in idle state, I try to start it but fails with same error. Now I am sure that error is related to ORACLE.

I start looking every parameter, listner everything related to DB, and at finally I found that it is due a reconfigured parameter in kernel i.e. kernel.shmall. Right now it is configured to kernel.shmall=2197162 that is wrong as its value should be calculated according to your RAM and Page Size.

Formula for calculation is: 1024 * 1024 * 1024 * RAM IN GB / PAGE SIZE = RESULT

For example(64 GB RAM and 4096 Page Size)= 1024*1024*1024*64/4096=16777216

Now change this value in /etc/sysctl.conf file for kernel.shmall and use the command sysctl -p to changes to take effect.

Now start your database and you can proceed with your installation.

 

Leave a Reply

Your email address will not be published. Required fields are marked *