数据库启动时报ORA-27102: out of memory
SQL> startup
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
Additional information: 1543503872
Additional information: 1
解决办法:
vi /etc/sysctl.conf
需要调整/etc/sysctl.conf中的kernel.shmmax和kernel.shmall参数
kernel.shmmax# 官网建议:以字节为单位的物理内存(RAM)大小的一半或者更大
kernel.shmmax可以设置为约服务器物理内存的80%,如16G物理内存,shmmax的值可设置为1610241024102480% = 13461882265
kernel.shmall的值设置为shmmax除以操作系统页的大小
查看pagesize的大小 # getconf PAGESIZE
根据新的内存大小计算,修改/etc/sysctl.conf并执行生效sysctl -p,顺利启动数据库
SQL> startup
ORACLE instance started.
Total System Global Area 1.0088E+10 bytes
Fixed Size 2261928 bytes
Variable Size 1711279192 bytes
Database Buffers 8355053568 bytes
Redo Buffers 19595264 bytes
Database mounted.
Database opened.
成功启动!