一,问题描述
,,,,,甲骨文数据库在修改SGA后,启动时报错ora - 27102:记忆,这很显然表示超出了内存范围,但是机器内存是够的,这是为什么呢?通过一系统搜索,最终发现是操作系统参数shmall设置过小影响了,shmall参数是全部允许使用的共享内存大小。下面实验一下,看看小小参数的魅力。
二、实验
1 .检查环境[root@sam ~] #, free - m ,,,,,,,,,,,,total ,,,,,, used ,,,,,, free ,,,, shared ,,, buffers ,,,缓存 Mem:,,,,,,,,,, 1993,,,,,,, 1590,,,,,,,, 403,,,,,,,,,, 0,,,,,,,,, 47岁,,,,,,,,752 -/+,缓冲/缓存:,,,,,,,,790,,,,,,,1203 交换:,,,,,,,,,4095,,,,,,,,,,0,,,,,,,4095 (root@sam ~) #, uname a Linux sam 2.6.39-400.17.1.el6uek.x86_64 # 1, SMP Fri Feb 22, 18:16:18 PST 2013年,x86_64 x86_64 x86_64 GNU/Linux (oracle@sam ~),美元cat /etc/sysctl.conf | grep shmall #,oracle-rdbms-server-11gR2-preinstall setting for kernel.shmall is 1073741824,提醒x86_64 #,oracle-rdbms-server-11gR2-preinstall setting for kernel.shmall is 2097152,提醒i386 时间=kernel.shmall 1073741824
2。将该值调小至107374
[root@sam ~] #, sed 小姐;& # 39;s/kernel.shmall =, 1073741824/kernel.shmall =, 107374/舌鳎# 39;/etc/sysctl.conf (root@sam ~) #, cat /etc/sysctl.conf | grep shmall #,oracle-rdbms-server-11gR2-preinstall setting for kernel.shmall is 1073741824,提醒x86_64 #,oracle-rdbms-server-11gR2-preinstall setting for kernel.shmall is 2097152,提醒i386 kernel.shmall 107374年=,之前3。检查SGA参数后,重新启动数据库
,SYS@orcl 的在show parameter sga NAME ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, TYPE ,,,,,,,的值 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -,- - - - - - - - - - -安康;- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - lock_sga ,,,,,,,,,,,,,,,,,,,,,,,,,,,, boolean ,,,,假的 pre_page_sga ,,,,,,,,,,,,,,,,,,,,,,,, boolean ,,,,假的 sga_max_size ,,,,,,,,,,,,,,,,,,,,,,,, big integer 800米 sga_target ,,,,,,,,,,,,,,,,,,,,,,,,,, big integer 0 SYS@orcl 祝辞shutdown 立即 Database 关闭。 Database 下马。 ORACLE instance shut 下来。4。使修改后的参数生效
[root@sam ~] #, 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 net.ipv4.tcp_syncookies =1 net.bridge.bridge-nf-call-ip6tables =0 net.bridge.bridge-nf-call-iptables =0 net.bridge.bridge-nf-call-arptables =0 kernel.msgmnb =65536 kernel.msgmax =65536 fs.file-max =6815744 kernel.sem =, 250, 32000, 100, 128 kernel.shmmni =4096 kernel.shmall =107374 kernel.shmmax =2147483648 net.core.rmem_default =262144 net.core.rmem_max =4194304 net.core.wmem_default =262144 net.core.wmem_max =1048576 fs.aio-max-nr =1048576 时间=net.ipv4.ip_local_port_range 9000年,65500年5。修改SGA参数为1 g后启动数据
,SYS@orcl 的在启动 ora - 27102: out of 内存 错误:Linux-x86_64 28: No space left 提醒装置 Additional 信息:1 - 1061158912 Additional 信息:1,6。将系统参数shmall修改回源值并生效
null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null【错误】ora - 27102:内存不足解决方法
