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

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

ITPub博客

ORA-27102: out of memory

最新文章