Oracle 11g Streams Implementer's Guide

Oracle 11g Streams Implementer's Guide
eBook: $35.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $95.98    Print cover: $59.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • Implement Oracle Streams to manage and coordinate the resources, information, and functions of a distributed system
  • Get to grips with in-depth explanations of the components that make up Oracle Streams, and how they work together
  • Learn design considerations that help identify and avoid Oracle Streams obstacles – before you get caught in them
  • Covers implementation steps with explanations of 'why' as well as 'how'

Book Details

Language : English
Paperback : 352 pages [ 235mm x 191mm ]
Release Date : December 2009
ISBN : 1847199704
ISBN 13 : 9781847199706
Author(s) : Ann L. R. McKinnell, Eric Yen
Topics and Technologies : All Books, Enterprise Products and Platforms, Oracle Database, Enterprise, Oracle

Table of Contents

Chapter 1: All the Pieces: The Parts of an Oracle 11g Streams Environment
Chapter 2: Plot Your Course: Design Considerations
Chapter 3: Prepare the Rafts and Secure Your Gear: The pre-work before configuring Oracle 11g Streams
Chapter 4: Single-Source Configuration
Chapter 5: N-Way Replication
Chapter 6: Get Fancy with Streams Advanced Configurations
Chapter 7: Document What You Have and How It Is Working
Chapter 8: Dealing with the Ever Constant Tides of Change
Chapter 9: Appendix and Glossary
  • Chapter 1: All the Pieces: The Parts of an Oracle 11g Streams Environment
    • Streams architecture overview
      • Topology configurations
        • Single source
        • Multiple source
      • Simultaneous versus Synchronous replication
      • Oracle's Streams replication process flow
      • Streams components
    • About those Queues
    • Capture process—what are we supposed to stream?
      • Downstream Capture
      • Synchronous Capture
    • Instantiation
      • What sets the instantiation SCN and when?
    • Propagate process
      • The Network: COMLINK
      • Propagation success/failure
      • Propagation Stream Split and Merge
    • Apply process
      • Trigger firing and Apply
    • Combined Capture and Apply
    • SCN Coordination—keeps it flowing smoothly
      • The SCNs of Capture
        • FIRST_SCN
        • START_SCN
        • CAPTURED_SCN
        • APPLIED_SCN
        • MAXIMUM_SCN
      • The SCNs of Propagation
      • The SCNs of Apply
        • IGNORE_SCN
        • MAXIMUM_SCN
        • OLDEST_SCN_NUM
        • Low-watermark SCN
      • SCN SYNC-hronization
      • Capture checkpointing
      • Archive Log availability
    • LCRs—what they are and how they work
      • Extracting data from an LCR
      • Conflict detection and the LCR
        • Controlling conflict detection
      • Types of LCRs and how they get created
    • Oracle 11g memory and storage architecture (basic) relating to Streams
    • A word on performance
    • Streams Change tables
    • Oracle GoldenGate XSTREAMS
    • Summary
  • Chapter 2: Plot Your Course: Design Considerations
    • Why?
    • What?
    • Where?
    • Who and How?
    • When and How?
    • Other factors to consider
      • Network capabilities
      • Transaction sizes
      • Potential queue growth
      • Additional hardware resource requirements
      • Administration and maintenance costs
      • Third party application requirements
      • Security
      • Change auditing
      • Platform and version compatibility
      • KISS
      • Design aid: Streams site matrix
        • The Matrix template
    • Summary
  • Chapter 3: Prepare the Rafts and Secure Your Gear: The pre-work before configuring Oracle 11g Streams
    • Network connectivity
      • Check the waterways
      • Configure the Oracle Net "Current"
    • Configure the database
      • Initialization parameters
      • Logging features
        • Archive logging
        • Supplemental logging
        • Forced logging
      • Separate tablespaces
        • LogMiner tablespace
        • Streams Administration tablespace
    • Streams users and privileges
      • Trusted Streams Administrator user configuration
      • Untrusted Streams capture, propagation, and apply user configuration
        • Streams Administration user
        • Capture user
        • Propagation user
        • Apply user
        • Database links
      • Trusted versus untrusted configurations
    • Understanding your Instantiation tools
      • Using Data Pump to Instantiate
      • Setting Instantiation SCN manually
    • Oracle Demo Schemas
    • Summary
  • Chapter 4: Single-Source Configuration
    • The stream flows one way: Downhill
      • The Enterprise Manager
        • Setup options
        • Schedule Streams setup job
        • Verify
      • The code behind the curtain
        • Checking the waters
        • Diving in
        • The proof is in the pudding (or propagation in this case)
      • Sequences and triggers and Apply
      • Other levels at which to replicate
        • The beauty of DBMS_STREAMS_ADM.MAINTAIN_*
    • Summary
  • Chapter 5: N-Way Replication
    • Pre-planning for N-way replication
    • Avoiding conflict
    • The setup
      • Preliminary setup
      • Streaming STRM1 to STRM2
      • Streaming STRM2 to STRM1
    • Conflict resolution
    • Extending the example
    • Rinse and repeat
    • Summary
  • Chapter 6: Get Fancy with Streams Advanced Configurations
    • Synchronous Capture—straight to the Queue
    • Subsetting—the micro side of replication
    • Tag!—you're it
      • The default behaviour of tags
      • Making tags work for you
        • Setting the tag value
        • Evaluating tags at the replication process rule level
        • Tag usage
    • RULES—they're what we live by
      • Rule components
        • Rule conditions
        • Rule evaluation context
        • Action context
      • Creating your own rules
        • Rule creation
        • Rule Sets
        • Event context
        • How it all comes together
      • Rule based transformation—eat your heart out transformers!
        • Declarative versus User Created
        • How the transformation is processed
        • Transformation errors
      • Things to remember when working with Rules
    • Downstream Capture—avoid white water at the source
      • Setting up the redo log transport
      • Configuring the Streams part of DSC
    • Streams change tables—just tracking the "Facts" Ma'am
    • Automatic propagation split and merge—redirecting the current
    • Basic Heterogeneous Configuration
      • Configuring a Heterogeneous Apply process
      • Data Transfer via Queue Messaging
    • Basic XSTREAMS Configuration
      • XSTREAMS Servers
        • Configuring the Database
        • Configuring XSTREAMS Out
        • Configuring XSTREAMS In
    • Summary
  • Chapter 8: Dealing with the Ever Constant Tides of Change
    • Affecting expected change effectively
      • Changing States: Starting and stopping processes
      • Database changes
        • Structure changes to existing objects
        • Data changes—beware the bulk load!
      • Expanding your Streamed environment
        • Example: Adding a Master Site
        • Example: Adding a table to a replicated schema
      • Shrinking the Streamed environment
        • Removing table, scheme, and tablespace level replication from Streams
        • Removing a site from a Streamed environment
    • Troubleshooting unexpected changes and resulting Streams errors
      • Failure Points and Most Likely Causes (a.k.a. FPs and MLCs)
        • Failure Point 1: DML/DDL statement commit logging
        • Failure Point 2: LogMiner
        • Failure Point 3: Capture process and rules
        • Failure Point 4: Capture enqueue
        • Failure Point 5: Propagation dequeue from Capture queue
        • Failure Point 6: Propagation Rules
        • Failure Point 7: Database link configuration
        • Failure Point 8: Network connectivity and stability
        • Failure Point 9: Propagation enqueue to the Apply queue
        • Failure Point 10: Apply dequeue
        • Failure Point 11: Apply Rules
        • Failure Point 12: Conflict detection and resolution rules
        • Failure Point 13: Apply Errors
      • Troubleshooting tools
        • Enterprise Manager: Streams management
        • Command line packages and scripts
        • Compare and Converge divergent data.
    • Summary

Ann L. R. McKinnell

Ann McKinnell is currently a Senior Principal Consultant with APG Technologies, LLC and has been an OCP since Oracle 7.3.4. She came to APG with over 8 years as a senior technical member of Oracle Global Support, specializing in Replication and Distributed System technologies. She was a recognized global technical expert for Oracle Distributed Systems; earning the internal nickname "The Replication Goddess". Ann has trained Oracle Support and Consulting personnel from many countries in Advanced Replication and Distributed System Internals and Problem Solving techniques. She has authored and co-authored many of the Oracle Advanced Replication notes found on Oracle Metalink, and was a technical reviewer for the Oracle University Pilot 9i Steams course material, as well as various Oracle Replication and Database Administration user manuals. Ann continues to specialize in practical implementation strategies and the development of distributed Oracle database systems, database architecture, and software and database design and integration.

Eric Yen

Eric Yen began working with Oracle Databases at version 7.3.4. Over the following 14 years, he obtained his Oracle DBA Certification starting with version 8, maintaining it up to the current release, and he has also earned the (ISC)2 CISSP certification. Eric began working with Oracle Streams with Oracle 9i Streams beta. As a Senior Principal Consultant with APG Technologies, LLC, Eric's work includes designing and implementing Streams solutions for Government clients using the more recent versions of Streams in Oracle 10 and Oracle 11. During his little spare time, you can find Eric exercising and tinkering around with Oracle products.

Sorry, we don't have any reviews for this title yet.

Code Downloads

Download the code and support files for this book.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.


- 2 submitted: last submission 12 Mar 2013

Errata type: Typo | Page number: 41 |

This procedure must be one at least once in the database before a Capture process can be created.
should be
This procedure must be run at least once in the database before a Capture process can be created.


Errata type: Code| Page number: 130 |

should be


Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

Oracle 11g Streams Implementer's Guide +    IBM SPSS Modeler Cookbook =
50% Off
the second eBook
Price for both: $51.15

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • Clear, concise explanations of Oracle Streams components and concepts
  • Up-front design considerations and techniques – know what you need BEFORE you start building
  • Configure both Source and Target databases to support Streams capture, propagation, and apply processes
  • Set up a Single-Source Configuration using the Enterprise manager DB Console to divert flow in one direction and apply its concepts to a multi-master, or N-Way Replication environment configuration
  • Solidify your Streams concepts through basic implementation examples that can then be applied to more complicated systems
  • Learn about popular advanced features of Oracle Streams including Subsetting, Tags, Rules, and Rule based transformations
  • Discover effective and efficient troubleshooting techniques and tools

In Detail

From smaller businesses through to huge enterprises – users all over the world often require access to data 24 hours a day. Distributed database systems proliferate the world of data sharing providing an ability to access real-time data anywhere, anytime. Oracle Streams, a built-in feature of the Oracle database, is a data replication and integration feature critical to the success and wellbeing of enterprises in today's fast moving economy. This book provides the reader with solid techniques to master Oracle Streams technology and successfully deploy distributed database systems.

This book quickly goes over the basics and gets you up and running with a simple Oracle 11g Streams environment. It will serve as an excellent companion to the Oracle Streams Administration Guide. It is intended for Oracle database architects and administrators, and provides in-depth discussion on must-know information for the design, implementation, and maintenance of an Oracle Streams environment.

The book does not attempt to regurgitate all the information in the Oracle Streams Administration Guides, but rather provides additional clarification and explanation of design, implementation, and troubleshooting concepts that are often elusive in Streams documentation. It also identifies helpful tools and Oracle resources to add to your knowledge base, as well as tried and tested tricks and tips to help you tame Oracle Streams.

The book starts by introducing and explaining the components of Oracle Streams and how they work together. It then moves on logically, helping you to determine your distributed environment requirements and design your Streams implementation to meet those requirements. Once these concepts are discussed, the book moves to configuration and basic implementation examples to help solidify those concepts. It then addresses advanced features such as tags, down-stream capture, and conflict resolution. You then move on to maintenance techniques such as documenting the environment, effectively planning and implementing changes to the environment, and monitoring and troubleshooting the environment. When you have studied the techniques and completed the hands-on examples, you will have an understanding of Oracle Streams' core concepts and functionally that will allow you to successfully design, implement, and maintain an Oracle Streamed environment.


This book has a tutorial approach that provides both theoretical explanations and practical step-by-step examples using familiar Oracle demo schemas. Step-by-step examples include use of both Enterprise Manager and the SQLPLUS command-line interface. The authors have combined their experiences of working with customers in Oracle Support, Oracle training and education, and Oracle consulting, to identify the most common areas of confusion and misinterpretation experienced by Oracle Streams users. This book highlights these areas and focuses on bringing clarity and understanding to the reader.

Who this book is for

This book is for users who have implemented, or are about to implement, a distributed database environment using Oracle Streams replication. The reader is expected to have an intermediate understanding of Oracle database technology.

This book is mainly intended for use by:

  • Oracle Database Administrators responsible for the implementation and maintenance of an Oracle Streamed environment
  • System and Database Architects responsible for the design of distributed database environments using Oracle Streams

Readers with limited knowledge of basic Oracle database technology can benefit from Chapters 1 and 2, which cover Oracle Streams Components and Design Considerations.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software