ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle使用内存的错误,ORA-27102: out of memory

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

原创 Linux操作系统 作者:it_newbalance 时间:2011-05-06 16:52:48 0 删除 编辑

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

主要由于内存的分配问题,导致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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24558279/viewspace-694636/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-28

  • 博文量
    143
  • 访问量
    704543