My Oracle Support Banner

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

Last updated on DECEMBER 20, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


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,
     '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


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


To view full details, 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 a vibrant support community of peers and Oracle experts.