My Oracle Support Banner

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

Last updated on FEBRUARY 16, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


1) ASM 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):



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



To view full details, sign in with your My Oracle Support account.

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

In this Document
 Community Discussions

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.