Starting Workflow Generates ORA-04068 Error with Debug Service Manager Stuck Activating (Doc ID 383096.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Concurrent Processing - Version 11.5.9 to 11.5.10.0 [Release 11.5]
Oracle Workflow Cartridge - Version 11.5.9 to 11.5.10.0 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 25-Mar-2013***

Symptoms

When attempting to start the Workflow Mailer, an error is generated:

java.sql.SQLException: ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "APPS.FND_SVC_COMPONENT" has been invalidated
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

After checking the services, discover the Debug Service Manager is stuck in Activating. 
Review the FNDSMxx.mgr log file and there is an error:

The SQL statement being executed at the time of the error was: begin
FND_CP_GSM_IPC.Cartridge_Init_Service(:h, :p, :d); end; and was executed from the file &ERRFILE.
The call to function StartProcess in cartridge AQCART has failed.
03-AUG-2006 15:19:09 - ORACLE error 25207 in init_service

Cause: init_service failed due to ORA-25207: enqueue failed, queue APPLSYS.FND_CP_GSM_IPC_AQ is
disabled from enqueueing
ORA-06512: at "APPS.FND_CP_GSM_IPC", line 178
ORA-06512: at line 1.

Changes

Bounced the database.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms