CAPTURE Processes ABORTED, Queue INVALID, PROPAGATION RETURNS ORA-4063 (Doc ID 1313002.1)

Last updated on SEPTEMBER 10, 2015

Applies to:

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

Symptoms

Capture Process:

col capture_name HEADING 'Capture|Name' format a30 wrap
col status HEADING 'Status' format a10 wrap

col QUEUE HEADING 'Queue' format a25 wrap
col RSN HEADING 'Positive|Rule Set' format a25 wrap
col RSN2 HEADING 'Negative|Rule Set' format a25 wrap
col capture_type HEADING 'Capture|Type' format a10 wrap
col error_message HEADING 'Capture|Error Message' format a60 word
col logfile_assignment HEADING 'Logfile|Assignment'
col checkpoint_retention_time HEADING 'Days to |Retain|Checkpoints'
col Status_change_time HEADING 'Status|Timestamp'
col error_number HEADING 'Error|Number'
col version HEADING 'Version'

SELECT capture_name, queue_owner||'.'||queue_name QUEUE, capture_type, status,
rule_set_owner||'.'||rule_set_name RSN, negative_rule_set_owner||'.'||negative_rule_set_name RSN2,
checkpoint_retention_time,
version, logfile_assignment,error_number, status_change_time, error_message
FROM DBA_CAPTURE;



Propagation:

COLUMN 'Source Queue' FORMAT A39
COLUMN 'Destination Queue' FORMAT A39
COLUMN PROPAGATION_NAME HEADING 'Propagation' FORMAT A35
column queue_to_queue HEADING 'Q-2-Q'
column error_message HEADING 'Error Message'
column error_date HEADING 'Error Date'

SELECT p.propagation_name, p.SOURCE_QUEUE_OWNER ||'.'||
p.SOURCE_QUEUE_NAME ||'@'||
g.GLOBAL_NAME "Source Queue",
p.DESTINATION_QUEUE_OWNER ||'.'||
p.DESTINATION_QUEUE_NAME ||'@'||
p.DESTINATION_DBLINK "Destination Queue",
p.queue_to_queue,
p.status,
p.error_date,
p.error_message
FROM DBA_PROPAGATION p, GLOBAL_NAME g;



Capture Queue / Propagation Source Queue:

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



- Capture processed has a status of ABORTED/DISABLED
- Propagation could have a status of  DISABLED
- Capture queue/Propagation Source queue has a status of INVALID
- <QUEUE_NAME>_R RULE SET is also 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


Stopping or starting the queue returns ORA-04063.

Changes

Administration was performed on the streams environment ( Adding Tables to the Environment, Dropping Streams  Processes, Adding/Dropping Rules/Rule Sets, 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