Skip to main content
General

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

By December 22, 2014September 12th, 2016No Comments

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.

$cat /proc/sys/kernel/shmmax

 

Command to check the page size,

$ getconf 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

Leave a Reply

© 2020 ORACLE-SCN. All Rights Reserved.