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就可以了





请使用浏览器的分享功能分享到微信等