一、问题描述
数据库启动时报错,如下:
[oracle@tpcds01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 31 22:52:00 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
Additional information: -150994944
Additional information: 1
二、问题解决思路
参考文档:
Upon startup of Linux database get ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device (Doc ID 301830.1)
经分析,该数据库kernel.shmall设置值为 2097152,设置值较小。需按照support文档参考值进行调整。
三、问题解决办法
[root@tpcds01 oradb]# echo "4194304" > /proc/sys/kernel/shmall
[root@tpcds01