Unable To Start ASM (ORA-00838 ORA-04031) On 11.2.0.3/11.2.0.4 If OS CPUs # > 64. (Doc ID 1416083.1)

Last updated on JUNE 27, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

1) ASM 11.2.0.3/11.2.0.4 configuration on Solaris SPARC T4-4 Server with 128 CPUs & RAM = 128 GB.


2) If the 128 CPUs are enabled, then ASM instance is unable to start due to the next errors:

 

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 1328M
ORA-01078: failure in processing system parameters


 

[main] [ 2012-01-21 18:26:28.986 COT ] [UsmcaLogger.logException:174] ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","SELECT DECODE(null,'','Total...","SQLA","tmp")



3) But if only 64 CPUs are enabled, then ASM instance starts without problems.


4) On release 11.2, ASM uses Automatic Memory Management (AMM) by default,  therefore MEMORY_MAX_TARGET & MEMORY_TARGET have the default values = 272 MB (in the ASM instance):

 

MEMORY_MAX_TARGET = 272M
MEMORY_TARGET = 272M



5) And so, the SGA in the ASM instance has the same value (900 MB):

SQL> show sga

Total System Global Area  283930624 bytes
Fixed Size                  2227664 bytes
Variable Size             256537136 bytes
ASM Cache                  25165824 bytes

 

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