Streams Configuration Report and Health Check Script (Doc ID 273674.1)

Last updated on OCTOBER 27, 2023

Applies to:

Purpose

To provide useful scripts that quickly retrieve all the information related to the Streams configuration in an Oracle database.

In addition, this note provides some notes and pointers that will help to better understand the output generated. To analyze properly an Streams issue it will be necessary to retrieve the Health Check output for all the databases involved in the Streams environment.

For Change Data Capture setups you use the scripts in this document, but you also have the option to run <Note 983443.1> - Change Data Capture CDC Healthcheck.

Scope

This note is intended for anyone interest on retrieving information about current status of Streams environment in the database.

The Streams Configuration Report provides key information of the Oracle Streams environment specified in an individual Oracle database. This report is useful to confirm that the pre-requisites for Streams are met as well as to identify the database objects of interest for Streams.


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

Also note that alternatively and in newer releases of RDA you can get using similar information that Streams Health Check retrieve by using Oracle Streams Configuration Information module (STC).  So you can get this information by running

Details

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