1/35
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
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
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
Processing Inbound Connections
User ID Mapping
DB2 UDB for z/OS
DB2 UDB for iSeries
DB2 UDB for Linux, UNIX, and Windows
Passwords in the Gateway Initialization File
16
Migration From Previous Releases
Install the New Release
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
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_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 DRDA
Index
Scripting on this page enhances content navigation, but does not change the content in any way.