ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device
Solution:
Check the page size:
#getconf PAGE_SIZE
4096
Calculate proper value for shmall:
The value of shmall should be:
Shmall=total size of the SGAs on the system/page size.
Let’s assume the size of the SGA is 16GB in the system then it would be 1024 * 1024 * 1024 * 16 / 4096 = 4194304
Change shmall in /etc/sysctl.conf
vi /etc/sysctl.conf
kernel.shmall = 4194304
Apply the changes:
# sysctl -p
check shmall value after change
# sysctl -A | grep shmall
Start the database
# su - oracle
# sqlplus sys as sysdba
SQL> startup