Apply Processes ABORTED, Queue INVALID, START/STOP returns ORA-04063 (Doc ID 1303707.1)

Last updated on SEPTEMBER 13, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Apply Processes:

    

col apply_name format a25 wrap heading 'Apply|Name'
     col queue format a25 wrap heading 'Queue|Name'
     col apply_tag format a7 wrap heading 'Apply|Tag'
     col ruleset format a25 wrap heading 'Rule Set|Name'
     col apply_user format a15 wrap heading 'Apply|User'
     col apply_captured format a15 wrap heading 'Captured or|User Enqueued'
     col RSN HEADING 'Positive|Rule Set' format a25 wrap
     col RSN2 HEADING 'Negative|Rule Set' format a25 wrap
     col apply_database_link HEADING 'Remote Apply|Database Link' format a25 wrap

     select apply_name,queue_owner||'.'||queue_name QUEUE, status from DBA_APPLY;

     Select apply_name,queue_owner||'.'||queue_name QUEUE,
     DECODE(APPLY_CAPTURED,
     'YES', 'Captured',
     'NO', 'User-Enqueued') APPLY_CAPTURED,status,
     apply_user, apply_tag, rule_set_owner||'.'||rule_set_name RSN,
     negative_rule_set_owner||'.'||negative_rule_set_name RSN2,
     apply_database_link from DBA_APPLY;



Apply Queue:

   

    select object_name, object_type, status, owner from dba_objects
       where object_name like '%<QUEUE_NAME>%';




Apply processed ABORTED/DISABLED and Apply queue INVALID.

exec dbms_aqadm.stop_queue
exec dbms_aqadm.start_queue

*
ERROR at line 1:
ORA-04063: <QUEUE>  has errors
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4932
ORA-06512: at "SYS.DBMS_AQADM", line 240
ORA-06512: at line 1



Changes

Administration was performed on the streams environment ( Creating Apply processes, Adding Tables to the Environment, Dropping Apply Processes, etc. )

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