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

• Gateway Installation Configurations
• Gateway Installation Methods
  • Interactive Installation Method
  • Automated Installation Method Using Response Files
• Installation Considerations
  • Release Notes
  • Hardware and Software Certification
  • Multiple Oracle Homes
    • Installing the Software on a System with an Existing Oracle Installation
• Upgrades
• Accessing the Installation Software
  • Downloading Oracle Software from the Oracle Technology Network Web Site
  • Copying the Gateway Software to a Hard Disk
• Running the Oracle Universal Installer

Part II Installing and Configuring Oracle Database Gateway for Sybase

2 Installing Oracle Database Gateway for Sybase

• System Requirements for Oracle Database Gateway for Sybase
  • Hardware Requirements
    • Checking the Hardware Requirements
  • Software Requirements
    • Certified Configurations
• Step Through the Oracle Universal Installer

3 Configuring Oracle Database Gateway for Sybase

• Configure the Gateway Initialization Parameter File
  • Choose a System Identifier for the Gateway
  • Customize the Initialization Parameter File
• Configure Oracle Net for the Gateway
  • Configure Oracle Net Listener for the Gateway
    • Syntax of listener.ora File Entries
  • Stop and Start the Oracle Net Listener for the Gateway
• Configure the Oracle Database for Gateway Access
  • Configuring tnsnames.ora
• Create Database Links
• Configure Two-Phase Commit
  • Create a Recovery Account and Password
  • Create the Transaction Log Table
• Create Sybase Views for Data Dictionary Support
• Encrypt Gateway Initialization Parameter Values
• Configure the Gateway to Access Multiple Sybase Databases
  • Multiple Sybase Databases Example: Configuring the Gateway
  • Multiple Sybase Databases Example: Configuring Oracle Net Listener
  • Multiple Sybase Databases Example: Stopping and Starting the Oracle Net Listener
  • Multiple Sybase Databases Example: Configuring Oracle Database for Gateway Access
  • Multiple Sybase Databases Example: Accessing Sybase Data

Part III Installing and Configuring Oracle Database Gateway for Informix

4 Installing Oracle Database Gateway for Informix

• System Requirements for Oracle Database Gateway for Informix
  • Hardware Requirements
    • Checking the Hardware Requirements
  • Software Requirements
    • Certified Configurations
• Step Through the Oracle Universal Installer

5 Configuring Oracle Database Gateway for Informix

• Configure the Gateway Initialization Parameter File
  • Choose a System Identifier for the Gateway
  • Customize the Initialization Parameter File
• Configure Oracle Net for the Gateway
  • Configure Oracle Net Listener for the Gateway
    • Syntax of listener.ora File Entries
  • Stop and Start the Oracle Net Listener for the Gateway
• Configure the Oracle Database for Gateway Access
  • Configuring tnsnames.ora
• Create Database Links
• Configure Two-Phase Commit
  • Create a Recovery Account and Password
  • Create the Transaction Log Table
• Encrypt Gateway Initialization Parameter Values
• Configure the Gateway to Access Multiple Informix Databases
  • Multiple Informix Databases Example: Configuring the Gateway
  • Multiple Informix Databases Example: Configuring Oracle Net Listener
  • Multiple Informix Databases Example: Stopping and Starting the Oracle Net Listener
  • Multiple Informix Databases Example: Configuring Oracle Database for Gateway Access
  • Multiple Informix Databases Example: Accessing Informix Data

Part IV Installing and Configuring Oracle Database Gateway for Teradata

6 Installing Oracle Database Gateway for Teradata

• System Requirements for Oracle Database Gateway for Teradata
  • Hardware Requirements
    • Checking the Hardware Requirements
  • Software Requirements
    • Certified Configurations
• Step Through the Oracle Universal Installer

7 Configuring Oracle Database Gateway for Teradata

• Configure the Gateway Initialization Parameter File
  • Choose a System Identifier for the Gateway
  • Customize the Initialization Parameter File
• Configure Oracle Net for the Gateway
  • Configure Oracle Net Listener for the Gateway
    • Syntax of listener.ora File Entries
  • Stop and Start the Oracle Net Listener for the Gateway
• Configure the Oracle Database for Gateway Access
  • Configuring tnsnames.ora
• Create Database Links
• Configure Two-Phase Commit
  • Create a Recovery Account and Password
  • Create the Transaction Log Table
• Encrypt Gateway Initialization Parameter Values
• Configure the Gateway to Access Multiple Teradata Databases
  • Multiple Teradata Databases Example: Configuring the Gateway
  • Multiple Teradata Databases Example: Configuring Oracle Net Listener
  • Multiple Teardata Databases Example: Stopping and Starting the Oracle Net Listener
  • Multiple Teradata Databases Example: Configuring Oracle Database for Gateway Access
  • 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

• System Requirements for Oracle Database Gateway for SQL Server
  • Hardware Requirements
    • Checking the Hardware Requirements
  • Software Requirements
    • Certified Configurations
• Step Through the Oracle Universal Installer

9 Configuring Oracle Database Gateway for SQL Server

• Configure the Gateway Initialization Parameter File
  • Choose a System Identifier for the Gateway
  • Customize the Initialization Parameter File
• Configure Oracle Net for the Gateway
  • Configure Oracle Net Listener for the Gateway
    • Syntax of listener.ora File Entries
  • Stop and Start the Oracle Net Listener for the Gateway
• Configure the Oracle Database for Gateway Access
  • Configuring tnsnames.ora
• Create Database Links
• Configure Two-Phase Commit
  • Create a Recovery Account and Password
  • Create the Transaction Log Table
• Create SQL Server Views for Data Dictionary Support
• Encrypt Gateway Initialization Parameter Values
• Configure the Gateway to Access Multiple SQL Server Databases
  • Multiple SQL Server Databases Example: Configuring the Gateway
  • Multiple SQL Server Databases Example: Configuring Oracle Net Listener
  • Multiple SQL Server Databases Example: Stopping and Starting the Oracle Net Listener
  • Multiple SQL Server Databases Example: Configuring Oracle Database for Gateway Access
  • 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

• System Requirements for Oracle Database Gateway for ODBC
  • Hardware Requirements
    • Checking the Hardware Requirements
  • Software Requirements
    • Certified Configurations
• Step Through the Oracle Universal Installer

11 Configuring Oracle Database Gateway for ODBC

• Configure the Gateway Initialization Parameter File
  • Create the Initialization Parameter File
  • Set the Initialization Parameter Values
    • Example: Setting Initialization Parameter Values
• Configure Oracle Net for the Gateway
  • Configure Oracle Net Listener for the Gateway
    • Syntax of listener.ora File Entries
  • Stop and Start the Oracle Net Listener for the Gateway
• Configure the Oracle Database for Gateway Access
  • Configuring tnsnames.ora
• Create Database Links
• Encrypt Gateway Initialization Parameter Values
• Configure the Gateway to Access Multiple ODBC Data Sources
  • Multiple ODBC Data Sources Example: Configuring the Gateway
  • Multiple ODBC Data Sources Example: Configuring Oracle Net Listener
  • Multiple ODBC Data Sources Example: Stopping and Starting the Oracle Net Listener
  • Multiple ODBC Data Sources Example: Configuring Oracle Database for Gateway Access
  • 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

• System Requirements for Oracle Database Gateway for DRDA
  • Hardware Requirements
    • Checking the Hardware Requirements
  • Software Requirements
    • Certified Configurations
• Step Through the Oracle Universal Installer

13 Configuring the DRDA Server

• Configuring the DRDA Server for DB2/OS390
• Configuring the DRDA Server for DB2/400
• Configuring the DRDA Server for DB2/UDB (Universal Database)

14 Configuring Oracle Database Gateway for DRDA

• Configure the Gateway Initialization Parameter File
  • Choose a System Identifier for the Gateway
  • Customize the Initialization Parameter File
• Configure Oracle Net for the Gateway
  • Configure Oracle Net Listener for the Gateway
    • Syntax of listener.ora File Entries
  • Stop and Start the Oracle Net Listener for the Gateway
• Configure Two-Phase Commit
• Bind the DRDA Gateway Package
  • DRDA Gateway Package Binding Considerations
  • DRDA Gateway Package Binding Steps
• Create Tables and Views for Data Dictionary Support
• Grant Authority to the DRDA Package
• Configure the Oracle Database for Gateway Access
  • Configuring tnsnames.ora
• Create Database Links
• Configure the Gateway to Access Multiple DRDA Databases
  • Multiple DRDA Databases Example: Configuring the Gateway
  • Multiple DRDA Databases Example: Configuring Oracle Net Listener
  • Multiple DRDA Databases Example: Stopping and Starting the Oracle Net Listener
  • Multiple DRDA Databases Example: Configuring Oracle Database for Gateway Access
  • Multiple DRDA Databases Example: Accessing DB2 Data

15 Security Considerations

• Security Overview
• Authenticating Application Logons
• Defining and Controlling Database Links
  • Link Accessibility
  • Links and CONNECT Clauses
• Processing Inbound Connections
  • User ID Mapping
    • DB2/OS390
    • DB2/400
    • DB2/Universal Database
• Passwords in the Gateway Initialization File

16 Migration From Previous Releases

• Install the New Release
• Copy the Gateway Initialization Parameter File
• Update the Initialization Parameters
  • Changed Parameters
  • Obsolete Parameters
• Bind Gateway Package
• 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

• Introduction
• Using Response Files to Install Oracle Components in Noninteractive Mode
• Customizing a Sample Response File
• Creating a New Response File
• Running Oracle Universal Installer and Specifying a Response File

B Oracle Database Gateway Troubleshooting

• Verifying Requirements
• What to Do if an Installation Error Occurs
• Reviewing the Log of an Installation Session
• Troubleshooting Configuration Assistants
  • Configuration Assistant Failure
  • Fatal Errors
• Noninteractive Installation Response File Error Handling
• Cleaning Up After a Failed Installation

C Initialization Parameters

• Initialization Parameter File Syntax
• Oracle Database Gateway for Sybase Initialization Parameters
• Oracle Database Gateway for Informix Initialization Parameters
• Oracle Database Gateway for Teradata Initialization Parameters
• Oracle Database Gateway for SQL Server Initialization Parameters
• Oracle Database Gateway for ODBC Initialization Parameters
• Oracle Database Gateway for DRDA Initialization Parameters
• Initialization Parameter Description
  • HS_CALL_NAME
  • HS_DB_DOMAIN
  • HS_DB_INTERNAL_NAME
  • HS_DB_NAME
  • HS_DESCRIBE_CACHE_HWM
  • HS_LANGUAGE
    • Character Sets
    • Language
    • Territory
  • HS_LONG_PIECE_TRANSFER_SIZE
  • HS_OPEN_CURSORS
  • HS_RPC_FETCH_REBLOCKING
  • HS_RPC_FETCH_SIZE
  • HS_TIME_ZONE
  • HS_TRANSACTION_MODEL
  • IFILE
  • HS_FDS_CONNECT_INFO
  • HS_FDS_DEFAULT_OWNER
  • HS_FDS_PROC_IS_FUNC
  • HS_FDS_RECOVERY_ACCOUNT
  • HS_FDS_RECOVERY_PWD
  • HS_FDS_RESULTSET_SUPPORT
  • HS_FDS_TRACE_LEVEL
  • HS_FDS_TRANSACTION_LOG
  • HS_FDS_REPORT_REAL_AS_DOUBLE
  • HS_FDS_FETCH_ROWS
  • DRDA_CACHE_TABLE_DESC
  • DRDA_CAPABILITY
  • DRDA_CODEPAGE_MAP
  • DRDA_COMM_BUFLEN
  • DRDA_CONNECT_PARM
  • DRDA_DEFAULT_CCSID
  • DRDA_DESCRIBE_TABLE
  • DRDA_DISABLE_CALL
  • DRDA_FLUSH_CACHE
  • DRDA_GRAPHIC_CHAR_SIZE
  • DRDA_GRAPHIC_PAD_SIZE
  • DRDA_GRAPHIC_LIT_CHECK
  • DRDA_GRAPHIC_TO_MBCS
  • DRDA_ISOLATION_LEVEL
  • DRDA_LOCAL_NODE_NAME
  • DRDA_MBCS_TO_GRAPHIC
  • DRDA_OPTIMIZE_QUERY
  • DRDA_PACKAGE_COLLID
  • DRDA_PACKAGE_CONSTOKEN
  • DRDA_PACKAGE_NAME
  • DRDA_PACKAGE_OWNER
  • DRDA_PACKAGE_SECTIONS
  • DRDA_READ_ONLY
  • DRDA_RECOVERY_PASSWORD
  • DRDA_RECOVERY_USERID
  • DRDA_REMOTE_DB_NAME
  • FDS_CLASS
  • HS_NLS_NCHAR
  • LOG_DESTINATION
  • ORA_MAX_DATE
  • ORA_NLS11
  • ORACLE_DRDA_TCTL
  • ORACLE_DRDA_TRACE
  • TRACE_LEVEL
  • HS_NLS_DATE_FORMAT
  • HS_NLS_DATE_LANGUAGE
  • HS_NLS_NUMERIC_CHARACTER

D Configuration Worksheet for DRDA

E Globalization Support for DRDA

• Overview of Globalization Support Interactions
• Client and Oracle Database Configuration
• Gateway Language Interaction with DRDA Server
  • Gateway Configuration
  • Globalization Support Parameters in the Gateway Initialization File
    • HS_LANGUAGE
    • HS_NLS_NCHAR
    • HS_NLS_DATE_FORMAT
    • HS_NLS_DATE_LANGUAGE
• Gateway Codepage Map Facility
• Multibyte and Double-Byte Support in the Gateway
• Message Availability
• Example of Globalization Support Configuration

Index