My Oracle Support Banner

Unable To Create Queue Table - ORA-25207: enqueue failed ; ORA-03135: connection lost contact (Doc ID 2137397.1)

Last updated on MARCH 12, 2020

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

Unable to use queue table and multiple errors in db_exception_log table. Trying to create queues to run parallel jobs by multithreading.

Unable to run jobs that include queue tables or able to queue jobs Processes which using advanced queuing.

Attempting to run the Engine, which crashes with an unknown error.

In DB_EXCEPTION_LOG, see the following error messages show up from the
same time:

NOTIFICATION.INITIALIZE ERROR - Failed to create queue
table : ENG_MANAGER_OUT_Q
NOTIFICATION.INITIALIZE Error failed to create queue
table : ENG_MANAGER_IN
NOTIFICATION.INITIALIZE FAILURE: -24032 ORA-24032: object
AQ$_ENG_MANAGER_IN_S exists, index could not be created for queue table
ENG_MANAGER_IN
NOTIFICATION.INITIALIZE ERROR - Failed to create queue
table : ENG_MANAGER_IN
NOTIFICATION.INITIALIZE Error failed to create queue
table : ENG_MANAGER_OUT
NOTIFICATION.INITIALIZE FAILURE: -24032 ORA-24032: object
AQ$_ENG_MANAGER_OUT_S exists, index could not be created for queue table
ENG_MANAGER_OUT

ERROR EngineHeartBeatMonitor detected frozen PollEngineManager thread.


NOTIFICATION.LISTEN FAILURE: -3135 ORA-03135: connection lost contact
NOTIFICATION.NOTIFY FAILURE: ENQUEUE dem_appserv
NOTIFICATION.NOTIFY FAILURE: -25207 ORA-25207: enqueue failed, queue TPM.DEM_APPSERV_IN_Q is disabled from enqueueing
NOTIFICATION.NOTIFY TIMEOUT Notify notification ENG_MANAGER timeout 10

Changes

 

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
Changes
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.