Oracle 11g: Implement Streams Release 2

Course Fees: $6390.00 excl. GST
Printed Manual: $160.00 excl. GST
Course Duration: 5 days
Course Manual

Sorry, no course dates found

The Oracle Database 11g: Implement Streams course is a hands-on introduction for Streams Administrators, DBAs and others who need to know how to share data and messages between schemas, applications, and Oracle databases which can be continents apart.

This course begins with “Guided Configurations”, both in Oracle Enterprise Manager and via command line (using PL/SQL packages). The second unit addresses “Manual Configurations”, which is followed by “Customizing your Configurations” with transformations and apply handlers.

The unit on “Extending Streams” includes topics such as Configuring Downstream Capture, Synchronous Captures, XStream, and extending the Streams configuration automatically, with a single MAINTAIN procedure or wizard, or by adding components individually in multiple steps.

The last unit on “Managing and Monitoring Streams” includes the split-and-merge functionality, analyzing and avoiding data conflicts, comparing data, best practices and troubleshooting guidelines. The appendices can be used to address additional customer needs, such as Advanced Queueing (AQ).

This course is based on Oracle Database 11g Release 2.

Learn To:
  • Setup and configure a Streams environment
  • Administer and customize a Streams environment
  • Manage data conflicts
  • Monitor and troubleshoot a Streams environment
  • Database Administrators
  • Sales Consultants
  • Support Engineer
  • Technical Consultant
  • Technical Administrator
Oracle 11gR2 Administration Workshops 1 & 2
  • Perform basic troubleshooting of a Streams environment
  • Alter the Streams environment to add, modify and drop new sites or objects
  • Configure conflict handling for data replication
  • Transform the data being replicated between two sites
  • Enqueue and dequeuq messages using Oracle Streams
  • Monitor the capture, propagation, and apply of events
  • Quickly and easily configure an Oracle Streams environment

Oracle Streams: Overview

  • Streams: Overview
  • What Is Oracle Streams?
  • Configuring Communication Between Databases
  • Identifying Streams Processes
  • Oracle Streams Database Configuration
  • Example Streams configurations

Configuring Simple Streams Replication

  • Configuring Replication using Enterprise Manager
  • Viewing the Configuration Progress & Troubleshooting the Configuration Procedures
  • Replicating a Single Tablespace, a Set of Tablespaces, an Entire Database, Schemas & Tables
  • MAINTAIN_* Procedures: Overview
  • Overview of Replication Configuration Steps
  • Configuration Decisions, Prerequisite Steps & Instantiation Options
  • Ways to set up Oracle Streams
  • Removing Oracle Streams Components

Customizing Streams with Rules

  • Monitoring System-Created Rules & Negative Rule Sets
  • Using Subset Rules with Oracle Streams
  • Generating System-Created Rules
  • Customizing System-Created Rules & Negative Rule Sets
  • Rule Evaluation with Rule Sets
  • Creating Negative Rules
  • Using Rules in Oracle Streams
  • Creating Subset Rules & Row Subsetting

Capture Process: Concepts and Manual Configuration

  • Capture & Redo-Based Capture
  • Limiting Captured Messages & Streams Tags
  • Types of changes captured & not captured
  • Capture Process: Components
  • Streams Support for Transparent Data Encryption
  • Identifying Changes to Capture & Data Types Captured
  • Wallet Management
  • Capture Process Architecture & Creating and managing the Capture Process


  • Performing Instantiation
  • Removing Instantiation Information
  • Viewing Information About Instantiation & Verifying Instantiations at an Apply Site
  • Instantiation SCN
  • Instantiation Using Data Pump
  • Preparing for Instantiation
  • What Is Instantiation?
  • Setting the Instantiation SCN

Propagation Concepts and Manual Configuration

  • How Does Propagation Work?
  • Queue-to-Queue Propagation
  • What is Propagation?
  • Manually Creating a Propagation
  • Queue-to-Queue Propagation and Real Application Clusters
  • Guaranteed Message Delivery
  • Managing & Monitoring Propagations
  • Directed Networks, Queue Forwarding & Apply Forwarding

Apply Concepts and Manual Configuration

  • Querying the Data Dictionary
  • What is Apply?
  • Apply Process and Column Discrepancies
  • Applying DDL Messages
  • Managing & Checking the Apply Process
  • Applying Messages & Error Queue
  • Processing Streams Messages
  • Creating, Modifying & Managing the Apply Process


  • Custom Rule-Based Transformations
  • Managing Custom Rule-Based Transformations
  • Declarative LCR Transformations
  • Using LCR Extra Attributes
  • Rule-Based Transformations and Capture, Propagation & Apply
  • Creating a Custom Rule-Based Transformation
  • Viewing Rule-Based Transformations
  • Modifying an LCR

Apply Handlers

  • Message Processing
  • Implementing a DML Handler
  • Creating an Apply Handler Procedure
  • Implementing LOB Assembly
  • Recording Table Changes
  • Viewing Change Table Handler Information
  • Apply Handlers for LCR Messages
  • Statement DML Handler Type

Configuring Downstream Capture

  • Prerequisites for Downstream Capture
  • Creating a Downstream Capture Process with a Database Link & Without a Database Link and with the MAINTAIN Procedure
  • Monitoring Log File Availability
  • Real-Time Downstream Capture
  • Configuring Downstream Initialization at the Destination Database
  • Monitoring Downstream Capture Processes
  • Configuring Log Transport Services at the Source Database
  • Configuring Standby Logs at the Destination Database

Configuring Synchronous Capture

  • Managing and Monitoring Synchronous Capture
  • Synchronous Capture
  • Captured Data Types & Captured Changes
  • Configuring Oracle Streams for Synchronous Capture
  • Configuring Synchronous Capture

Extending the Streams Environment

  • Using Streams API for Rolling Database Upgrades or Migrations
  • Preinstantiation Steps for Rolling Upgrade
  • Automatic Extension of OracleStreams: Adding New Shared Objects
  • Final Configuration for a Populated Database & an Import Database
  • Adding Objects to a Multiple-Source System
  • Creating a New Streams Site by Using RMAN
  • Adding a New Destination to a Single-Source System
  • Adding a Table to a Single or Multiple Source System

Configuring and Using XStream

  • Position Order in an LCR Stream
  • Configuring an Outbound Server
  • Configuring an Inbound Server
  • Heterogeneous Data Sharing using Oracle Streams
  • XStream Out and XStream In
  • XStream in Action – An Example
  • XStream Architecture
  • Monitoring XStream

Splitting and Merging of Streams Destination

  • Splitting and Merging of Streams
  • New Data Dictionary Views
  • When to Think about Split and Merge
  • Manual Splitting and Merging of Streams
  • Automatic Split and Merge Functionality

Avoiding Data Conflicts

  • Types of Data Conflicts
  • Data Consistency and Convergence
  • Avoiding Conflicts by Assigning Data Ownership
  • Suppressing Conflict Detection & Cascading Delete Operations
  • Specifying Substitute Key Columns
  • Error Queue
  • Conflict Avoidance and Resolution Foundation
  • What Is a Replication Conflict?

Conflict Resolution

  • Resolving Conflicts with Prebuilt Update Conflict Handlers & Custom Conflict Handlers
  • Using Procedures to Execute LCRs
  • Viewing Apply Errors & Error Transaction Information
  • Viewing Conflict Resolution Information
  • Prebuilt Conflict Handlers
  • Resolution Columns
  • Printing Values from a SYS.AnyData Type
  • Configuring Supplemental Logging

Comparing and Converging Data

  • Rechecking the Results for a Comparison
  • Converging Database Objects
  • Viewing & Purging Comparison Results
  • Converging a Shared Database Object with a Session Tag Set
  • Viewing the Differences in Data
  • Creating & Performing Comparisons
  • Identifying the Rows That Differ
  • Comparing Table Data

Best Practices and Operations Considerations

  • Removing Unnecessary Archived Log Files
  • Best Practices for Streams Database Operation & Captured Messages
  • Clock Synchronization
  • Best Practices for Performing Backups of Your Streams Environment
  • Source Queue Growth
  • Sharing & Purging LogMiner Data Dictionaries
  • Best Practices for Streams Database Configuration
  • Altering FIRST_SCN for a Capture Process

Monitoring Oracle Streams

  • Monitor Capture Statistics, Propagation Statistics & Apply Statistics
  • Monitoring Tools
  • Message Tracking & Automated Alerts
  • Responding to Automated Alerts in Enterprise Manager
  • Checking the Trace Files and Alert Log
  • Streams Performance Advisor
  • Viewing Performance Statistics for Oracle Streams Components
  • Using Oracle Enterprise Manager to Manage & Monitor Oracle Streams

Troubleshooting Oracle Streams

  • How to Troubleshoot
  • Troubleshooting Apply
  • Troubleshooting Capture
  • Troubleshooting Propagation