首页 > 数据库技术 > 详细

4、Oracle 数据库 startup 报错:ORA-27102: out of memory

时间:2020-02-09 15:24:38      阅读:217      评论:0      收藏:0      [点我收藏+]
1、数据库启动报错: ORA-27102: out of memory
SQL> startup pfile=/db/oracle/init.ora;
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
Additional information: -268435456
Additional information: 1
2、内存不足?查看操作系统内存:
$ free -h
             total       used       free     shared    buffers     cached
Mem:          252G        23G       228G       441M       389M        18G
-/+ buffers/cache:       4.5G       247G 
Swap:          63G         0B        63G 

free:剩余228G,不应该啊。

第一反应什么参数有问题?
sga_max_target=80G
sga_target=70G
没毛病。。。


3、查看操作系统参数:
cat /etc/sysctl.conf
#kernel.shmall = 4294967296
#kernel.shmmni = 4096
#kernel.sem = 25032000100128
#net.ipv4.ip_local_port_range = 900065500
#net.core.wmem_default = 8388608
#net.core.rmem_default = 8388608
#net.core.rmem_max = 16777216
#net.core.wmem_max = 16777216
#fs.aio-max-nr = 3145728
#kernel.shmall = 4294967296
#kernel.shmall = 4294967296
#fs.aio-max-nr = 1048576
#fs.file-max = 6815744
#kernel.shmall = 2097152
#kernel.shmmax = 4294967295
#kernel.shmmni = 4096
#kernel.sem = 250 32000 100 128
#net.ipv4.ip_local_port_range = 9000 65500
#net.core.rmem_default = 262144
#net.core.rmem_max = 4194304
#net.core.wmem_default = 262144
#net.core.wmem_max = 1048576
#net.ipv4.ipfrag_high_thresh = 16777216
#net.ipv4.ipfrag_low_thresh = 15728640

kernel.shmall 发现写了四次,而生效的参数是
kernel.shmall = 2097152
删掉重复的参数,保留 kernel.shmall = 4294967296 ,sysctl -p 使参数生效。

重启数据库解决!
 

 

4、Oracle 数据库 startup 报错:ORA-27102: out of memory

原文:https://www.cnblogs.com/liuxiaoran/p/12287084.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!