ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device
SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 11 22:05:53 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
Check the kernel parameter shmall in the /etc/sysctl.conf file.
The parameter shmall is the total shared memory in pages, that the system can use at one time.
Command to check the page size,
As per the Oracle,
shmall = Total_RAM/Page_Size
Change kernel.shmall = 1024 * 1024 * 1024 * RAM_Size / PAGE_Size
Edit the shmall parameter in the /etc/sysctl.conf file
For Example,
$ su – root
vi /etc/sysctl.conf file:
kernel.shmall=16777216
save the file and execute the below command to effect the changes done,
# sysctl -p