Table of 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 Oracle Database Gateway Upgrades
    • 1.5 Accessing the Installation Software
      • 1.5.1 Downloading Oracle Software from the OTN Web Site
        • 1.5.1.1 Download the Installation Archive Files from OTN
        • 1.5.1.2 Extract the Installation Files
      • 1.5.2 Copying the Oracle Software
    • 1.6 Running the Oracle Universal Installer
    • 1.7 Installing and Configuring in Cluster Environments
      • 1.7.1 Support for Single Client Access Name (SCAN)
      • 1.7.2 Local Listener
      • 1.7.3 Load Balancing and Transparent Application Failover(TAF)
• 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.2 Checking the Hardware Requirements
      • 2.1.3 Software Requirements
        • 2.1.3.1 Operating System
        • 2.1.3.2 Certified Configuration
      • 2.1.4 Checking the Software Requirements
    • 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.3.2 Configuring tnsnames.ora for Multiple Listeners
    • 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.2 Checking the Hardware Requirements
      • 4.1.3 Software Requirements
        • 4.1.3.1 Operating System
        • 4.1.3.2 Certified Configuration
      • 4.1.4 Checking the Software Requirements
    • 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.3.2 Configuring tnsnames.ora for Multiple Listeners
    • 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.2 Checking the Hardware Requirements
      • 6.1.3 Software Requirements
        • 6.1.3.1 Operating System
        • 6.1.3.2 Certified Configuration
      • 6.1.4 Checking the Software Requirements
    • 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.3.2 Configuring tnsnames.ora for Multiple Listeners
    • 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.2 Checking the Hardware Requirements
      • 8.1.3 Software Requirements
        • 8.1.3.1 Operating System
        • 8.1.3.2 Certified Configuration
      • 8.1.4 Checking the Software Requirements
    • 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.3.2 Configuring tnsnames.ora for Multiple Listeners
    • 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.2 Checking the Hardware Requirements
      • 10.1.3 Software Requirements
        • 10.1.3.1 Operating System
        • 10.1.3.2 Certified Configuration
      • 10.1.4 Checking the Software Requirements
    • 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.3.2 Configuring tnsnames.ora for Multiple Listeners
    • 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.2 Checking the Hardware Requirements
      • 12.1.3 Software Requirements
        • 12.1.3.1 Operating System
        • 12.1.3.2 Certified Configuration
      • 12.1.4 Checking the Software Requirements
    • 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.5.2 Configuring tnsnames.ora for Multiple Listeners
    • 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 Passwords in the Gateway Initialization File
  • 16 Migrating From Previous Releases
    • 16.1 Install the New Release
    • 16.2 Gateway Initialization Parameter File
    • 16.3 Bind Gateway Package
    • 16.4 Install or 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
• 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 HS_TIME_ZONE
  • C.9 HS_FDS_PROC_IS_FUNC
  • C.10 HS_FDS_RESULTSET_SUPPORT
  • C.11 HS_FDS_SHAREABLE_NAME
  • C.12 HS_FDS_REPORT_REAL_AS_DOUBLE
  • C.13 HS_CALL_NAME
  • C.14 HS_DB_DOMAIN
  • C.15 HS_DB_INTERNAL_NAME
  • C.16 HS_DB_NAME
  • C.17 HS_DESCRIBE_CACHE_HWM
  • C.18 HS_LANGUAGE
    • C.18.1 Character Sets
    • C.18.2 Language
    • C.18.3 Territory
  • C.19 HS_LONG_PIECE_TRANSFER_SIZE
  • C.20 HS_OPEN_CURSORS
  • C.21 HS_RPC_FETCH_REBLOCKING
  • C.22 HS_RPC_FETCH_SIZE
  • C.23 HS_TRANSACTION_MODEL
  • C.24 IFILE
  • C.25 HS_FDS_CONNECT_INFO
  • C.26 HS_FDS_RECOVERY_ACCOUNT
  • C.27 HS_FDS_RECOVERY_PWD
  • C.28 HS_FDS_TRACE_LEVEL
  • C.29 HS_FDS_TRANSACTION_LOG
  • C.30 HS_FDS_FETCH_ROWS
  • C.31 HS_FDS_CAPABILITY
  • C.32 HS_FDS_ISOLATION_LEVEL
  • C.33 HS_FDS_PACKAGE_COLLID
  • C.34 HS_IDLE_TIMEOUT
  • C.35 HS_FDS_MBCS_TO_GRAPHIC
  • C.36 HS_FDS_GRAPHIC_TO_MBCS
  • C.37 HS_FDS_TIMESTAMP_MAPPING
  • C.38 HS_FDS_DATE_MAPPING
  • C.39 HS_FDS_ARRAY_EXEC
  • C.40 HS_FDS_QUOTE_IDENTIFIER
  • C.41 HS_NLS_LENGTH_SEMANTICS
  • C.42 HS_KEEP_REMOTE_COLUMN_SIZE
  • C.43 HS_FDS_RESULTSET_SUPPORT
  • C.44 HS_FDS_REMOTE_DB_CHARSET
  • C.45 HS_FDS_SUPPORT_STATISTICS
  • C.46 HS_FDS_RSET_RETURN_ROWCOUNT
  • C.47 HS_FDS_SQLLEN_INTERPRETATION
  • C.48 HS_FDS_AUTHENTICATE_METHOD
  • C.49 HS_FDS_ENCRYPT_SESSION
  • C.50 HS_FDS_TRUSTSTORE_FILE
  • C.51 HS_FDS_TRUSTSTORE_PASSWORD
• D Configuration Worksheet for Oracle Database Gateway for DRDA
• Index