近期由于公司的统计报表系统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博客

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

最新文章