Oracle8 Server Distributed Database Systems
Release 8.0
A54653_01

Library

Product

Index


Next

Contents

Title and Copyright Information

Preface

Chapter 1 Distributed Database Concepts

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

Chapter 2 Distributed Database Administration

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

Chapter 3 Distributed Transactions

Distributed Transaction Management
The Prepare and Commit Phases
Prepare Phase
Commit Phase
The Session Tree
Clients
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

Chapter 4 Using the Oracle Security Server

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

Chapter 5 Distributed Database System Application Development1

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

Chapter 6 Understanding Oracle Heterogeneous Services

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

Chapter 7 Administering Oracle Heterogeneous Services

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

Chapter 8 Application Development with Heterogeneous Services

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

Appendix A Heterogeneous Services Initialization Parameters

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_LANGUAGE
Character sets
Language
Territory
HS_NLS_DATE_FORMAT
HS_NLS_NCHAR
HS_OPEN_CURSORS
HS_ROWID_CACHE_SIZE
HS_RPC_FETCH_REBLOCKING
HS_FDS_FETCH_ROWS
HS_RPC_FETCH_SIZE

Appendix B DBMS_HS Package Reference

DBMS_HS.CREATE_FDS_INST
DBMS_HS.CREATE_INST_INIT
DBMS_HS.DROP_FDS_INST
DBMS_HS.DROP_INST_INIT

Appendix C DBMS_HS_PASSTHROUGH for Pass-Through SQL

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

Index



Next
Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.

Library

Product

Index