Startup command fails with ORA-27102: out of memory, Linux-x86_64 Error: 28: No space left on device

advertisements

_____________________________________________________________________________________________________________________

Error Description

 

Oracle startup command fails with following error.

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
Additional information: -1879048192
Additional information: 1

Solution Description 

This is because of the wrong value of the kernel.shmall parameter in the /etc/sysctl.conf file. You can fix the issue with following steps. Step 1. Get the page_size from the unix server

 

getconf PAGE_SIZE
4096

Step 2. Check the available physical memory in the server using either free or

 

/proc/meminfo.
[root@ ~]# free
              total        used        free      shared  buff/cache   available
Mem:      263974544     1812416     1131644       48668   261030484   261780856
Swap:      20971516           0    20971516

# cat /proc/meminfo
MemTotal:       263974544 kB
MemFree:         1159820 kB

Step 3. Calculate the value for the shmall parameter using following calculation. Here in this case I have approximately 256GB. Shmall=physical memory (bytes)/page_size

256*1024*1024*1024/4096 =67108864

advertisements

 

Step 4. Update the value in vi /etc/sysctl.conf

kernel.shmall = 67108864

Step 5. apply the values using sysctl command.

sysctl -p

Now you can do the startup.

_____________________________________________________________________________________________________________________

Website Stats