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

Last updated on SEPTEMBER 28, 2021

Applies to:

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