-
Title
"ORA-04031: unable to allocate 40 bytes of shared memory" found in alert log when Oracle instance restarted -
Description
Oracle instance being monitored by Foglight restarted. Was Foglight the cause?
The following is found in the Oracle trace log
Incident 386617 created, dump file: /u01/app/oracle/diag/rdbms/INSTANCE/NODE/incident/incdir_386617/NODENAME_XXXX_124750_i386617.trc
*** SESSION ID:(251.19498)
*** CLIENT ID:()
*** SERVICE NAME:(XXXXXX)
*** MODULE NAME:(EM Realtime Connection)
*** ACTION NAME:(MetricCollector:RAC_TOP_ACT_THRE)
ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","unknown object","KGLH0^ca4d0eed","kglHeapInitialize:temp")
-
Cause
Foglight was identified by the System Administrator to not be related to the Oracle instance restart. -
Resolution
The last line of the trace file was the cause of the restart and a new trace file was created then.
The last application interacting was Oracle Enterprise Manager.
According to Oracle Metalink (Doc ID 1638733.1) this message can be expected behavior and the user should increase the shared_pool_size.