Master Note for Streams Downstream Capture - 10g and 11g
(Doc ID 1264598.1)
Last updated on MARCH 12, 2021
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 Exadata Express Cloud Service - Version N/A and later Oracle Database - Enterprise Edition - Version 10.1.0.2 to 22.214.171.124 [Release 10.1 to 11.2] Oracle Database Cloud Schema Service - Version N/A and later Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.1.0.2 to 126.96.36.199
This note provides background and troubleshooting information applicable in a Streams Downstream Capture Environment . Its main purpose as a master note is to bring together reference material in a form which allows a clear understanding of what is required in the configuration as well as to where to look when there are issues. Its focus is setup and understanding relevant parameters settings which are required.
This document is intended for anyone with an interest in understanding Streams downstream capture. Where scripts details are references these are provided for reference to DBAs and Application developers. It is likely these will require modification in view of the fact that the examples presented are for illustration purposes. In order to have a better insight into how the examples work, please ensure you have read and understood the information below.
Whilst every care has been taken to ensure that the details are correct and accurate , code should be thoroughly tested to verify it is fit for intended purpose.
Please note , the approach adopted in relation to knowledge has been to improve Oracle's product documentation . Thus, relevant content in relation to downstream capture is now found in the primary reference guides for Streams ; if possible, please refer to the latest documentation :
- Streams Concepts and Administration; - Streams Replication Administrator's Guide
A useful reference in relation to downstream capture specific details is found in :Streams Configuration Best practices ; this was created with respect to 10.2 but is applicable to all later versions.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!