ORA-04031: unable to allocate bytes of shared memory ("","","","")

I see the following lines continuously in the alert log. 

Fri Nov 01 04:04:14 2013
Errors in file /sw/11.2.0/admin/EBSPRD_ebsprddb01/diag/rdbms/ebsprd/EBSPRD/trace/EBSPRD_q003_9998.trc:
ORA-22303: type "SYS"."AQ$_AGENT" not found
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 256 bytes of shared memory ("shared pool","unknown object","KKSSP^774","kgllk")
Fri Nov 01 04:05:28 2013
Errors in file /sw/11.2.0/admin/EBSPRD_ebsprddb01/diag/rdbms/ebsprd/EBSPRD/trace/EBSPRD_j000_11170.trc:
ORA-12012: error on auto execute of job 340
ORA-04031: unable to allocate  bytes of shared memory ("","","","")
ORA-04031: unable to allocate  bytes of shared memory ("","","","")
ORA-04031: unable to allocate 256 bytes of shared memory ("shared pool","SCHEDULER$_CLASS","KKSSP^2525","kgllk")

Fri Nov 01 04:06:32 2013

Fri Aug 20 15:53:23 2010
Errors in file /opt/oracle/admin/w552pr/dump/bg/orcl102a_j000_14645.trc:
ORA-12012: error on auto execute of job 634953
ORA-04031: unable to allocate 39920 bytes of shared memory ("shared pool","DBMS_AQADM_SYS","PL/SQL MPCODE","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at line 1

Below note from the oracle support gives some idea about the same. 

No comments:

Post a Comment