startup ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device

近期由于公司的统计报表系统oracle load相当高，业务基本已经完了，呵呵。顺其便对
oracle相关参数进行调整，
要变更的参数如下：
sga_target
  原值：3g
  新值：20g
pga_aggregate_target
  原值：15g
  新值：4g

开始工作：
 alter system set sga_target=20g scope=spfile;
 alter system set pga_aggregate_target=4g;
然后
  shutdown immediate
最后
  startup
 报错如下：
  SQL> startup
  ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device


后经查看suse linux的相关参数配置
  Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 如无请添加以下内容，如不一致，请修正为一致

LN-STAT-WEB:/etc # more /etc/sysctl.conf

# Disable response to broadcasts.

# You don't want yourself becoming a Smurf amplifier.

net.ipv4.icmp_echo_ignore_broadcasts = 1

# enable route verification on all interfaces

net.ipv4.conf.all.rp_filter = 1

# enable ipV6 forwarding

#net.ipv6.conf.all.forwarding = 1

#add for oracle11g

kernel.shmall =8388608   -- 值一定要配置成这个(page size)

kernel.shmmax = 15618062894  --配置为物理内存一半

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 262144

fs.file-max = 6553600

sysctl -p --生效之

接着startup就可以了

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

转载于:http://blog.itpub.net/9240380/viewspace-619784/