Oracle8 Server Distributed Database Systems

Oracle's Distributed Database Architecture

Clients and Servers

The Network

Databases and Database Links

Database Links

Schema Object Name Resolution

Connecting Between Oracle Server Versions

Distributed Databases and Distributed Processing

Distributed Databases and Database Replication

Heterogeneous Distributed Databases

Heterogeneous Services

Features

Developing Distributed Database Applications

Remote and Distributed SQL Statements

Remote Procedure Calls (RPCs)

Remote and Distributed Transactions

Transparency in a Distributed Database System

Administering an Oracle Distributed Database System

Site Autonomy

Distributed Database Security

Tools for Administering Oracle Distributed Databases

Enterprise Manager

Third-Party Administration Tools

SNMP Support

National Language Support

Global Database Names and Global Object Names

Types of Database Links

Private, Public, and Global Database Links

Security Options for Database Links

Shared Database Links

Connection Qualifiers

Database Link Resolution

Schema Object Name Resolution

Views, Synonyms, Procedures and Global Name Resolution

Dropping a Database Link

Listing Available Database Links

Limiting the Number of Active Database Links

Techniques for Location Transparency

Views and Location Transparency

Synonyms and Location Transparency

Procedures and Location Transparency

Statement Transparency

Restrictions

Values for Environmentally-Dependent SQL Functions

Shared SQL for Remote and Distributed Statements

Distributed Transaction Management

The Prepare and Commit Phases

Servers and Database Servers

Local Coordinators

The Global Coordinator

The Commit Point Site

A Case Study

The Scenario

The Process

Coordination of System Change Numbers

Read-Only Distributed Transactions

Limiting the Number of Distributed Transactions Per Node

Troubleshooting Distributed Transaction Problems

Failures that Interrupt Two-Phase Commit

Failures that Prevent Data Access

Manually Overriding In-Doubt Transactions

Manual Override Example

Step 1: Record User Feedback

Step 2: Query DBA_2PC_PENDING

Step 3: Query DBA_2PC_NEIGHBORS

Manually Checking the Status of Pending Transactions at
SALES.ACME.COM

Manually Checking the Status of Pending Transactions at
HQ.ACME.COM:

Step 4: Check for Mixed Outcome

The Pending Transaction Table (DBA_2PC_PENDING)

Manually Committing In-Doubt Transactions

Forcing a Commit or Rollback in Enterprise Manager

Manually Committing or Rolling Back In-Doubt Transactions

Changing Connection Hold Time

Setting a Limit on Distributed Transactions

Testing Distributed Transaction Recovery Features

Forcing a Distributed Transaction to Fail

The Recoverer (RECO) Background Process

Disabling and Enabling RECO

Oracle Security Server

Oracle Security Server Operation

Global Users

Creating Global Users

Authenticating Global Users

Global Roles

Creating Global Roles

Granting Privileges to Global Roles

Assigning Global Roles to Global Users

Enterprise Roles

Trusting other Databases

Trust Between more than Two Databases

Administering Trust

Factors Affecting the Distribution of an Application's Data

Controlling Connections Established by Database Links

Referential Integrity in a Distributed System

Distributed Queries

Tuning Distributed Queries

Handling Errors in Remote Procedures

What is Heterogeneous Services?

The Services provided by Heterogeneous Services

SQL Service

Procedural Service

Using Heterogeneous Services

Heterogeneous Services Process Architecture

Process Architecture for Distributed External Procedures

Non-Oracle System Classes and Instances

Setting up access to Non-Oracle Systems

Install the Heterogeneous Services Data Dictionary

Set Up the Agent executable

Install Class Information

Register the instance to be accessed at the Oracle8 Server

Register Distributed External Procedures

Set Initialization Parameters

Create the Database Link to the Non-Oracle System

Test the connection

The Data Dictionary Views

General Data Dictionary Views for Heterogeneous Services

Data Dictionary Views for the SQL Service

Data Dictionary Views for Distributed External Procedures

The DBMS_HS Package

Copying Instances

Security for Distributed External Procedures

Application Development with Heterogeneous Services

Pass-Through SQL

Considerations When Using Pass-Through SQL

Executing Pass-Through SQL Statements

Executing Queries

Bulk Fetch

Array Fetch Using the OCI, an Oracle Precompiler, or Another Tool

Array Fetch Between an Oracle8 Server and the Agent

Array Fetch Between the Agent and the Non-Oracle Datastore

Reblocking

HS_COMMIT_POINT_STRENGTH A-2 HS_COMMIT_POINT_STRENGTH

HS_DB_DOMAIN

HS_DB_INTERNAL_NAME

HS_DB_NAME

HS_DESCRIBE_CACHE_HWM

HS_RPC_FETCH_REBLOCKING

HS_FDS_FETCH_ROWS

HS_RPC_FETCH_SIZE

DBMS_HS.CREATE_FDS_INST

DBMS_HS.CREATE_INST_INIT

DBMS_HS.DROP_FDS_INST

DBMS_HS.DROP_INST_INIT

DBMS_HS_PASSTHROUGH.BIND_VARIABLE

DBMS_HS_PASSTHROUGH.BIND_VARIABLE_RAW

DBMS_HS_PASSTHROUGH.BIND_OUT_VARIABLE

DBMS_HS_PASSTHROUGH.BIND_OUT_VARIABLE_RAW

DBMS_HS_PASSTHROUGH.BIND_INOUT_VARIABLE

DBMS_HS_PASSTHROUGH.BIND_INOUT_VARIABLE_RAW

DBMS_HS_PASSTHROUGH.CLOSE_CURSOR

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE

DBMS_HS_PASSTHROUGH.EXECUTE_NON_QUERY

DBMS_HS_PASSTHROUGH.FETCH_ROW

DBMS_HS_PASSTHROUGH.GET_VALUE

DBMS_HS_PASSTHROUGH.GET_VALUE_RAW

DBMS_HS_PASSTHROUGH.OPEN_CURSOR

DBMS_HS_PASSTHROUGH.PARSE

Contents

Title and Copyright Information

Preface

Chapter 1 Distributed Database Concepts

Chapter 2 Distributed Database Administration

Chapter 3 Distributed Transactions

Chapter 4 Using the Oracle Security Server

Chapter 5 Distributed Database System Application Development1

Chapter 6 Understanding Oracle Heterogeneous Services

Chapter 7 Administering Oracle Heterogeneous Services

Chapter 8 Application Development with Heterogeneous Services

Appendix A Heterogeneous Services Initialization Parameters

Appendix B DBMS_HS Package Reference

Appendix C DBMS_HS_PASSTHROUGH for Pass-Through SQL

Index