ORA-04031 Resulted Between Mount And Open State (Doc ID 818834.1)

Last updated on JULY 22, 2009

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.7
This problem can occur on any platform.

Symptoms

- Database was kept in mount state to take the RMAN backups.
  The following error will be seen during mount to open phase of the database.

  ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown object","
  Streams pool","fixed allocation callback")

  This error is not seen during the normal database activity

- The following call stack seen in the trace file generated
  ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- ksfdmp
  dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError <- dbgePostErrorKGE <-
  dbkePostKGE_kgsf <- kgeade <- kgesev <- kgesec5 <- kghnospc
  kghalo <- kghxal <- kwqbcqini <- kwqbconfy <- kwqinfy kscnfy

Cause

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