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


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

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
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. 



Post a Comment Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google