My Oracle Support Banner

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 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Oracle Database Gateway for SQL Server - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Oracle Database Gateway for WebSphere MQ - Version 11.1.0.6 to 12.1.0.2 [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 - 11.1.0.6 to 12.1.0.2
Database Gateway for DRDA - 10.2.0.1 to 12.1.0.2
Database Gateway for ODBC - 11.1.0.6 to 12.1.0.2
Database Gateway for Sybase - 11.1.0.6 to 12.1.0.2
Database Gateway for Informix - 11.1.0.6 to 12.1.0.2
Database Gateway for Teradata - 11.1.0.6 to 12.1.0.2
Database Gateway for WebSphere MQ - 11.1.0.6 to 12.1.0.2
Database Gateway for APPC - 11.1.0.6 to 12.1.0.2








Details

PURPOSE

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:

1. Concepts and availability

2. Downloading Gateway products

3. Installation and configuration

4. Troubleshooting

5. Alerts

Actions

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 -

<Document 412116.1> Differences Between Oracle Procedural Or Database Gateway For IBM Websphere MQ (MQSeries) and Oracle Messaging Gateway

 
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 -

<Document 233876.1> Options for Connecting to Foreign Data Stores and Non-Oracle Databases - For example - DB2, SQL*Server, Sybase, Informix, Teradata, MySQL


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 252364.1> Functional Differences Between Database Gateway for ODBC (DG4ODBC) and Specific Database Gateways (DG4MSQL, DG4Sybase, DG4Informix, DG4Teradata)
<Document 232482.1> Database Gateway and Generic Connectivity (DG4ODBC) Licensing Considerations


The following notes have information about the desupport of earlier gateway versions -

<Document 549796.1> Desupport of Oracle Transparent Gateways
<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 -

<Document 209768.1> Database, FMW, EM Grid Control, and OCS Software Error Correction Support Policy



Oracle's Lifetime Support Policy document is available here:



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)



The certification matrix for the 11.1, 11.2 and 12c Gateways is now available on OTN from the following URL -


then -

Database Gateways Certification Matrix (PDF)
Mainframe Database Gateways Certification Matrix (PDF)

Please note that the Legacy Gateways -
DG4IMS
DG4VSAM
DG4Adabas

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) :-

http://support.oracle.com

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.

 



Return

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 -


http://www.oracle.com/technology/software/products/database/index.html

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 (11.2.0.1.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 11.2.0.4 - following the steps in Section 3 below.
The 12c Gateways are also available on some platforms.

2. Oracle Software Delivery Cloud


http://edelivery.oracle.com/

- go through the Terms & Restriction process
- 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 -

<Document 1270959.1> How to Download Oracle Database Gateway Products



3. My Oracle Support - 11.2.0.4 and 12.1.0.2

The 11.2.0.4 version of the gateway is included in the Oracle Database patch set 13390677.
Starting with the 11.2.0.2 patch set, Oracle Database patch sets are full installations of the Oracle Database software. This means that you do not need to install a 11.2.0.1 release of a gateway before installing the 11.2.0.2, 11.2.0.3 or 11.2.0.4 versions. The later versions can be installed in completely separate ORACLE_HOME directories from any existing installs.
To download the latest 11.2.0.4 gateways -

- logon to My Oracle Support
- 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 -
p13390677_112040_platform_5of7.zip
for example -
p13390677_112040_Linux-x86-64_5of7.zip
but for Windows 32-bit this is -
p13390677_112040_WINNT_4of6.zip

To download the latest 12.1.0.2 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.


Return

3. Installation and Configuration

The installation and configuration for each gateway is described in the documentation.
This is available from -

https://docs.oracle.com/en/

Click on-

- '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 -

<Document.1351618.1> Installation Overview For Oracle Database Gateway Products


There are also notes available in My Oracle Support (MOS) to help with the install and configuration -

- logon to MOS -

http://support.oracle.com

- 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 437374.1> How to Configure DG4MSQL (Oracle Database Gateway for MS SQL Server) Release 11 on Linux x86 32bit post install
<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 1493988.1> - How to Setup DG4TERA (Oracle Database Gateway for TeraData) on Windows 64bit
<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 1274143.1> Gateway Configuration Utility for Database Gateway for ODBC - DG4ODBC - to Connect to Non-Oracle Databases For Example - DB2, SQL*Server, Sybase, Informix, MySQL
<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 -

<Document 230239.1> NLS Guide for Generic Connectivity and Gateways

 
The following note has details about securing links for DG4MSQL using Windows authentication and SSL -

Oracle Premier Support - Oracle Database Support News - Issue August, 2013 Volume 31 (Doc ID 1584770.1)

 The following note has details for setting up DG4DRDA to use SSL -

How To Enable SSL Encryption with Database Gateway for DRDA (DG4DRDA) 11.2 (Doc ID 975202.1)

 

Return

4. Troubleshooting

The following note details some of the common errors and solutions for Gateway issues -

<Document 234517.1> How to Resolve Common Errors Encountered while using Transparent Gateways or Generic Connectivity


The following note details causes of some ORA-7445 errors -

<Document 1420697.1> ORA-7445 Error Messages Using an Oracle Database Gateway (DG4DRDA, DG4IFMX, DG4MSQL, DG4ODBC, DG4SYBS, DG4TERA)



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 -
gateway listener.ora
gateway init<sid>.ora
tnsnames.ora
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 -
HS_FDS_TRACE_LEVEL=debug
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 221136.1> How To Trace DRDA Gateway (TG4DRDA or DG4DRDA) On Unix platforms
<Document 428387.1> How To Trace The Transparent Gateway For DRDA (TG4DRDA) On Windows Platforms



Common Gateway error messages are -

ORA-28545 error diagnosed by Net8 when connecting to an agent
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


Return

5. Alerts

Alert notes for Gateway products are available in My Oracle Support.
To access alert notes do the following -

- logon to My Oracle Support
- 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

 

Return

Contacts

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
Details
 PURPOSE
  SCOPE & APPLICATION
 1. Concepts and availability
 2. Downloading Gateway products
 3. Installation and configuration
 4. Troubleshooting
 5. Alerts
Actions
 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
 4. Troubleshooting
 5. Alerts
Contacts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.