Linux-x86_64 Error: 28: No space left on device Problems

Operating system version: 64-bit Linux

Database Version: Any Version

Problem description

An error is reported when the database is started after the database parameters are modified.

SQL> startup nomount

ORA-27102: out of memory

Linux-x86_64 Error: 28: No space left on device

Solution

This problem is common in linux to 64-bit. This error is reported when the SGA value is greater than the shared memory.

The shmall parameter is set in the shared object. The shmall unit is page. to convert the shmall to the memory size, you need to multiply the two values, for example, shmall = 4194304, the size of the shared memory is (4194304*4096)/(1024*1024*1024) = 16 GB.

1. The shmall method is as follows:

# Cat/proc/sys/kernel/shmall

4194304

2. We can adjust the shared memory size through the value of kernel. shmall in the/etc/sysctl. conf file.

[Root @ svr28-167 ~] # Vi/etc/sysctl. conf

Kernel. shmall = 8388608

3. We can use the following command to obtain the page size. The default value is 4 kb.

$ Getconf PAGE_SIZE

4096

4. Do not forget to make the modification take effect immediately and confirm it.

# Sysctl-p

# Cat/proc/sys/kernel/shmall

8388608