Exadata: ORA-04031 or ORA-4030 during routine operations
(Doc ID 1509795.1)
Last updated on JANUARY 29, 2019
Applies to:Oracle Exadata Hardware - Version 22.214.171.124 and later
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.
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").
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!