Rac Standby Instance Crash Due To Ora-04031 (Asm Extent Pointer Array)
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.4
Information in this document applies to any platform.
a) The following error is seen in the alert log :-
ORA-4031: unable to allocate 3912 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","ASM extent pointer array")
The number of bytes that cannot be allocated is not known to be unique, the chunk however must be "ASM extent pointer array" for this article to be considered.
b) The environment is RAC related with not all of the instances open. At least one of the instances
within the environment must be MOUNTED. If all instances are open the article is not considered
appropriate. The error is also linked to ASM/Standby environments.
Further rediscovery information is not trivial due to the root cause of the base bug (see below)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms