Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I XStream Concepts and Use Cases

1 XStream Concepts

• About XStream
  • Licensing XStream
• XStream Out
  • The Outbound Server
    • Outbound Servers and Apply Process Features
  • ID Key LCRs
    • ID Key LCRs Demo
  • Sequence LCRs
  • Considerations for XStream Outbound Servers
  • XStream Out and Distributed Transactions
• XStream In
  • The Inbound Server
  • Considerations for XStream Inbound Servers
• Position Order in an LCR Stream
  • About Position Order
  • Position of LCRs and XStream Out
    • Additional LCR Attributes Related to Position
    • The Processed Low Position and Restartability for XStream Out
    • Streaming Network Transmission
  • Position of LCRs and XStream In
  • Summary of Position Use in XStream Out and XStream In
• XStream and SQL Generation
  • Interfaces for Performing SQL Generation
  • SQL Generation Formats
  • Data Types and Character Sets
  • SQL Generation Demo
• XStream and Security
• Other Ways to Share Information in a Heterogeneous Environment

2 XStream Use Cases

• Introduction to XStream Use Cases
  • XStream Out Use Cases
  • XStream In Use Cases
• Replicating Data Changes with Non-Oracle Databases
• Using Files to Store Data Changes
  • XStream Demo That Replicates Database Changes Using Files
• Sharing Data Changes with a Client-Side Memory Cache

Part II XStream Administration

3 Configuring XStream

• Preparing for XStream
  • Granting Privileges for the XStream Administrator
  • Preparing for XStream Out
    • Decide How to Configure XStream
    • Prerequisites for Configuring XStream Out
  • Preparing for XStream In
    • Configure an XStream Administrator
    • Set the Relevant Initialization Parameters Relevant
    • Configure the Oracle Streams Pool
• Configuring XStream Out
  • Configuring an XStream Outbound Server
    • Configuring Multiple XStream Out Components Using CREATE_OUTBOUND
    • Configuring an Outbound Server Using ADD_OUTBOUND
  • Adding an Additional Outbound Server to a Capture Process Stream
• Configuring XStream In
• Sample XStream Client Application
  • Sample XStream Client Application for the Oracle Call Interface API
  • Sample XStream Client Application for the Java API

4 Managing XStream

• About Managing XStream
• Managing XStream Out
  • Checking Whether the DBMS_XSTREAM_ADM Package Can Manage a Capture Process
  • Managing Rules for an XStream Out Configuration
    • Adding Rules to an XStream Out Configuration
    • Removing Rules from an XStream Out Configuration
  • Changing the Connect User for an Outbound Server
  • Changing the Capture User of the Capture Process for an Outbound Server
  • Changing the Start SCN or Start Time of the Capture Process for an Outbound Server
    • Changing the Start SCN of the Capture Process for an Outbound Server
    • Changing the Start Time of the Capture Process for an Outbound Server
  • Dropping Components in an XStream Out Configuration
• Managing XStream In
  • Changing the Apply User for an Inbound Server
  • Managing Eager Errors Encountered by an Inbound Server
  • Dropping Components in an XStream In Configuration

5 Monitoring XStream

• About Monitoring XStream
• Monitoring Session Information About XStream Components
• Monitoring XStream Out
  • Displaying General Information About an Outbound Server
  • Displaying Status and Error Information for an Outbound Server
  • Displaying Information About an Outbound Server's Current Transaction
  • Displaying Statistics for an Outbound Server
  • Displaying the Processed Low Position for an Outbound Server
  • Determining the Process Information for an Outbound Server
• Monitoring XStream In
  • Displaying General Information About an Inbound Server
  • Displaying the Status and Error Information for an Inbound Server
  • Displaying the Position Information for an Inbound Server
• Monitoring XStream Rules
• XStream and the Oracle Streams Performance Advisor
  • XStream Components
  • Topology and Stream Paths
  • XStream and Component-Level Statistics
  • The UTL_SPADV Package
    • Sample Output When an Outbound Server Is the Last Component in a Path
    • Sample Output When an Inbound Server Is the Last Component in a Path

6 Troubleshooting XStream

• Diagnosing Problems with XStream
• Problems and Solutions for XStream
  • An OCI Client Application Cannot Attach to the Outbound Server
  • Changes Are Failing to Reach the Client Application in XStream Out
  • LCRs Streaming from an Outbound Server Are Missing Extra Attributes
  • The XStream Out Client Application Is Unresponsive
  • XStream In Cannot Identify an Inbound Server
• How to Get More Help with XStream

Part III XStream PL/SQL Packages Reference

7 DBMS_XSTREAM_ADM

• Using DBMS_XSTREAM_ADM
  • Overview
  • Security Model
  • Operational Notes
• Summary of DBMS_XSTREAM_ADM Subprograms
  • ADD_OUTBOUND Procedure
  • ADD_SUBSET_OUTBOUND_RULES Procedure
  • ALTER_INBOUND Procedure
  • ALTER_OUTBOUND Procedure
  • CREATE_INBOUND Procedure
  • CREATE_OUTBOUND Procedure
  • DROP_INBOUND Procedure
  • DROP_OUTBOUND Procedure
  • ENABLE_GG_XSTREAM_FOR_STREAMS Procedure
  • IS_GG_XSTREAM_FOR_STREAMS Function
  • REMOVE_SUBSET_OUTBOUND_RULES Procedure

8 DBMS_XSTREAM_AUTH

• Using DBMS_XSTREAM_AUTH
  • Overview
  • Security Model
• Summary of DBMS_XSTREAM_AUTH Subprograms
  • GRANT_ADMIN_PRIVILEGE Procedure
  • GRANT_REMOTE_ADMIN_ACCESS Procedure
  • REVOKE_ADMIN_PRIVILEGE Procedure
  • REVOKE_REMOTE_ADMIN_ACCESS Procedure

Part IV XStream OCI API Reference

9 Introduction to the OCI Interface for XStream

• About the XStream Interface
  • XStream Out
  • XStream In
  • Position Order and LCR Streams
  • XStream and Character Sets
• Handler and Descriptor Attributes
  • Conventions
  • Server Handle Attributes
    • OCI_ATTR_XSTREAM_ACK_INTERVAL
    • OCI_ATTR_XSTREAM_IDLE_TIMEOUT

10 OCI XStream Functions

• Introduction to XStream Functions
  • Conventions for OCI Functions
  • Purpose
  • Syntax
  • Parameters
  • Comments
• OCI XStream Functions
  • OCILCRAttributesGet()
  • OCILCRAttributesSet()
  • OCILCRFree()
  • OCILCRDDLInfoGet()
  • OCILCRHeaderGet()
  • OCILCRRowStmtGet()
  • OCILCRRowStmtWithBindVarGet()
  • OCILCRNew()
  • OCILCRRowColumnInfoGet()
  • OCILCRRowColumnInfoSet()
  • OCILCRDDLInfoSet()
  • OCILCRHeaderSet()
  • OCILCRLobInfoGet()
  • OCILCRLobInfoSet()
  • OCILCRSCNsFromPosition()
  • OCILCRSCNToPosition()
  • OCILCRWhereClauseGet()
  • OCILCRWhereClauseWithBindVarGet()
  • OCIXStreamInAttach()
  • OCIXStreamInDetach()
  • OCIXStreamInLCRSend()
  • OCIXStreamInLCRCallbackSend()
  • OCIXStreamInProcessedLWMGet()
  • OCIXStreamInErrorGet()
  • OCIXStreamInFlush()
  • OCIXStreamInChunkSend()
  • OCIXStreamInCommit()
  • OCIXStreamOutAttach()
  • OCIXStreamOutDetach()
  • OCIXStreamOutLCRReceive()
  • OCIXStreamOutLCRCallbackReceive()
  • OCIXStreamOutProcessedLWMSet()
  • OCIXStreamOutChunkReceive()

Part V XStream Data Dictionary Views

11 XStream Static Data Dictionary Views

• ALL_APPLY
• ALL_APPLY_ERROR
• ALL_APPLY_ERROR_MESSAGES
• ALL_CAPTURE
• ALL_XSTREAM_INBOUND
• ALL_XSTREAM_INBOUND_PROGRESS
• ALL_XSTREAM_OUTBOUND
• ALL_XSTREAM_OUTBOUND_PROGRESS
• ALL_XSTREAM_RULES
• DBA_APPLY
• DBA_APPLY_ERROR
• DBA_APPLY_ERROR_MESSAGES
• DBA_APPLY_SPILL_TXN
• DBA_CAPTURE
• DBA_XSTREAM_ADMINISTRATOR
• DBA_XSTREAM_INBOUND
• DBA_XSTREAM_INBOUND_PROGRESS
• DBA_XSTREAM_OUT_SUPPORT_MODE
• DBA_XSTREAM_OUTBOUND
• DBA_XSTREAM_OUTBOUND_PROGRESS
• DBA_XSTREAM_RULES

12 XStream Dynamic Performance (V$) Views

• V$STREAMS_APPLY_COORDINATOR
• V$STREAMS_APPLY_READER
• V$STREAMS_APPLY_SERVER
• V$XSTREAM_CAPTURE
• V$XSTREAM_MESSAGE_TRACKING
• V$XSTREAM_OUTBOUND_SERVER
• V$XSTREAM_TRANSACTION

Index