oracle.jms.AQjmsException: ORA-00604: error occurred at recursive SQL level 3 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select /*+ rule */ bucket, e...","Typecheck heap","kgghteInit")

Oracle Community | 756829 | 6 years ago
  1. 0

    Workflow all down

    Oracle Community | 6 years ago | 756829
    oracle.jms.AQjmsException: ORA-00604: error occurred at recursive SQL level 3 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select /*+ rule */ bucket, e...","Typecheck heap","kgghteInit")
  2. 0

    Notification Mailer not starting.

    Oracle Community | 7 years ago | user121044
    oracle.jms.AQjmsException: ORA-04031: unable to allocate 4080 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","library cache")
  3. 0

    AQJMS Exception In B2B

    Oracle Community | 8 years ago | 622858
    oracle.jms.AQjmsException: ORA-04031: unable to allocate 4194344 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback") ORA-06512: at "SYS.DBMS_AQADM_SYS", line 5751 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_AQJMS", line 129 ORA-06512: at line 1at oracle.jms.AQjmsSession.addDurableSubscriber(AQjmsSession.java:3708)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    AQJMS Exception In B2B

    Oracle Community | 8 years ago | 622858
    oracle.jms.AQjmsException: ORA-04031: unable to allocate 4194344 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback") ORA-06512: at "SYS.DBMS_AQADM_SYS", line 5751 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_AQJMS", line 129 ORA-06512: at line 1at oracle.jms.AQjmsSession.addDurableSubscriber(AQjmsSession.java:3708)
  6. 0

    JMS/AQ: Running out of memory ORA-04031

    Oracle Community | 1 decade ago | 198189
    oracle.jms.AQjmsException: ORA-04031: kan ikke tildele 16396 byte med felles min ne (large pool,unknown object,koh-kghu sessi,static frame of inst) ORA-06512: ved "SYS.DBMS_AQJMS", line 57 ORA-06512: ved line 1

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.jms.AQjmsException

      ORA-00604: error occurred at recursive SQL level 3 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select /*+ rule */ bucket, e...","Typecheck heap","kgghteInit")

      at oracle.jms.AQjmsSession.removeSubscriber()
    2. oracle.jms
      AQjmsSession.unsubscribe
      1. oracle.jms.AQjmsSession.removeSubscriber(AQjmsSession.java:2411)
      2. oracle.jms.AQjmsSession.unsubscribe(AQjmsSession.java:2295)
      2 frames
    3. oracle.apps.fnd
      ControlListener.run
      1. oracle.apps.fnd.wf.bes.ControlConnection.unSubscribe(ControlConnection.java:209)
      2. oracle.apps.fnd.wf.bes.ControlListener.run(ControlListener.java:118)
      2 frames