Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
-
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.3 Installation Considerations
- 1.4 Oracle Database Gateway Upgrades
- 1.5 Accessing the Installation Software
- 1.6 Running the Oracle Universal Installer
- 1.7 Installing and Configuring in Cluster Environments
-
1
Overview of the Oracle Database Gateway Installation
-
Part II Installing and Configuring Oracle Database Gateway for Sybase
- 2 Installing Oracle Database Gateway for Sybase
-
3
Configuring Oracle Database Gateway for Sybase
- 3.1 Configure the Gateway Initialization Parameter File
- 3.2 Configure Oracle Net for the Gateway
- 3.3 Configure the Oracle Database for Gateway Access
- 3.4 Create Database Links
- 3.5 Configure Two-Phase Commit
- 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.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
-
5
Configuring Oracle Database Gateway for Informix
- 5.1 Configure the Gateway Initialization Parameter File
- 5.2 Configure Oracle Net for the Gateway
- 5.3 Configure the Oracle Database for Gateway Access
- 5.4 Create Database Links
- 5.5 Configure Two-Phase Commit
- 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.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
-
7
Configuring Oracle Database Gateway for Teradata
- 7.1 Configure the Gateway Initialization Parameter File
- 7.2 Configure Oracle Net for the Gateway
- 7.3 Configure the Oracle Database for Gateway Access
- 7.4 Create Database Links
- 7.5 Configure Two-Phase Commit
- 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 Teardata Databases Example: Stopping and Starting the Oracle Net Listener
- 7.7.4 Multiple Teradata Databases Example: Configuring Oracle Database for Gateway Access
- 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
-
9
Configuring Oracle Database Gateway for SQL Server
- 9.1 Configure the Gateway Initialization Parameter File
- 9.2 Configure Oracle Net for the Gateway
- 9.3 Configure the Oracle Database for Gateway Access
- 9.4 Create Database Links
- 9.5 Configure Two-Phase Commit
- 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.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
-
11
Configuring Oracle Database Gateway for ODBC
- 11.1 Configure the Gateway Initialization Parameter File
- 11.2 Configure Oracle Net for the Gateway
- 11.3 Configure the Oracle Database for Gateway Access
- 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
- 13 Configuring the DRDA Server
-
14
Configuring Oracle Database Gateway for DRDA
- 14.1 Configure the Gateway Initialization Parameter File
- 14.2 Configure Oracle Net 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.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 DRDA Databases Example: Configuring Oracle Database for Gateway Access
- 14.7.5 Multiple DRDA Databases Example: Accessing DB2 Data
- 15 Security Considerations
- 16 Migrating From Previous Releases
- Part VIII Removing Oracle Database Gateway
- Part IX Appendixes
- A Using Response Files for Noninteractive Installation
- B Oracle Database Gateway Troubleshooting
-
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 HS_CALL_NAME
- C.9 HS_DB_DOMAIN
- C.10 HS_DB_INTERNAL_NAME
- C.11 HS_DB_NAME
- C.12 HS_DESCRIBE_CACHE_HWM
- C.13 HS_LANGUAGE
- C.14 HS_LONG_PIECE_TRANSFER_SIZE
- C.15 HS_OPEN_CURSORS
- C.16 HS_RPC_FETCH_REBLOCKING
- C.17 HS_RPC_FETCH_SIZE
- C.18 HS_FDS_SHAREABLE_NAME
- C.19 HS_TIME_ZONE
- C.20 HS_TRANSACTION_MODEL
- C.21 IFILE
- C.22 HS_FDS_CONNECT_INFO
- C.23 HS_FDS_PROC_IS_FUNC
- C.24 HS_FDS_RECOVERY_ACCOUNT
- C.25 HS_FDS_RECOVERY_PWD
- C.26 HS_FDS_RESULTSET_SUPPORT
- C.27 HS_FDS_TRACE_LEVEL
- C.28 HS_FDS_TRANSACTION_LOG
- C.29 HS_FDS_REPORT_REAL_AS_DOUBLE
- C.30 HS_FDS_FETCH_ROWS
- C.31 HS_FDS_CAPABILITY
- C.32 HS_FDS_ISOLATION_LEVEL
- C.33 HS_FDS_PACKAGE_COLLID
- C.34 HS_IDLE_TIMEOUT
- C.35 HS_FDS_MBCS_TO_GRAPHIC
- C.36 HS_FDS_GRAPHIC_TO_MBCS
- C.37 HS_FDS_TIMESTAMP_MAPPING
- C.38 HS_FDS_DATE_MAPPING
- C.39 HS_FDS_ARRAY_EXEC
- C.40 HS_FDS_QUOTE_IDENTIFIER
- C.41 HS_NLS_LENGTH_SEMANTICS
- C.42 HS_KEEP_REMOTE_COLUMN_SIZE
- C.43 HS_FDS_REMOTE_DB_CHARSET
- C.44 HS_FDS_SUPPORT_STATISTICS
- C.45 HS_FDS_RSET_RETURN_ROWCOUNT
- C.46 HS_FDS_SQLLEN_INTERPRETATION
- C.47 HS_FDS_AUTHENTICATE_METHOD
- C.48 HS_FDS_ENCRYPT_SESSION
- C.49 HS_FDS_TRUSTSTORE_FILE
- C.50 HS_FDS_TRUSTSTORE_PASSWORD
- D Configuration Worksheet for Oracle Database Gateway for DRDA
- Index