My Oracle Support Banner

java.sql.SQLException: ORA-00604:& ORA-04031: Starting Workflow Components (Doc ID 1323233.1)

Last updated on SEPTEMBER 29, 2016

Applies to:

Oracle Workflow - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
Checked for relevance on 29-SEP-2016

Symptoms


Workflow mailer stopped working with the following error:

SVC-GSM-WFMLRSVC-554894-10006 : oracle.apps.fnd.cp.gsc.Logger.Logger(String, int) : Logging to System.out until necessary parameters are retrieved for Logger to be properly started.
Broken pipe
SVC-GSM-WFMLRSVC-554894-10006 : oracle.apps.fnd.cp.gsc.Logger.Logger(String, int) : Logging to System.out until necessary parameters are retrieved for Logger to be properly started.
oracle.jms.AQjmsException: JMS-120: Dequeue failed
at oracle.jms.AQjmsError.throwEx(AQjmsError.java:308)
at oracle.jms.AQjmsConsumer.dequeue(AQjmsConsumer.java:2094)
at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:922)
at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:835)
at oracle.jms.AQjmsConsumer.receive(AQjmsConsumer.java:776)
at oracle.apps.fnd.wf.bes.ControlListener.run(ControlListener.java:74)

[Linked-exception]
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select audit$,properties fro...","sql area","tmp")
Components are not able to start as they cannot allocate space in shared poo

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.