My Oracle Support Banner

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

Last updated on JANUARY 30, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.2.0.1.0 [Release 10.2 to 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - 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).

Details

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

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