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 11.2.0.3 to 19.0.0.0 [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.

Purpose

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

Scope

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).