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
-
Part II Installing and Configuring Oracle Database Gateway for Sybase
- 2 Installing Oracle Database Gateway for Sybase
-
3
Configuring Oracle Database Gateway for Sybase
- Configure the Gateway Initialization Parameter File
- Configure Oracle Net for the Gateway
- Configure the Oracle Database for Gateway Access
- Create Database Links
- Configure Two-Phase Commit
- 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
-
5
Configuring Oracle Database Gateway for Informix
- Configure the Gateway Initialization Parameter File
- Configure Oracle Net for the Gateway
- Configure the Oracle Database for Gateway Access
- Create Database Links
- Configure Two-Phase Commit
- 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
-
7
Configuring Oracle Database Gateway for Teradata
- Configure the Gateway Initialization Parameter File
- Configure Oracle Net for the Gateway
- Configure the Oracle Database for Gateway Access
- Create Database Links
- Configure Two-Phase Commit
- 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
- 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
- Configure the Gateway Initialization Parameter File
- Configure Oracle Net for the Gateway
- Configure the Oracle Database for Gateway Access
- Create Database Links
- Configure Two-Phase Commit
- 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
-
11
Configuring Oracle Database Gateway for ODBC
- Configure the Gateway Initialization Parameter File
- Configure Oracle Net for the Gateway
- Configure the Oracle Database for Gateway Access
- 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
- 13 Configuring the DRDA Server
-
14
Configuring Oracle Database Gateway for DRDA
- Configure the Gateway Initialization Parameter File
- Configure Oracle Net for the Gateway
- Configure Two-Phase Commit
- Create Tables and Views for Data Dictionary Support
- Configure the Oracle Database for Gateway Access
- 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
- Multiple DRDA Databases Example: Accessing DB2 Data
- 15 Security Considerations
- 16 Migrating From Previous Releases
- Part VIII Removing Oracle Database Gateway
- A Using Response Files for Noninteractive Installation
- B Oracle Database Gateway Troubleshooting
-
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
- 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