oracle+内存错误,oracle使用内存的错误，ORA-27102: out of memory

网上参阅资料，整理到这里，以备查阅。

主要由于内存的分配问题，导致oracle数据库启动失败。

数据库关闭之后重新启动，出现下面的错误：

SQL> startup;

ORA-27102: out of memory

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

SQL> startup;

ORA-27102: out of memory

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

Cause

shmall is the total amount of shared memory, in pages, that the system can use at one time.

Solution

Set shmall equal to the sum of all the SGAs on the system, divided by the page size.

The page size can be determined using the following command:

做了如下操作，可正常启动：

vi  /etc/sysctl.conf

kernel.shmall = 2097152

kernel.shmall = 4194304(4×1024×1024)

即

kernel.core_uses_pid = 1

#kernel.shmall = 2097152

kernel.shmall = 4194304

kernel.shmmax = 5368709120

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

then run the following command:

# sysctl -p

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

kernel.shmall = 4194304

kernel.shmmax = 5368709120

kernel.shmmni = 4096

kernel.sem = 250 32000 100 12

# cat /proc/sys/kernel/shmall

4194304

参考网文：

http://yuekczy.spaces.live.com/blog/cns!139B3FC812B094AB!397.entry