Go to main content
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
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 from OTN
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.3.2
Configuring tnsnames.ora for Multiple Listeners
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.3.2
Configuring tnsnames.ora for Multiple Listeners
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.3.2
Configuring tnsnames.ora for Multiple Listeners
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.3.2
Configuring tnsnames.ora for Multiple Listeners
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.3.2
Configuring tnsnames.ora for Multiple Listeners
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 UDB for z/OS
13.2
Configuring the DRDA Server for DB2 UDB for iSeries
13.3
Configuring the DRDA Server for DB2 UDB for Linux, Unix, and Windows
13.4
Manual Binding of DRDA Gateway Packages
13.4.1
Manually Binding of Packages for DB2 UDB for z/OS
13.4.2
Manually Binding of Packages for DB2 UDB for Linux, Unix, and Windows
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
Create Tables and Views for Data Dictionary Support
14.5
Configure the Oracle Database for Gateway Access
14.5.1
Configuring tnsnames.ora
14.5.2
Configuring tnsnames.ora for Multiple Listeners
14.6
Create Database Links
14.7
Configure the Gateway to Access Multiple DRDA Databases
14.7.1
Multiple DRDA Databases Example: Configuring the Gateway
14.7.2
Multiple DRDA Databases Example: Configuring Oracle Net Listener
14.7.3
Multiple DRDA Databases Example: Stopping and Starting the Oracle Net Listener
14.7.4
Multiple Databases Example: Configuring Oracle Database for Gateway Access
14.7.4.1
Configuring Oracle Net for Multiple Gateway Instances
14.7.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 UDB for z/OS
15.4.1.2
DB2 UDB for iSeries
15.4.1.3
DB2 UDB for Linux, Unix, and Windows
15.5
Passwords in the Gateway Initialization File
16
Migration From Previous Releases
16.1
Install the New Release
16.2
Gateway Initialization Parameter File
16.3
Bind Gateway Package
16.4
Install/Upgrade Data Dictionary Views
Part VIII Removing Oracle Database Gateway
17
Removing Oracle Database Gateway
17.1
About the Deinstallation Tool
17.2
Removing Oracle Software
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_TIME_ZONE
C.8.2
HS_FDS_PROC_IS_FUNC
C.8.3
HS_FDS_RESULTSET_SUPPORT
C.8.4
HS_FDS_SHAREABLE_NAME
C.8.5
HS_FDS_REPORT_REAL_AS_DOUBLE
C.8.6
HS_CALL_NAME
C.8.7
HS_DB_DOMAIN
C.8.8
HS_DB_INTERNAL_NAME
C.8.9
HS_DB_NAME
C.8.10
HS_DESCRIBE_CACHE_HWM
C.8.11
HS_LANGUAGE
C.8.11.1
Character Sets
C.8.11.2
Language
C.8.11.3
Territory
C.8.12
HS_LONG_PIECE_TRANSFER_SIZE
C.8.13
HS_OPEN_CURSORS
C.8.14
HS_RPC_FETCH_REBLOCKING
C.8.15
HS_RPC_FETCH_SIZE
C.8.16
HS_TRANSACTION_MODEL
C.8.17
IFILE
C.8.18
HS_FDS_CONNECT_INFO
C.8.19
HS_FDS_DEFAULT_OWNER
C.8.20
HS_FDS_RECOVERY_ACCOUNT
C.8.21
HS_FDS_RECOVERY_PWD
C.8.22
HS_FDS_TRACE_LEVEL
C.8.23
HS_FDS_TRANSACTION_LOG
C.8.24
HS_FDS_FETCH_ROWS
C.8.25
HS_FDS_CAPABILITY
C.8.26
HS_FDS_ISOLATION_LEVEL
C.8.27
HS_FDS_PACKAGE_COLLID
C.8.28
HS_IDLE_TIMEOUT
C.8.29
HS_FDS_MBCS_TO_GRAPHIC
C.8.30
HS_FDS_GRAPHIC_TO_MBCS
C.8.31
HS_FDS_TIMESTAMP_MAPPING
C.8.32
HS_FDS_QUOTE_IDENTIFIER
C.8.33
HS_NLS_LENGTH_SEMANTICS
C.8.34
HS_KEEP_REMOTE_COLUMN_SIZE
C.8.35
HS_FDS_RESULTSET_SUPPORT
C.8.36
HS_FDS_REMOTE_DB_CHARSET
C.8.37
HS_FDS_SUPPORT_STATISTICS
C.8.38
HS_FDS_RSET_RETURN_ROWCOUNT
C.8.39
HS_FDS_SQLLEN_INTERPRETATION
C.8.40
HS_FDS_AUTHENTICATE_METHOD
C.8.41
HS_FDS_ENCRYPT_SESSION
C.8.42
HS_FDS_TRUSTSTORE_FILE
C.8.43
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.