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

Last updated on JUNE 09, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 12.1.0.1 [Release 9.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Streams Health Check scripts provided are from 9iR2 to 12C.

How to interpret the Health Check script has been created mainly for 10GR2 and 12C outputs, but most of the information is applicable for previous releases.

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