Database - RAC/Scalability (MOSC)

MOSC Banner

ORA-04031 Error reported by ASM.

edited Aug 14, 2017 8:42AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center