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

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer