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
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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")

    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