This is 2 node RAC with ASM.
ASM and DB was up and running in Node 1 where as ASM start in Node 2 (11gR2)failed with ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","unknown object","KGLH0^f6c30305","kglHeapInitialize:temp").
ASM and DB was up and running in Node 1 where as ASM start in Node 2 (11gR2)failed with ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","unknown object","KGLH0^f6c30305","kglHeapInitialize:temp").
DB is configured to use Automatic Memory Management feature.
Please see below doc for AMM feature.
I Double the value for memory_target, memory_max_target to get rid of error.
Logged in second node as 'grid' user and increased the value for both parameters and started ASM in Node 1.
alter system set memory_max_target=4096m
scope=spfile;
alter system set memory_target=1024m
scope=spfile;
As it was scope=spfile new value will reflect after next Instance restart in Node 2.
No comments:
Post a Comment