My Oracle Support Banner

Master Note for Troubleshooting Advanced Queuing and Oracle Streams Propagation Issues (Doc ID 233099.1)

Last updated on MARCH 15, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.0 to 12.1.0.1 [Release 8.1.7 to 12.1]
Oracle Database Cloud Schema 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
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This document presents a step-by-step methodology for troubleshooting and resolving problems with propagation in both Streams and basic Advanced Queuing environments. It also serves as a master reference for other more specific notes on Oracle Streams Propagation and Advanced Queuing Propagation issues.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

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


In this Document
Purpose
Troubleshooting Steps
 1. Scope and Application
 2. Definitions and Classifications
 2.1. What Type of Propagation is Being Used?
 2.1.1. Buffered Messaging
 2.1.2. Propagation mode – queue-to-dblink vs queue-to-queue
 2.1.3. Combined Capture and Apply (CCA) for Streams
 2.2. Queue Table Compatibility
 2.3. Single vs Multiple Consumer Queue Tables
 3. How to Use This Guide
 3.1. Are Messages Being Propagated at All, or is the Propagation Just Slow?
 3.2. Propagation Between Persistent User-Created Queues
 3.3. Propagation Between Buffered User-Created Queues
 3.4. Propagation between Oracle Streams Queues (without Combined Capture and Apply (CCA) Optimization)
 3.5. Propagation between Oracle Streams Queues (with Combined Capture and Apply (CCA) Optimization)
 3.6. Messaging Gateway Propagations
 4. Basic AQ Propagation Troubleshooting
 4.1. Double-check Your Code
 4.2. Verify that Job Queue Processes are Running
 4.2.1. Versions 10.2 and Lower – DBA_JOBS Package
 4.2.1.1. Job Queue Processes in Initalization Parameter File
 4.2.1.2. Job Queue Processes in Memory
 4.2.1.3. OS PIDs Corresponding to Job Queue Processes
 4.2.2. Version 11.1 and Above – Oracle Scheduler
 4.2.2.1. Job Queue Processes in Initalization Parameter File
 4.2.2.2. Job Queue Processes in Memory
 4.2.2.3. OS PIDs Corresponding to Job Queue Processes
 4.3. Check the Alert Log and Any Associated Trace Files
 4.3.1. Errors Related to Incorrect Network Configuration
 4.4. Check the Database Links Exist and are Functioning Correctly
 4.5. Has Propagation Been Correctly Scheduled?
 4.6. Is the Schedule Executing but Failing to Complete?
 4.7. Do the Propagation Notification Queue Table and Queue Exist?
 4.8. Does the Remote Queue Exist and is it Enabled for Enqueueing?
 4.9. Do the Target and Source Database Charactersets Differ?
 4.10. Check the Queue Table Type Agreement
 4.11. Enable Propagation Tracing
 4.11.1. System Level
 4.11.2. Attaching to a Specific Process
 4.11.3. Further Tracing
 5. Additional Troubleshooting Steps for AQ Propagation of User-Enqueued and Dequeued Messages
 5.1. Check the Privileges of All Users Involved
 5.2. Verify Queue Payload Types
 5.3. Check Message State and Destination
 6. Additional Troubleshooting Steps for Propagation in an Oracle Streams Environment
 6.1. Is the Propagation Enabled?
 6.2. Check Propagation Rule Sets and Transformations
 6.3. Determining the Total Number of Messages and Bytes Propagated
 6.4. Check Buffered Subscribers
 6.5. Common Streams Propagation Errors
 6.5.1. ORA-02082: A loopback database link must have a connection qualifier.
 6.5.2. ORA-25307: Enqueue rate too high. Enable flow control
 6.5.3. ORA-25315 unsupported configuration for propagation of buffered messages
 6.5.4. ORA-600 [KWQBMCRCPTS101] after dropping / recreating propagation
 6.5.5. Stopping or Dropping a Streams Propagation Hangs
 6.6. Streams Propagation-Related Notes for Common Issues
 7. Performance Issues
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.