ORA-00371: not enough shared pool memory

问题背景： 客户数据库起不来，通过修改pfile.ora文件启动数据库报错 ORA-00371: not enough shared pool memory 问题描述 备库实例启动到nomount 状态，报错 sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue Dec 2 09:44:26 2014 Copyright (c) 1982, 2011, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup nomount pfile='home/oracle/pfile.ora'; ORA-00371: not enough shared pool memory, should be atleast 750203385 bytes 参数文件内容 pfile.ora 解决方法 按照提示将sharepool size设置为要求的大小 pfile.ora SHARED_POOL_SIZE=750203385 原因分析 这是oracle没有公布的一个bug Bug 13606499 - PHSB: DEFAULT MEMORY PARAMETER(INIT.ORA) IS NOT BIG ENOUGH TO START A INSTANCE 该bug在12.1中修复 受影响的版本 OracleDatabase - Enterprise Edition - Version 10.1.0.2 to 11.2.0.4 [Release 10.1 to11.2] Informationin this document applies to any platform. 参考文档 文档 ID 1560386.1