I've been away for 2 weeks vacation and have returned to a situation where a server blue-screened and was rebuilt by IT and a consultant (and guess what - they have no docs or record of how they did it!). Anyway, they restored one of our DBs which keeps crashing now.

The application that uses it 'records' errors as they occur, but these do not appear in the alert log or any trace files so I'm completely stumped as to 'where' they're coming from.

The shared memory issue? We never had problems before with the Shared Pool size (ie no errors indicating a memory error). I'm loathe to just upping the SHARED_POOL_SIZE without knowing what the real cause of this problem is. Any ideas?

ORA-04031: unable to allocate 4200 bytes of shared memory ('shared pool','unknown object','sga heap','state objects')

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4176 bytes of shared memory ('shared pool','STREAM_PERMISSIONS_VW','sga heap','library cache')

ORA-04031: unable to allocate 4200 bytes of shared memory ('shared pool','SELECT * FROM LABEL_VERSION_...','sga heap','library cache')

ORA-04031: unable to allocate 4200 bytes of shared memory ('shared pool','unknown object','sga heap','state objects')

ORA-04031: unable to allocate 4200 bytes of shared memory ('shared pool','unknown object','sga heap','state objects')

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level 2

ORA-04031: unable to allocate 4168 bytes of shared memory ('shared pool','SYN$','sga heap','state objects')

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level %s

ORA-04031: unable to allocate 4176 bytes of shared memory ('shared pool','SELECT * FROM LABEL_DETAILS_...','sga heap','library cache')

ORA-04031: unable to allocate 4200 bytes of shared memory ('shared pool','SELECT * FROM LABEL_DETAILS_...','sga heap','library cache')

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level %s

ORA-04031: unable to allocate %s bytes of shared memory ('%s','%s','%s','%s')

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4176 bytes of shared memory ('shared pool','select type#,blocks,extents,...','sga heap','library cache')

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4176 bytes of shared memory ('shared pool','DOCUMENT','sga heap','library cache')

ORA-04031: unable to allocate 4096 bytes of shared memory ('shared pool','STANDARD','PL/SQL MPCODE','BAMIMA: Bam Buffer')

ORA-06508: PL/SQL: could not find program unit being called

ORA-06512: at 'ALPLADMIN.ERROR_LOG_SEQ_TRG', line 6

ORA-04088: error during execution of trigger 'ALPLADMIN.ERROR_LOG_SEQ_TRG'

ORA-00604: error occurred at recursive SQL level %s

ORA-04031: unable to allocate 4200 bytes of shared memory ('shared pool','unknown object','sga heap','state objects')

ORA-00604: error occurred at recursive SQL level 2

ORA-04031: unable to allocate 4168 bytes of shared memory ('shared pool','VIEW$','sga heap','state objects')

ORA-04031: unable to allocate 4176 bytes of shared memory ('shared pool','SELECT * FROM LABEL_DETAILS_...','sga heap','library cache')

ORA-04031: unable to allocate 4176 bytes of shared memory ('shared pool','SELECT * FROM LABEL_DETAILS_...','sga heap','library cache')

ORA-04031: unable to allocate 4200 bytes of shared memory ('shared pool','SELECT * FROM LABEL_DETAILS_...','sga heap','library cache')

ORA-04031: unable to allocate 4200 bytes of shared memory ('shared pool','SELECT * FROM STREAM_PERMISS...','sga heap','library cache')

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4176 bytes of shared memory ('shared pool','LABEL_DETAILS_VW','sga heap','library cache')

ORA-04031: unable to allocate 4200 bytes of shared memory ('shared pool','unknown object','sga heap','state objects')

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level 2

ORA-04031: unable to allocate 4168 bytes of shared memory ('shared pool','OBJAUTH$','sga heap','state objects')

ORA-04031: unable to allocate 4176 bytes of shared memory ('shared pool','SELECT * FROM LABEL_DETAILS_...','sga heap','library cache')

ORA-04031: unable to allocate 4176 bytes of shared memory ('shared pool','SELECT * FROM LABEL_DETAILS_...','sga heap','library cache')

ORA-04031: unable to allocate 4200 bytes of shared memory ('shared pool','SELECT * FROM LABEL_DETAILS_...','sga heap','library cache')

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level 2

ORA-04031: unable to allocate 4168 bytes of shared memory ('shared pool','VIEW$','sga heap','state objects')

ORA-00604: error occurred at recursive SQL level %s

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4176 bytes of shared memory ('shared pool','LABEL_DETAILS_VW','sga heap','library cache')

ORA-04031: unable to allocate 4176 bytes of shared memory ('shared pool','SELECT * FROM LABEL_DETAILS_...','sga heap','library cache')