ORA-27102: out of memory

一、问题描述

数据库启动时报错，如下：

[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