Real-Time Integration - Dropping and Recreating DB Queues

The following section provides steps for dropping and recreating DB queues.

Stop and Drop the Queues

Run the following statements to stop and then drop each RTI queue and queue table: 

 

EXECUTE dbms_aqadm.stop_queue(Queue_name => 'RTI_ERROR_Q'); 

EXECUTE dbms_aqadm.drop_queue(Queue_name => 'RTI_ERROR_Q'); 

EXECUTE dbms_aqadm.drop_queue_table(Queue_table => 'RTI_ERROR_Q_T'); 

 

EXECUTE dbms_aqadm.stop_queue(Queue_name => 'RTI_INBOUND_Q'); 

EXECUTE dbms_aqadm.drop_queue(Queue_name => 'RTI_INBOUND_Q'); 

EXECUTE dbms_aqadm.drop_queue_table(Queue_table => 'RTI_INBOUND_Q_T'); 

 

EXECUTE dbms_aqadm.stop_queue(Queue_name => 'RTI_OUTBOUND_Q'); 

EXECUTE dbms_aqadm.drop_queue(Queue_name => 'RTI_OUTBOUND_Q'); 

EXECUTE dbms_aqadm.drop_queue_table(Queue_table => 'RTI_OUTBOUND_Q_T'); 

Recreate the Queues

As user UIG, run script rtiqueue.que, which would typically be found on the server at d:\cm\v12\<environment>\uig\sql\. This script creates and enables all queues, so nothing else should need to be done.