近期由於公司的統計報表系統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就可以了

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

相關文章