ORA-27102: out of memory

SQL> startup nomount pfile='/u01/ss.ora';
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device


启库遇到这个错,遇到鬼一样.


把 sysctl.conf 文件删除了，按官方文档建一个新的


fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
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




再启库
SQL> startup nomount pfile='/u01/ss.ora';
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device


开始怀疑人生.


后来发现
kernel.shmall = 2097152  这个参数




SQL> select 2097152 /1024/1024 from dual;


2097152/1024/1024
-----------------
                2


貌似有些小.修改与kernel.shmmax 一样大


sysctl -p


SQL> startup nomount pfile='/u01/ss.ora';
ORACLE 例程已经启动。


Total System Global Area 1.2827E+10 bytes
Fixed Size                  2240344 bytes
Variable Size            1811939496 bytes
Database Buffers         1.1006E+10 bytes
Redo Buffers                7335936 bytes




再次启库,发现人生又出现了光明