Skip to main content

Sign Out

Sign In

  • Table of Contents
  • Search
  • Print
  • Download
  1. Database
  2. Oracle
  3. Oracle Database
  4. Release 19

Installation and Configuration Guide for Microsoft Windows

  • Table of Contents
  • Search
  • Print
  • Download

Table of Contents

Expand AllCollapse All
  • 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 Support
          • Installing the Software on a System with an Existing Oracle Installation
        • Using Windows User Account as Oracle Home User
        • Support for Windows Group Managed Service Accounts and Virtual Accounts
      • Oracle Database Gateway Upgrades
      • Accessing the Installation Software
        • Downloading Oracle Software from the OTN Web Site
        • Copying the Oracle Software
      • Running the Oracle Universal Installer
      • Installing and Configuring in Cluster Environments
        • Support for Single Client Access Name (SCAN)
        • Local Listener
        • Load Balancing and Transparent Application Failover(TAF)
  • 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
        • Configuring tnsnames.ora for Multiple Listeners
      • 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
        • Configuring tnsnames.ora for Multiple Listeners
      • 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
        • Configuring tnsnames.ora for Multiple Listeners
      • 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
        • Configuring tnsnames.ora for Multiple Listeners
      • 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
        • Configuring tnsnames.ora for Multiple Listeners
      • 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 UDB for z/OS
      • Configuring the DRDA Server for DB2 UDB for iSeries
      • Configuring the DRDA Server for DB2 UDB for Linux, UNIX, and Windows
      • Manual Binding of DRDA Gateway Packages
        • Manually Binding of Packages for DB2 UDB for z/OS
        • Manually Binding of Packages for DB2 UDB for Linux, Unix, and Windows
    • 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
      • Create Tables and Views for Data Dictionary Support
      • Configure the Oracle Database for Gateway Access
        • Configuring tnsnames.ora
        • Configuring tnsnames.ora for Multiple Listeners
      • 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
      • Passwords in the Gateway Initialization File
    • 16 Migrating From Previous Releases
      • Install the New Release
      • Use the New Gateway Initialization Parameter File
      • Update the Initialization Parameters
        • Changed Parameters
        • Obsolete Parameters
      • Bind Gateway Package
      • Install or Upgrade Data Dictionary Views
  • Part VIII Removing Oracle Database Gateway
    • 17 Removing Oracle Database Gateway
      • About the Deinstallation Tool
      • Removing Oracle Software
  • 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
    • 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_FDS_SHAREABLE_NAME
    • HS_TIME_ZONE
    • HS_TRANSACTION_MODEL
    • IFILE
    • HS_FDS_CONNECT_INFO
    • 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
    • HS_FDS_CAPABILITY
    • HS_FDS_ISOLATION_LEVEL
    • HS_FDS_PACKAGE_COLLID
    • HS_IDLE_TIMEOUT
    • HS_FDS_MBCS_TO_GRAPHIC
    • HS_FDS_GRAPHIC_TO_MBCS
    • HS_FDS_TIMESTAMP_MAPPING
    • HS_FDS_DATE_MAPPING
    • HS_FDS_ARRAY_EXEC
    • HS_FDS_QUOTE_IDENTIFIER
    • HS_NLS_LENGTH_SEMANTICS
    • HS_KEEP_REMOTE_COLUMN_SIZE
    • HS_FDS_REMOTE_DB_CHARSET
    • HS_FDS_SUPPORT_STATISTICS
    • HS_FDS_RSET_RETURN_ROWCOUNT
    • HS_FDS_SQLLEN_INTERPRETATION
    • HS_FDS_AUTHENTICATE_METHOD
    • HS_FDS_ENCRYPT_SESSION
    • HS_FDS_TRUSTSTORE_FILE
    • HS_FDS_TRUSTSTORE_PASSWORD
  • D Configuration Worksheet for Oracle Database Gateway for DRDA
  • Index

Search

Print

Download

PDF for offline and print

  • Previous
  • Next
  1. Installation and Configuration Guide
  2. Appendixes

Part IX Appendixes

The Appendixes include information relevant to installing and configuring Oracle Database Gateways.

  • Using Response Files for Noninteractive Installation

  • Oracle Database Gateway Troubleshooting

  • Configuration Worksheet for DRDA

  • Initialization Parameters

  • Previous
  • Next
Back to main content
  • About Oracle
  • Contact Us
  • Terms of Use and Privacy
  • Cookie Preferences
Copyright © 2006, 2019, Oracle and/or its affiliates.
  • Previous
  • Next
Video