Exadata: ORA-04031 or ORA-4030 during routine operations (Doc ID 1509795.1)

Last updated on APRIL 11, 2013

Applies to:

Oracle Exadata Hardware - Version 11.2.0.1 and later
Linux x86-64

Symptoms

Known initial indications include any of the following:

CASE A. A Production database is processing routine transactions as normal when many ORA-04030 errors occur.

CASE B. Trying to shudown an ASM instance gives an ORA-04031 error.
SQL>shutdown immediate
ORA-04031: unable to allocate 2072 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","parameter table block")


CASE C. Checking on the progress of an ASM rebalance gives ORA-04031 errors.
+ASM1>select * from gv$asm_operation;
select * from gv$asm_operation
      *
ERROR at line 1:
ORA-12850: Could not allocate slaves on all specified instances: 4 needed, 3 allocated
ORA-12801: error signaled in parallel query server P002, instance 3596
ORA-04031: unable to allocate  bytes of shared memory ("","","","")
0

CASE D.  Storage Cell manual rolling upgrade interupted by Instance terminations and ORA-04031 errors.
ORA-04031: unable to allocate 12312 bytes of shared memory ("shared pool","unknown object","KKSSP^6293","kglseshtTable").

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