Contents

List of Tables

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I Overview of the Oracle Database Gateway Installation

1 Overview of the Oracle Database Gateway Installation

• 1.1 Gateway Installation Configurations
• 1.2 Gateway Installation Methods
  • 1.2.1 Interactive Installation Method
  • 1.2.2 Automated Installation Method Using Response Files
• 1.3 Installation Considerations
  • 1.3.1 Release Notes
  • 1.3.2 Hardware and Software Certification
  • 1.3.3 Multiple Oracle Homes Support
    • 1.3.3.1 Installing the Software on a System with an Existing Oracle Installation
• 1.4 Upgrades
• 1.5 Accessing the Installation Software
  • 1.5.1 Downloading Oracle Software from the OTN Web Site
    • 1.5.1.1 Downloading the Installation Archive Files from OTN
    • 1.5.1.2 Extracting the Installation Files
  • 1.5.2 Copying the Oracle Software to a Hard Disk
    • 1.5.2.1 Mounting Disc
    • 1.5.2.2 Copying the Oracle Database Gateway Software to a Hard Disk
• 1.6 Running the Oracle Universal Installer

Part II Installing and Configuring Oracle Database Gateway for Sybase

2 Installing Oracle Database Gateway for Sybase

• 2.1 System Requirements for Oracle Database Gateway for Sybase
  • 2.1.1 Hardware Requirements
    • 2.1.1.1 Checking the Hardware Requirements
  • 2.1.2 Software Requirements
    • 2.1.2.1 Operating System
    • 2.1.2.2 Checking the Software Requirements
    • 2.1.2.3 Certified Configuration
• 2.2 Step Through the Oracle Universal Installer

3 Configuring Oracle Database Gateway for Sybase

• 3.1 Configure the Gateway Initialization Parameter File
  • 3.1.1 Choose a System Identifier for the Gateway
  • 3.1.2 Customize the Initialization Parameter File
• 3.2 Configure Oracle Net for the Gateway
  • 3.2.1 Configure Oracle Net Listener for the Gateway
    • 3.2.1.1 Syntax of listener.ora File Entries
  • 3.2.2 Stop and Start the Oracle Net Listener for the Gateway
• 3.3 Configure the Oracle Database for Gateway Access
  • 3.3.1 Configuring tnsnames.ora
• 3.4 Create Database Links
• 3.5 Configure Two-Phase Commit
  • 3.5.1 Create a Recovery Account and Password
  • 3.5.2 Create the Transaction Log Table
• 3.6 Create Sybase Views for Data Dictionary Support
• 3.7 Encrypt Gateway Initialization Parameter Values
• 3.8 Configure the Gateway to Access Multiple Sybase Databases
  • 3.8.1 Multiple Sybase Databases Example: Configuring the Gateway
  • 3.8.2 Multiple Sybase Databases Example: Configuring Oracle Net Listener
  • 3.8.3 Multiple Sybase Databases Example: Stopping and Starting the Oracle Net Listener
  • 3.8.4 Multiple Sybase Databases Example: Configuring Oracle Database for Gateway Access
    • 3.8.4.1 Configuring Oracle Net for Multiple Gateway Instances
  • 3.8.5 Multiple Sybase Databases Example: Accessing Sybase Data

Part III Installing and Configuring Oracle Database Gateway for Informix

4 Installing Oracle Database Gateway for Informix

• 4.1 System Requirements for Oracle Database Gateway for Informix
  • 4.1.1 Hardware Requirements
    • 4.1.1.1 Checking the Hardware Requirements
  • 4.1.2 Software Requirements
    • 4.1.2.1 Operating System
    • 4.1.2.2 Checking the Software Requirements
    • 4.1.2.3 Certified Configuration
• 4.2 Step Through the Oracle Universal Installer

5 Configuring Oracle Database Gateway for Informix

• 5.1 Configure the Gateway Initialization Parameter File
  • 5.1.1 Choose a System Identifier for the Gateway
  • 5.1.2 Customize the Initialization Parameter File
• 5.2 Configure Oracle Net for the Gateway
  • 5.2.1 Configure Oracle Net Listener for the Gateway
    • 5.2.1.1 Syntax of listener.ora File Entries
  • 5.2.2 Stop and Start the Oracle Net Listener for the Gateway
• 5.3 Configure the Oracle Database for Gateway Access
  • 5.3.1 Configuring tnsnames.ora
• 5.4 Create Database Links
• 5.5 Configure Two-Phase Commit
  • 5.5.1 Create a Recovery Account and Password
  • 5.5.2 Create the Transaction Log Table
• 5.6 Encrypt Gateway Initialization Parameter Values
• 5.7 Configure the Gateway to Access Multiple Informix Databases
  • 5.7.1 Multiple Informix Databases Example: Configuring the Gateway
  • 5.7.2 Multiple Informix Databases Example: Configuring Oracle Net Listener
  • 5.7.3 Multiple Informix Databases Example: Stopping and Starting the Oracle Net Listener
  • 5.7.4 Multiple Informix Databases Example: Configuring Oracle Database for Gateway Access
    • 5.7.4.1 Configuring Oracle Net for Multiple Gateway Instances
  • 5.7.5 Multiple Informix Databases Example: Accessing Informix Data

Part IV Installing and Configuring Oracle Database Gateway for Teradata

6 Installing Oracle Database Gateway for Teradata

• 6.1 System Requirements for Oracle Database Gateway for Teradata
  • 6.1.1 Hardware Requirements
    • 6.1.1.1 Checking the Hardware Requirements
  • 6.1.2 Software Requirements
    • 6.1.2.1 Operating System
    • 6.1.2.2 Checking the Software Requirements
    • 6.1.2.3 Certified Configuration
• 6.2 Step Through the Oracle Universal Installer

7 Configuring Oracle Database Gateway for Teradata

• 7.1 Configure the Gateway Initialization Parameter File
  • 7.1.1 Choose a System Identifier for the Gateway
  • 7.1.2 Customize the Initialization Parameter File
• 7.2 Configure Oracle Net for the Gateway
  • 7.2.1 Configure Oracle Net Listener for the Gateway
    • 7.2.1.1 Syntax of listener.ora File Entries
  • 7.2.2 Stop and Start the Oracle Net Listener for the Gateway
• 7.3 Configure the Oracle Database for Gateway Access
  • 7.3.1 Configuring tnsnames.ora
• 7.4 Create Database Links
• 7.5 Configure Two-Phase Commit
  • 7.5.1 Create a Recovery Account and Password
  • 7.5.2 Create the Transaction Log Table
• 7.6 Encrypt Gateway Initialization Parameter Values
• 7.7 Configure the Gateway to Access Multiple Teradata Databases
  • 7.7.1 Multiple Teradata Databases Example: Configuring the Gateway
  • 7.7.2 Multiple Teradata Databases Example: Configuring Oracle Net Listener
  • 7.7.3 Multiple Teradata Databases Example: Stopping and Starting the Oracle Net Listener
  • 7.7.4 Multiple Teradata Databases Example: Configuring Oracle Database for Gateway Access
    • 7.7.4.1 Configuring Oracle Net for Multiple Gateway Instances
  • 7.7.5 Multiple Teradata Databases Example: Accessing Teradata Data

Part V Installing and Configuring Oracle Database Gateway for SQL Server

8 Installing Oracle Database Gateway for SQL Server

• 8.1 System Requirements for Oracle Database Gateway for SQL Server
  • 8.1.1 Hardware Requirements
    • 8.1.1.1 Checking the Hardware Requirements
  • 8.1.2 Software Requirements
    • 8.1.2.1 Operating System
    • 8.1.2.2 Checking the Software Requirements
    • 8.1.2.3 Certified Configuration
• 8.2 Step Through the Oracle Universal Installer

9 Configuring Oracle Database Gateway for SQL Server

• 9.1 Configure the Gateway Initialization Parameter File
  • 9.1.1 Choose a System Identifier for the Gateway
  • 9.1.2 Customize the Initialization Parameter File
• 9.2 Configure Oracle Net for the Gateway
  • 9.2.1 Configure Oracle Net Listener for the Gateway
    • 9.2.1.1 Syntax of listener.ora File Entries
  • 9.2.2 Stop and Start the Oracle Net Listener for the Gateway
• 9.3 Configure the Oracle Database for Gateway Access
  • 9.3.1 Configuring tnsnames.ora
• 9.4 Create Database Links
• 9.5 Configure Two-Phase Commit
  • 9.5.1 Create a Recovery Account and Password
  • 9.5.2 Create the Transaction Log Table
• 9.6 Create SQL Server Views for Data Dictionary Support
• 9.7 Encrypt Gateway Initialization Parameter Values
• 9.8 Configure the Gateway to Access Multiple SQL Server Databases
  • 9.8.1 Multiple SQL Server Databases Example: Configuring the Gateway
  • 9.8.2 Multiple SQL Server Databases Example: Configuring Oracle Net Listener
  • 9.8.3 Multiple SQL Server Databases Example: Stopping and Starting the Oracle Net Listener
  • 9.8.4 Multiple SQL Server Databases Example: Configuring Oracle Database for Gateway Access
    • 9.8.4.1 Configuring Oracle Net for Multiple Gateway Instances
  • 9.8.5 Multiple SQL Server Databases Example: Accessing SQL Server Data

Part VI Installing and Configuring Oracle Database Gateway for ODBC

10 Installing Oracle Database Gateway for ODBC

• 10.1 System Requirements for Oracle Database Gateway for ODBC
  • 10.1.1 Hardware Requirements
    • 10.1.1.1 Checking the Hardware Requirements
  • 10.1.2 Software Requirements
    • 10.1.2.1 Operating System
    • 10.1.2.2 Checking the Software Requirements
    • 10.1.2.3 Certified Configuration
• 10.2 Step Through the Oracle Universal Installer

11 Configuring Oracle Database Gateway for ODBC

• 11.1 Configure the Gateway Initialization Parameter File
  • 11.1.1 Create the Initialization Parameter File
  • 11.1.2 Set the Initialization Parameter Values
    • 11.1.2.1 Example: Setting Initialization Parameter Values
• 11.2 Configure Oracle Net for the Gateway
  • 11.2.1 Configure Oracle Net Listener for the Gateway
    • 11.2.1.1 Syntax of listener.ora File Entries
  • 11.2.2 Stop and Start the Oracle Net Listener for the Gateway
• 11.3 Configure the Oracle Database for Gateway Access
  • 11.3.1 Configuring tnsnames.ora
• 11.4 Create Database Links
• 11.5 Encrypt Gateway Initialization Parameter Values
• 11.6 Configure the Gateway to Access Multiple ODBC Data Sources
  • 11.6.1 Multiple ODBC Data Sources Example: Configuring the Gateway
  • 11.6.2 Multiple ODBC Data Sources Example: Configuring Oracle Net Listener
  • 11.6.3 Multiple ODBC Data Sources Example: Stopping and Starting the Oracle Net Listener
  • 11.6.4 Multiple ODBC Data Sources Example: Configuring Oracle Database for Gateway Access
  • 11.6.5 Multiple ODBC Data Sources Example: Accessing ODBC Data

Part VII Installing and Configuring Oracle Database Gateway for DRDA

12 Installing Oracle Database Gateway for DRDA

• 12.1 System Requirements for Oracle Database Gateway for DRDA
  • 12.1.1 Hardware Requirements
    • 12.1.1.1 Checking the Hardware Requirements
  • 12.1.2 Software Requirements
    • 12.1.2.1 Operating System
    • 12.1.2.2 Checking the Software Requirements
    • 12.1.2.3 Certified Configuration
• 12.2 Step through the Oracle Universal Installer

13 Configuring the DRDA Server

• 13.1 Configuring the DRDA Server for DB2 UDB for z/OS
• 13.2 Configuring the DRDA Server for DB2 UDB for iSeries
• 13.3 Configuring the DRDA Server for DB2 UDB for Linux, Unix, and Windows
• 13.4 Manual Binding of DRDA Gateway Packages
  • 13.4.1 Manually Binding of Packages for DB2 UDB for z/OS
  • 13.4.2 Manually Binding of Packages for DB2 UDB for Linux, Unix, and Windows

14 Configuring Oracle Database Gateway for DRDA

• 14.1 Configure the Gateway Initialization Parameter File
  • 14.1.1 Choose a System Identifier for the Gateway
  • 14.1.2 Customize the Initialization Parameter File
• 14.2 Configure Oracle Net for the Gateway
  • 14.2.1 Configure Oracle Net Listener for the Gateway
    • 14.2.1.1 Syntax of listener.ora File Entries
  • 14.2.2 Stop and Start the Oracle Net Listener for the Gateway
• 14.3 Configure Two-Phase Commit
• 14.4 Create Tables and Views for Data Dictionary Support
• 14.5 Configure the Oracle Database for Gateway Access
  • 14.5.1 Configuring tnsnames.ora
• 14.6 Create Database Links
• 14.7 Configure the Gateway to Access Multiple DRDA Databases
  • 14.7.1 Multiple DRDA Databases Example: Configuring the Gateway
  • 14.7.2 Multiple DRDA Databases Example: Configuring Oracle Net Listener
  • 14.7.3 Multiple DRDA Databases Example: Stopping and Starting the Oracle Net Listener
  • 14.7.4 Multiple Databases Example: Configuring Oracle Database for Gateway Access
    • 14.7.4.1 Configuring Oracle Net for Multiple Gateway Instances
  • 14.7.5 Multiple DRDA Databases Example: Accessing DB2 Data

15 Security Considerations

• 15.1 Security Overview
• 15.2 Authenticating Application Logons
• 15.3 Defining and Controlling Database Links
  • 15.3.1 Link Accessibility
  • 15.3.2 Links and CONNECT Clauses
• 15.4 Processing Inbound Connections
  • 15.4.1 User ID Mapping
    • 15.4.1.1 DB2 UDB for z/OS
    • 15.4.1.2 DB2 UDB for iSeries
    • 15.4.1.3 DB2 UDB for Linux, Unix, and Windows
• 15.5 Passwords in the Gateway Initialization File

16 Migration From Previous Releases

• 16.1 Install the New Release
• 16.2 Gateway Initialization Parameter File
• 16.3 Bind Gateway Package
• 16.4 Install/Upgrade Data Dictionary Views

Part VIII Removing Oracle Database Gateway

17 Removing Oracle Database Gateway

• 17.1 About the Deinstallation Tool
• 17.2 Removing Oracle Software

Part IX Appendixes

A Using Response Files for Noninteractive Installation

• A.1 Introduction
  • A.1.1 Installation Overview
• A.2 Creating the oraInst.loc File
• A.3 Preparing a Response File
  • A.3.1 Editing a Response File Template
  • A.3.2 Recording a Response File
• A.4 Running Oracle Universal Installer in Silent or Suppressed Mode

B Oracle Database Gateway Troubleshooting

• B.1 Verify Requirements
• B.2 What to Do if an Installation Error Occurs
• B.3 Reviewing the Log of an Installation Session
• B.4 Troubleshooting Configuration Assistants
  • B.4.1 Configuration Assistant Failure
  • B.4.2 Fatal Errors
• B.5 Silent-Mode Response File Error Handling
• B.6 Cleaning Up After a Failed Installation

C Initialization Parameters

• C.1 Initialization Parameter File Syntax
• C.2 Oracle Database Gateway for Sybase Initialization Parameters
• C.3 Oracle Database Gateway for Informix Initialization Parameters
• C.4 Oracle Database Gateway for Teradata Initialization Parameters
• C.5 Oracle Database Gateway for SQL Server Initialization Parameters
• C.6 Oracle Database Gateway for ODBC Initialization Parameters
• C.7 Oracle Database Gateway for DRDA Initialization Parameters
• C.8 Initialization Parameter Description
  • C.8.1 HS_TIME_ZONE
  • C.8.2 HS_FDS_PROC_IS_FUNC
  • C.8.3 HS_FDS_RESULTSET_SUPPORT
  • C.8.4 HS_FDS_SHAREABLE_NAME
  • C.8.5 HS_FDS_REPORT_REAL_AS_DOUBLE
  • C.8.6 HS_CALL_NAME
  • C.8.7 HS_DB_DOMAIN
  • C.8.8 HS_DB_INTERNAL_NAME
  • C.8.9 HS_DB_NAME
  • C.8.10 HS_DESCRIBE_CACHE_HWM
  • C.8.11 HS_LANGUAGE
    • C.8.11.1 Character Sets
    • C.8.11.2 Language
    • C.8.11.3 Territory
  • C.8.12 HS_LONG_PIECE_TRANSFER_SIZE
  • C.8.13 HS_OPEN_CURSORS
  • C.8.14 HS_RPC_FETCH_REBLOCKING
  • C.8.15 HS_RPC_FETCH_SIZE
  • C.8.16 HS_TRANSACTION_MODEL
  • C.8.17 IFILE
  • C.8.18 HS_FDS_CONNECT_INFO
  • C.8.19 HS_FDS_DEFAULT_OWNER
  • C.8.20 HS_FDS_RECOVERY_ACCOUNT
  • C.8.21 HS_FDS_RECOVERY_PWD
  • C.8.22 HS_FDS_TRACE_LEVEL
  • C.8.23 HS_FDS_TRANSACTION_LOG
  • C.8.24 HS_FDS_FETCH_ROWS
  • C.8.25 HS_FDS_CAPABILITY
  • C.8.26 HS_FDS_ISOLATION_LEVEL
  • C.8.27 HS_FDS_PACKAGE_COLLID
  • C.8.28 HS_IDLE_TIMEOUT
  • C.8.29 HS_FDS_MBCS_TO_GRAPHIC
  • C.8.30 HS_FDS_GRAPHIC_TO_MBCS
  • C.8.31 HS_FDS_TIMESTAMP_MAPPING
  • C.8.32 HS_FDS_QUOTE_IDENTIFIER
  • C.8.33 HS_NLS_LENGTH_SEMANTICS
  • C.8.34 HS_KEEP_REMOTE_COLUMN_SIZE
  • C.8.35 HS_FDS_RESULTSET_SUPPORT
  • C.8.36 HS_FDS_REMOTE_DB_CHARSET
  • C.8.37 HS_FDS_SUPPORT_STATISTICS
  • C.8.38 HS_FDS_RSET_RETURN_ROWCOUNT
  • C.8.39 HS_FDS_SQLLEN_INTERPRETATION
  • C.8.40 HS_FDS_AUTHENTICATE_USER
  • C.8.41 HS_FDS_ENCRYPT_SESSION
  • C.8.42 HS_FDS_TRUSTSTORE_FILE
  • C.8.43 HS_FDS_TRUSTSTORE_PASSWORD

D Configuration Worksheet for DRDA

Index