Master Note for Oracle Gateway Products
(Doc ID 1083703.1)
Last updated on FEBRUARY 28, 2020
Applies to:Oracle Database Cloud Service - Version N/A and later
Oracle Database Gateway for Sybase - Version 220.127.116.11 to 18.104.22.168 [Release 11.1 to 12.1]
Oracle Database Gateway for SQL Server - Version 22.214.171.124 to 126.96.36.199 [Release 11.1 to 12.1]
Oracle Database Gateway for WebSphere MQ - Version 188.8.131.52 to 184.108.40.206 [Release 11.1 to 12.1]
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
The full list of Gateways is -
Database Gateway for SQL Server - 220.127.116.11 to 18.104.22.168
Database Gateway for DRDA - 10.2.0.1 to 22.214.171.124
Database Gateway for ODBC - 126.96.36.199 to 188.8.131.52
Database Gateway for Sybase - 184.108.40.206 to 220.127.116.11
Database Gateway for Informix - 18.104.22.168 to 22.214.171.124
Database Gateway for Teradata - 126.96.36.199 to 188.8.131.52
Database Gateway for WebSphere MQ - 184.108.40.206 to 220.127.116.11
Database Gateway for APPC - 18.104.22.168 to 22.214.171.124
To provide customers with the information they need to download, install and configure Oracle Gateway products.
SCOPE & APPLICATION
This document is intended to assist customers in installing and configuring Oracle Gateway products. This document covers the following topics:
Master Note for Oracle Gateway Products
1. Concepts and Availability
Oracle Gateway products are based on Heterogeneous Services and allow access to non-Oracle databases from Oracle products.
Heterogeneous Services provides the generic technology for connecting to non-Oracle systems. As an integrated component of the database, Heterogeneous Services can exploit features of the database, such as the powerful SQL parsing and distributed optimization capabilities.
Heterogeneous Services can be used for select, insert, update and delete statements against non-Oracle databases.
Heterogeneous Services extend the Oracle SQL engine to recognize the SQL and procedural capabilities of the remote non-Oracle system and the mappings required to obtain necessary data dictionary information.
There are dedicated Gateways for the following non-Oracle data sources -
- Microsoft SQL*Server - Database Gateway for SQL*Server (DG4Msql)
- Sybase - Database Gateway for Sybase (DG4Sybase)
- Informix - Database Gateway for Informix (DG4Ifmx)
- IBM DB2 - Database Gateway for DRDA (DG4DRDA)
- Teradata - Database Gateway for Teradata (DG4Teradata)
- Websphere MQ - Database Gateway for Websphere MQ (DG4MQ)
- Remote online transaction processors (OLTPs) - Database Gateway for APPC (DG4APPC)
It is also possible to connect to IBM Websphere MQ using the Oracle Messaging Gateway (MGW). The following note has details about the DG4MQ and MGW -
Non-Oracle datasources for which a dedicated gateway is not available can be accessed by using the following -
Database Gateway for ODBC (DG4ODBC)
which uses third party ODBC drivers to make the connection to non-Oracle data sources such as as MySQL, Progress, Ingres.
It can also be used to access non-Oracle databases for which a dedicated gateway is available.
Further details are available in this note -
There are differences in the functionality and licensing of the Database Gateway for ODBC and the other gateways which are discussed in these notes -
<Document 232482.1> Database Gateway and Generic Connectivity (DG4ODBC) Licensing Considerations
The following notes have information about the desupport of earlier gateway versions -
<Document 353723.1> Oracle Transparent Gateway for iWay
<Document 353728.1> Oracle Transparent Gateway for INGRES
<Document 353725.1> Oracle Transparent Gateway for Rdb
<Document 353729.1> Oracle Transparent Gateway for RMS
<Document 417250.1> Oracle Transparent Gateway for INFORMIX
<Document 417253.1> Oracle Transparent Gateway for SYBASE
<Document 417254.1> Oracle Transparent Gateway for MS SQL Server
<Document 417251.1> Oracle Transparent Gateway for TERADATA
<Document 420436.1> Oracle Transparent Gateway for DRDA - SNA Support desupport
<Document 559947.1> Oracle Access Manager for AS/400
<Document 559948.1> Oracle Transparent Gateway for DB2/400
Oracle's Software Error Correction Support policy document is available in this note -
For information about the Gateway support policy refer to the section -
Oracle Gateway Release's
The certification matrix for gateway version 11.2 and later can be found in:
Certification Matrix for Oracle Database Gateway Products versions 11.2.x and greater(Doc ID 2617521.1)
Database Gateways Certification Matrix (PDF)
Mainframe Database Gateways Certification Matrix (PDF)
can no longer be ordered. They may still be available on install media but will be decommissioned.
The latest and most up to date Gateway certification information is available on My Oracle Support (MOS) :-
Once signed in to MOS :-
- click on the 'More...' tab if necessary
- choose 'Certifications'
- then choose Product, Release and Platform from the drop down lists.
2. Downloading Gateway Products
Before trying to download a Gateway please refer to the certification matrix to make sure it is available for your platform and version.
Oracle Gateway products can be downloaded from the following -
1. Oracle Technology Network - OTN -
Choose the relevant platform and version then the 'See All' option.
Under that there will be an option to download the Gateway products, for example -
Oracle Database Gateways 11g Release 2 (126.96.36.199.0) for Microsoft Windows (32-bit)
Please note that only 11.2 versions of the Gateway products are available on Windows 64-bit. The earlier versions are not available on that platform.
If this is the first install of a Gateway then it is recommended that you install the latest version - currently 188.8.131.52 - following the steps in Section 3 below.
The 12c Gateways are also available on some platforms.
2. Oracle Software Delivery Cloud
- on the next screen ' Media Pack Search' screen choose -
Select a Product Pack - Oracle database
- then choose your platform
- choose the 'Oracle database' media pack for the version you need - 11.2, 12.1, 12.2
- on the next screen there will be a gateway media pack to download.
The following note has links to information and a video showing how to download gateways -
3. My Oracle Support - 184.108.40.206 and 220.127.116.11
The 18.104.22.168 version of the gateway is included in the Oracle Database patch set 13390677.
Starting with the 22.214.171.124 patch set, Oracle Database patch sets are full installations of the Oracle Database software. This means that you do not need to install a 126.96.36.199 release of a gateway before installing the 188.8.131.52, 184.108.40.206 or 220.127.116.11 versions. The later versions can be installed in completely separate ORACLE_HOME directories from any existing installs.
To download the latest 18.104.22.168 gateways -
- go to Patches & Updates section
- search for patch number 13390677 and choose your platform
- click on the patch number
- for most platforms for the gateways you only need to download -
for example -
but for Windows 32-bit this is -
To download the latest 22.214.171.124 gateways -
- logon to My Oracle Support
- go to Patches & Updates section
- search for patch number 21419221 and your platform
- you may need to press the '+' button to see the platform list
- click on the patch number
- from the download screen you only need to download the following for the gateways -
You only need to download the file 8of10 - Oracle Gateways - p21419221_121020_platform_8of10.zip
To confirm which file is needed for the Gateways review the 'README' file which details which download files contain which software.
3. Installation and Configuration
The installation and configuration for each gateway is described in the documentation.
This is available from -
- 'Database' option
- All Oracle Database documentation
- choose the version you require from the dropdown list
- then 'Integrating Information'
- Gateway documentation is under the 'Heterogeneous Connectivity' heading
The following note gives an overview of the Gateway install process -
There are also notes available in My Oracle Support (MOS) to help with the install and configuration -
- Knowledge tab
- make sure you have enabled 'Browse Knowledge' in Customize
- in 'Find a Product by Name' enter 'gateway' - without the quotes
- then choose the relevant gateway
- continue in the 'What do you want to do' section
Examples are -
<Document 466267.1> How to Configure DG4MSQL (Database Gateway for MS SQL Server) on Windows 32bit post install
<Document 562509.1> How to Configure DG4MSQL (Oracle Database Gateway for MS SQL Server) 64bit Unix OS (Linux, Solaris, AIX,HP-UX) post install
<Document 1086365.1> How to Configure DG4MSQL (Database Gateway for MS SQL Server) on a 64bit Windows post install
<Document 466228.1> How to Configure DG4ODBC on Linux x86 32bit to Connect to Non-Oracle Databases post install
<Document 561033.1> How to Configure DG4ODBC on 64bit Unix OS (Linux, Solaris, AIX, HP-UX) to Connect to Non-Oracle Databases Post Install
<Document 466225.1> How to Configure DG4ODBC (Oracle Database Gateway for ODBC) on Windows 32bit to Connect to Non-Oracle Databases Post Install
<Document 1266572.1> How to Configure DG4ODBC (Oracle Database Gateway for ODBC) on 64bit Windows Operating Systems to Connect to Non-Oracle Databases Post Install
<Document 945879.1> How to Setup DG4DRDA (Oracle Database Gateway for DRDA) Release 11.2 on Unix (Linux, AIX, HP-UX Itanium and Solaris) to Connect to DB2
<Document 1086359.1> How to Setup DG4DRDA (Oracle Database Gateway for DRDA) on Windows x86 (32bit and 64bit) to Connect to DB2
<Document 437689.1> How to Configure DG4IFMX (Oracle Database Gateway for Informix) Release 11 on Unix OS (Linux, Solaris, AIX,HP-UX) Post Install
<Document 437696.1> How to Configure DG4SYBS (Oracle Database Gateway for Sybase) Release 11 Unix (Linux, AIX, HP-UX Itanium and Solaris) Post Install
<Document 554402.1> How to Setup DG4TERA (Oracle Database Gateway for TeraData) on Windows 32bit
<Document 823534.1> How to Setup DG4Tera (Oracle Database Gateway for TeraData) on 64bit Unix
<Document 437680.1> How to Setup DG4Tera (Oracle Database Gateway for TeraData) Release 11 on Linux
<Document 564299.1> How to Install DG4MQ on Linux
but new notes are continually being added.
The following notes have details of a configuration utility for the relevant gateway -
<Document 1286444.1> Gateway Configuration Utility for Database Gateway for DRDA - DG4DRDA - to Connect to DB2
<Document 1286435.1> Gateway Configuration Utility for Database Gateway for Sybase
The following notes has information and links to further notes about National Language Support (NLS) and Gateways -
The following note has details about securing links for DG4MSQL using Windows authentication and SSL -
The following note has details for setting up DG4DRDA to use SSL -
The following note details some of the common errors and solutions for Gateway issues -
The following note details causes of some ORA-7445 errors -
If you need to raise a service request with Oracle Support then the following information is needed to help speed up resolution -
- name and full version of the gateway being used
- platform and version where the gateway is installed
- version of the Oracle RDBMS being used to access the gateway
- name and full version of the non-Oracle data source being accessed
- configuration files and information -
create database link statement
- statement causing the error
- full error being received from SQLPLUS when running the problem statement
- a gateway debug trace file from running the problem statement. This is created by adding the following to the gateway init<sid..ora file -
and running the problem statement from a new session. It is not necessary to stop and start the listener for this to take effect.
- note that for DG4DRDA 11.1 there is a different procedure for setting up debug tracing which is described in the documentation and also in these notes -
<Document 428387.1> How To Trace The Transparent Gateway For DRDA (TG4DRDA) On Windows Platforms
Common Gateway error messages are -
ORA-28500 connection from ORACLE to a non-Oracle system returned this message:
ORA-02063 preceding <str> from <name>
ORA-28511 lost RPC connection to heterogeneous remote agent using
ORA-02085 database link %s connects to %s
ORA-02062 distributed recovery received DBID <num>, expected <num >
ORA-02019 connection description for remote database not found
ORA-28513 internal error in heterogeneous remote agent
ORA-28500 connection from ORACLE to a non-Oracle system returned this message
Alert notes for Gateway products are available in My Oracle Support.
To access alert notes do the following -
- choose the Knowledge tab
- In 'Knowledge Articles' click the pencil icon
- in the 'Product' option enter - gateway
- choose the gateway you want to see
- a list will be displayed if there is an alert
- there will also be a list of recently updated articles for the gateway
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|SCOPE & APPLICATION|
|1. Concepts and availability|
|2. Downloading Gateway products|
|3. Installation and configuration|
|Master Note for Oracle Gateway Products|
|1. Concepts and Availability|
|2. Downloading Gateway Products|
|1. Oracle Technology Network - OTN -|
|2. Oracle Software Delivery Cloud|
|3. Installation and Configuration|