Contents

List of Figures

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
    • 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/OS390
• 13.2 Configuring the DRDA Server for DB2/400
• 13.3 Configuring the DRDA Server for DB2/UDB (Universal Database)

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 Bind the DRDA Gateway Package
  • 14.4.1 DRDA Gateway Package Binding Considerations
  • 14.4.2 DRDA Gateway Package Binding Steps
• 14.5 Create Tables and Views for Data Dictionary Support
• 14.6 Grant Authority to the DRDA Package
• 14.7 Configure the Oracle Database for Gateway Access
  • 14.7.1 Configuring tnsnames.ora
• 14.8 Create Database Links
• 14.9 Configure the Gateway to Access Multiple DRDA Databases
  • 14.9.1 Multiple DRDA Databases Example: Configuring the Gateway
  • 14.9.2 Multiple DRDA Databases Example: Configuring Oracle Net Listener
  • 14.9.3 Multiple DRDA Databases Example: Stopping and Starting the Oracle Net Listener
  • 14.9.4 Multiple Databases Example: Configuring Oracle Database for Gateway Access
    • 14.9.4.1 Configuring Oracle Net for Multiple Gateway Instances
  • 14.9.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/OS390
    • 15.4.1.2 DB2/400
    • 15.4.1.3 DB2/Universal Database
• 15.5 Passwords in the Gateway Initialization File

16 Migration From Previous Releases

• 16.1 Install the New Release
• 16.2 Copy the Gateway Initialization Parameter File
• 16.3 Update the Initialization Parameters
  • 16.3.1 Changed Parameters
  • 16.3.2 Obsolete Parameters
• 16.4 Bind Gateway Package
• 16.5 Install/Upgrade Data Dictionary Views

Part VIII Removing Oracle Database Gateway

17 Removing Oracle Database Gateway

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_CALL_NAME
  • C.8.2 HS_DB_DOMAIN
  • C.8.3 HS_DB_INTERNAL_NAME
  • C.8.4 HS_DB_NAME
  • C.8.5 HS_DESCRIBE_CACHE_HWM
  • C.8.6 HS_LANGUAGE
    • C.8.6.1 Character Sets
    • C.8.6.2 Language
    • C.8.6.3 Territory
  • C.8.7 HS_LONG_PIECE_TRANSFER_SIZE
  • C.8.8 HS_OPEN_CURSORS
  • C.8.9 HS_RPC_FETCH_REBLOCKING
  • C.8.10 HS_RPC_FETCH_SIZE
  • C.8.11 HS_TIME_ZONE
  • C.8.12 HS_TRANSACTION_MODEL
  • C.8.13 IFILE
  • C.8.14 HS_FDS_CONNECT_INFO
  • C.8.15 HS_FDS_DEFAULT_OWNER
  • C.8.16 HS_FDS_PROC_IS_FUNC
  • C.8.17 HS_FDS_RECOVERY_ACCOUNT
  • C.8.18 HS_FDS_RECOVERY_PWD
  • C.8.19 HS_FDS_RESULTSET_SUPPORT
  • C.8.20 HS_FDS_TRACE_LEVEL
  • C.8.21 HS_FDS_TRANSACTION_LOG
  • C.8.22 HS_FDS_SHAREABLE_NAME
  • C.8.23 HS_FDS_REPORT_REAL_AS_DOUBLE
  • C.8.24 HS_FDS_FETCH_ROWS
  • C.8.25 DRDA_CACHE_TABLE_DESC
  • C.8.26 DRDA_CAPABILITY
  • C.8.27 DRDA_CODEPAGE_MAP
  • C.8.28 DRDA_COMM_BUFLEN
  • C.8.29 DRDA_CONNECT_PARM
  • C.8.30 DRDA_DEFAULT_CCSID
  • C.8.31 DRDA_DESCRIBE_TABLE
  • C.8.32 DRDA_DISABLE_CALL
  • C.8.33 DRDA_FLUSH_CACHE
  • C.8.34 DRDA_GRAPHIC_CHAR_SIZE
  • C.8.35 DRDA_GRAPHIC_PAD_SIZE
  • C.8.36 DRDA_GRAPHIC_LIT_CHECK
  • C.8.37 DRDA_GRAPHIC_TO_MBCS
  • C.8.38 DRDA_ISOLATION_LEVEL
  • C.8.39 DRDA_LOCAL_NODE_NAME
  • C.8.40 DRDA_MBCS_TO_GRAPHIC
  • C.8.41 DRDA_OPTIMIZE_QUERY
  • C.8.42 DRDA_PACKAGE_COLLID
  • C.8.43 DRDA_PACKAGE_CONSTOKEN
  • C.8.44 DRDA_PACKAGE_NAME
  • C.8.45 DRDA_PACKAGE_OWNER
  • C.8.46 DRDA_PACKAGE_SECTIONS
  • C.8.47 DRDA_READ_ONLY
  • C.8.48 DRDA_RECOVERY_PASSWORD
  • C.8.49 DRDA_RECOVERY_USERID
  • C.8.50 DRDA_REMOTE_DB_NAME
  • C.8.51 FDS_CLASS
  • C.8.52 HS_NLS_NCHAR
  • C.8.53 LOG_DESTINATION
  • C.8.54 ORA_MAX_DATE
  • C.8.55 ORA_NLS11
  • C.8.56 ORACLE_DRDA_TCTL
  • C.8.57 ORACLE_DRDA_TRACE
  • C.8.58 TRACE_LEVEL
  • C.8.59 HS_NLS_DATE_FORMAT
  • C.8.60 HS_NLS_DATE_LANGUAGE
  • C.8.61 HS_NLS_NUMERIC_CHARACTER

D Configuration Worksheet for DRDA

E Globalization Support for DRDA

• E.1 Overview of Globalization Support Interactions
• E.2 Client and Oracle Database Configuration
• E.3 Gateway Language Interaction with DRDA Server
  • E.3.1 Gateway Configuration
  • E.3.2 Globalization Support Parameters in the Gateway Initialization File
    • E.3.2.1 HS_LANGUAGE
    • E.3.2.2 HS_NLS_NCHAR
    • E.3.2.3 HS_NLS_DATE_FORMAT
    • E.3.2.4 HS_NLS_DATE_LANGUAGE
• E.4 Gateway Codepage Map Facility
• E.5 Multi-Byte and Double-Byte Support in the Gateway
• E.6 Message Availability
• E.7 Example of Globalization Support Configuration

Index