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 IBM AIX on POWER Systems (64-Bit), Linux x86-64, Oracle Solaris on SPARC (64-Bit), Oracle Solaris on x86-64 (64-Bit), and HP-UX Itanium

  • 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
      • Oracle Database Gateway Upgrades
      • Accessing the Installation Software
        • Downloading Oracle Software from the OTN Web Site
          • Download the Installation Archive Files from OTN
          • Extract the Installation Files
        • 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
          • Operating System
          • Certified Configuration
        • Checking the Software Requirements
      • 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
          • Configuring Oracle Net for Multiple Gateway Instances
        • 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
          • Operating System
          • Certified Configuration
        • Checking the Software Requirements
      • 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
          • Configuring Oracle Net for Multiple Gateway Instances
        • 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
          • Operating System
          • Certified Configuration
        • Checking the Software Requirements
      • 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 Teradata Databases Example: Stopping and Starting the Oracle Net Listener
        • Multiple Teradata Databases Example: Configuring Oracle Database for Gateway Access
          • Configuring Oracle Net for Multiple Gateway Instances
        • 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
          • Operating System
          • Certified Configuration
        • Checking the Software Requirements
      • 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
          • Configuring Oracle Net for Multiple Gateway Instances
        • 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
          • Operating System
          • Certified Configuration
        • Checking the Software Requirements
      • 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
          • Operating System
          • Certified Configuration
        • Checking the Software Requirements
      • 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 Databases Example: Configuring Oracle Database for Gateway Access
          • Configuring Oracle Net for Multiple Gateway Instances
        • 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
      • Gateway Initialization Parameter File
      • 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
  • A Using Response Files for Noninteractive Installation
    • Introduction
      • Installation Overview
    • Creating the oraInst.loc File
    • Preparing a Response File
      • Editing a Response File Template
      • Recording a Response File
    • Running Oracle Universal Installer in Silent or Suppressed Mode
  • B Oracle Database Gateway Troubleshooting
    • Verify Requirements
    • What to Do if an Installation Error Occurs
    • Reviewing the Log of an Installation Session
    • Troubleshooting Configuration Assistants
      • Configuration Assistant Failure
      • Fatal Errors
    • Silent-Mode 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_TIME_ZONE
    • HS_FDS_PROC_IS_FUNC
    • HS_FDS_RESULTSET_SUPPORT
    • HS_FDS_SHAREABLE_NAME
    • HS_FDS_REPORT_REAL_AS_DOUBLE
    • 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_TRANSACTION_MODEL
    • IFILE
    • HS_FDS_CONNECT_INFO
    • HS_FDS_RECOVERY_ACCOUNT
    • HS_FDS_RECOVERY_PWD
    • HS_FDS_TRACE_LEVEL
    • HS_FDS_TRANSACTION_LOG
    • 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_RESULTSET_SUPPORT
    • 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. Installing and Configuring Oracle Database Gateway for SQL Server

Part V Installing and Configuring Oracle Database Gateway for SQL Server

Installing and Configuring Oracle Database Gateway for SQL Server describes how to install and configure Oracle Database Gateway for SQL Server on UNIX based platforms.

  • Installing Oracle Database Gateway for SQL Server

  • Configuring Oracle Database Gateway for SQL Server

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