My Oracle Support Banner

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

Last updated on OCTOBER 30, 2019

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
Oracle Database Exadata 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

./rda.sh -vCRP STC or
./rda.sh -vCRP OS DB DBA NET D2PC STC STM

 

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 Scripts
 How to run the script
 Interpreting the Streams Health Check script output
 Configuration
 Analysis
 Statistics
 Other information
References

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