ORA-04031 Error reported by ASM.
hello all,
i need solution for our main database. last week when we need to add some disk to asm using asmca we get error :
ORA-04031: unable to allocate 1061464 bytes of shared memory ("large pool","unknown object","large pool","kfr redo buffer")
as fyi here is our database configuration :
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> show parameter
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string ORADATA, ORAINDEX, ARCHIVE, RE
DOLOG, GAORADATA, GAORAINDEX,
GAARCHIVE, GAREDOLOG, GAIMFTRE
DO, GAIMFTDATA, GAIMFTINDEX, M
IHISDATA, MIHISINDEX, MIODSDAT
A, MIODSINDEX, MIOMWDATA, MIOM