ORA-04031: unable to allocate 32 bytes of shared memory

Document ID : KB000087577
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
ORA-04031: unable to allocate 32 bytes of shared memory

Symptoms

First, The AE server becomes unresponsive.
No connections can be established : no GUI connection and agents lose their connections as well.

0EMb0000001Qe7T.png

Second, server processes (CP and WP) crash immediately after startup.


Investigation

The error message 'ORA-04031: unable to allocate 32 bytes of shared memory' appears in the CP and WP logs.
It is not possible to connect to the database with a client such as SQL Developer for instance either. The error 'ORA-04031: unable to allocate 32 bytes of shared memory' is immediately displayed.


Resolution

This is an Oracle error : http://www.dba-oracle.com/t_ora_04031_unable_to_allocate_shared_memory.htm
Please contact a DBA in order to fix this.
Cause:
Cause type:
Other
Root Cause: Oracle
Resolution:
This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Status: No Fix

Additional Information:
Workaround :
N/A