My Oracle Support Banner

AQ & MGW Health Check and Configuration Script (Doc ID 1193854.1)

Last updated on APRIL 27, 2023

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database - Enterprise Edition - Version to [Release 11.2 to 19]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.


To provide useful scripts that quickly retrieve all the information related to the Advanced Queueing (AQ) and Messaging Gateway (MGW) configuration in an Oracle database. It is needed to spool the output of the script to an spool file; the output generated is on html format.

In addition, this note provides some notes and pointers that will help to better understand the output generated.

To analyze properly an AQ issue it will be necessary to retrieve the output for all the databases involved in the AQ environment. The output generated is an html format


The AQ & MGW Configuration Script Report provides key information of the Oracle AQ & MGW environment specified in an individual Oracle database.

These scripts do not modify the AQ & MGW configuration. Each script reports important information on the setup and operation of the environment. This will provide a consistent basis upon which to understand what is happening in the environment and aid to diagnose issues.

This note is intended for anyone interested on retrieving information about current status of AQ & MGW environment in the database.

NOTE: This script checks Messaging Gateway (MGW) installation regardless if it is configured in your database or not.
If MGW is not configured in your database you will receive errors ORA-942 on output generated.
These errors are expected and can be safely ignored.
MGW is NOT required for correct behavior of Advanced Queueing (AQ).


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
 Download Script
 How to run the script
 Interpreting AQ & MGW Configuration Script output

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