ORA-371 Cannot Start Database via srvctl (Doc ID 985599.1)

Last updated on MARCH 01, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.2 - Release: 10.1 to 11.2
Information in this document applies to any platform.

Symptoms

On a 2 node RAC, the instance on node 1 did not start automatically after node reboot. Using 'srvctl' to start instance gave the following error:
$ srvctl start instance -d racprdn -i racprdn1
PRKP-1001 : Error starting instance racprdn1 on node racdb1
CRS-0215: Could not start resource 'ora.racprdn.racprdn1.inst'.

The CRS resource logfile (ORACLE_HOME/log/nodename/racg/imon_RACPRDN.log) showed the following messages:
2009-12-14 10:07:28.634: [ RACG][4444] [5628][4444][ora.racprdn.racprdn1.inst]:
SQL*Plus: Release 10.2.0.3.0 - Production on Mon Dec 14 10:07:26 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Enter user-name: Connected to an idle instance.

SQL> ORA-00371: not enough shared pool memory, should be at least 1018
2009-12-14 10:07:28.634: [ RACG][4444] [5628][4444][ora.racprdn.racprdn1.inst]: 500300 bytes
SQL> Disconnected

Cause & Action for ORA-371:
00371, 00000, "not enough shared pool memory, should be atleast %s bytes"
// *Cause: Init.ora parameter shared_pool_size is too small
// *Action: Increase the parameter value

However, when starting the instance via sqlplus using pfile  initSID.ora file with following content, the instance started fine:
SPFILE='+ORADATA/RACPRDN/spfileracprdn.ora'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms