Failed Job While Applying 11.5.10.2 Maintenance Pack .... OKCCQUET.SQL (Doc ID 459182.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Contracts - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
11.5.10.2 Maintenance Pack
Checked for Relevance on 02-Oct-2014


Symptoms

When applying 11.5.10.2 Maintenance Pack,  getting the error when running OKCCQUET.sql :

EXEC DBMS_RULE_ADM.DROP_RULE('OKC.OKC_AQ_EV_QUEUE$1',TRUE);
EXEC DBMS_RULE_ADM.DROP_RULE_SET('OKC.OKC_AQ_EV_QUEUE$1',TRUE);\

Error: Program exited with status 3
Cause: The program terminated, returning status code 3.
Action: Check your installation manual for the meaning of this code on this operating system.Connected.

declare
*
ERROR at line 1:
ORA-20000: Create queue Error (okc_aq_ev_queue) : -24062 - ORA-24062: Subscriber table
OKC.AQ$_OKC_AQ_EV_TAB_S inconsistent with queue table OKC.OKC_AQ_EV_TAB
ORA-06512: at line 15

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