AQ & MGW Health Check and Configuration Script
(Doc ID 1193854.1)
Last updated on JUNE 22, 2022
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 188.8.131.52 to 184.108.40.206 [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.
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
|How to run the script|
|Interpreting AQ & MGW Configuration Script output|