Oracle Transparent Gateway Rdb on Alpha OpenVms Administrator's Guide
Release 8.1.7

Part Number A82918-01
Go To Documentation Library
Library
Go To Product List
Product
Go To Index
Index

Go to next page

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience
Related Publications
Notational Conventions
Your Comments are Welcome

1 Release Information

Product Set
System Requirements
Hardware Requirements
Software Requirements
Tested Configurations
Database Compatibility Issues for Rdb
Handling Dates
Queries
Empty Strings
Empty Bind Variables
Constraint Handling
Known Restrictions
Transactional Integrity
Transaction Capability
COMMIT or ROLLBACK in Cursor PL/SQL Loops Closes Open Cursors
Multi-Schema Rdb Databases
Subqueries in UPDATE Statement
ROWID
Table and View Names
Column Names
Unsupported Data Types
Database Links
Stored Procedures
National Language Support
Known Problems
Encrypted Format Login
Data Definition Language Statements
Date and Time Issues
Pass-Through Feature

2 Introduction

Oracle Heterogeneous Services
Oracle Transparent Gateway for Rdb
Gateway Architecture
Gateway Process Flow
Additional Features
Remote Data Access
Elimination of Unnecessary Data Duplication
Heterogeneous Database Integration
Application Development and End User Tools
Two-Phase Commit and Multi-Site Transactions
Query Optimization
Error Mapping and Logging
Pass-Through Feature

3 Installing the Gateway

Before You Begin
Determine the Configuration of the Gateway Components
Installation Worksheet
Installing the Gateway from the CD-ROM
De-installing the Gateway

4 Configuring the Gateway

Configuring the Gateway
Task 1: Choose a System ID for the Gateway
Task 2: Customize the Gateway Startup File
Task 3: Customize the Initialization Parameter File
Configuring Net8 Listener for the Gateway
Task 1: Configure Net8 TNS Listener for the Gateway
Example of Address to Listen On in listener.ora File
Example of Gateway Entry in listener.ora File
Task 2: Stop and Start the TNS Listener for the Gateway
Configuring the Oracle Database Server for Gateway Access
Configuring Oracle Net8 for the Oracle Database Server
Configuring tnsnames.ora
Performing Optional Configuration Tasks
Configuring for Two-Phase Commit
Create the Transaction Log Table
Creating Database Links
Configuring the Gateway for Multiple Rdb Databases
Multiple Databases Example: Configuring the Gateway
Multiple Databases Example: Configuring Oracle Net8 Listener
Multiple Databases Example: Stopping and Starting the TNS Listener
Multiple Databases Example: Configuring the Oracle Database Server for Gateway Access
Configuring Net8 on the Oracle Database Server for Multiple Gateway Instances
Multiple Databases Example: Accessing Rdb Data

5 Using the Gateway

Accessing Rdb Data Through the Gateway
Oracle Database Server SQL Construct Processing
Data Type Conversion
Using Synonyms
Using the Pass-Through Feature
Performing Distributed Queries
Example of a Distributed Query
Two-Phase Commit
Distributed Rdb Transactions
Copying Data from the Oracle Database Server to Rdb
Copying Data from Rdb to the Oracle Database Server

6 Case Studies

Case Descriptions
CD-ROM Contents
Demonstration Files
Demonstration Requirements
Creating Demonstration Tables
Demonstration Table Definitions
Demonstration Table Contents
Case 1: Simple Queries
Case 2: A More Complex Query
Case 3: Joining Rdb Tables
Case 4: Write Capabilities
DELETE Statement
UPDATE Statement
INSERT Statement
Case 5: Data Dictionary Query
Case 6: The Pass-Through Feature
UPDATE Statement
SELECT Statement

7 Diagnosing Problems

Problem Identification
Installation and Configuration Issues
How do I verify that the installation succeeded?
Does the Oracle Installer configure everything?
Net8 Configuration Problems
Common Gateway Problems
Analyzing Error Messages
Message and Error Code Processing
Oracle Database Server Error Codes
Gateway Error Codes and Message Formats
Tracing
Trace Log Files
Reviewing the Trace Output
Oracle Support Services

A Supported SQL Syntax and Functions

Supported SQL Statements
DELETE
INSERT
SELECT
UPDATE
Oracle Functions
Functions Not Supported by Rdb
Functions Supported by Rdb
Arithmetic Operators
Comparison Operators
String Functions
Group Functions
Pattern Matches
Date Functions
Other Functions
Functions Supported by the Gateway

B Data Dictionary

Data Dictionary Support
Rdb System Catalog Tables
Accessing the Gateway Data Dictionary
Direct Queries to Rdb Tables
Object Name Limitations
Table Owner
Supported Views and Tables
Data Dictionary Mapping
Default Column Values
Gateway Data Dictionary Descriptions

C Heterogeneous Services Initialization Parameters

Initialization Parameter File Syntax
HS_FDS_CONNECT_INFO
HS_FDS_TRACE_LEVEL
HS_FDS_TRANSACTION_MODEL

Go to next page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Library
Go To Product List
Product
Go To Index
Index