Gateway products are based on Heterogeneous Services and allow access
to non-Oracle databases from Oracle products.
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 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 -
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
- Teradata - Database Gateway for Teradata (DG4Teradata)
Websphere MQ - Database Gateway for Websphere MQ (DG4MQ)
online transaction processors (OLTPs) - Database Gateway for APPC
- IMS - Database Gateway for IMS (DG4IMS)
- VSAM -
Database Gateway for VSAM (Dg4VSAM)
- Adabas - Database Gateway for
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 -
Options for Connecting to Foreign Data Stores and Non-Oracle Databases -
For example - DB2, SQL*Server, Sybase, Informix, Teradata, MySQL
differences in the functionality and licensing of the Database Gateway
for ODBC and the other gateways which are discussed in these notes -
Note.252364.1 Functional Differences Between Generic Connectivity and Database
Note.232482.1 Gateway and Generic Connectivity Licensing Considerations
following note has information about the desupport of earlier gateway
Desupport of Oracle Transparent Gateways
Note.353723.1 Oracle Transparent Gateway for iWay
Note.209768.1 Database, FMW, EM Grid Control, and OCS Software Error Correction Support Policy
Lifetime Support Policy document is available here:
For information about the Gateway support policy refer to the section -
Oracle Gateway Release's
certification matrix for the 11.1 and 11.2 Gateways is now available
on OTN from the following URL -
Database Gateways Certification Matrix (PDF)
Database Gateways Certification Matrix (PDF)
Legacy Database Gateways
Certification Matrix (PDF)
Please note that the Legacy Gateways -
can no longer be ordered. They will still be available on install media but will be decommissioned.
Before trying to download a Gateway please refer to the certification
matrix to make sure it is available for your platform and version.
Gateway products can be downloaded from the following -
- go through the Terms & Restriction proces
on the next screen ' Media Pack Search' screen choose -
Product Pack - Oracle database
- then choose your platform
choose the 'Oracle database' media pack for the version you need - 11.1
- on the next screen there will be a gateway media pack to
The following note has links to a video showing how to download gateways -
Note.1279746.1 Where Can I Find And Download the Latest Gateways Available From Oracle?
3. My Oracle Support - 188.8.131.52 and 184.108.40.206
The 220.127.116.11 and 18.104.22.168 versions of the gateways are included in the Oracle Database patch sets 10098816 and 10404530.
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 or 184.108.40.206 versions. The later versions can be installed
in completely separate ORACLE_HOME directories from any existing
To download the latest 220.127.116.11 gateways -
confirm which file is needed for the Gateways review the 'README' file
which details which download files contain which software.
The 18.104.22.168 patch is also available for some platforms and can be found as patch 10404530 on My Oracle Support.
The installation and configuration for each gateway is
described in the documentation.
This is available from -
on the version required - 11.1 or 11.2 - then 'View Library'
Gateway documentation is available from the 'Information Integration'
option under the 'Heterogeneous Connectivity' heading.
The following note gives an overview of the Gateway install process -
Note.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
- logon to MOS -
- Oracle Database Products
- Oracle Database
- then choose the relevant gateway
Examples are -
Note.437374.1 How to Configure DG4MSQL (Oracle Database Gateway for MS SQL Server) Release 11 on Linux x86 32bit post install
following note details some of the common errors and solutions for
Gateway issues -
Note.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 -
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
- platform and version where the gateway is installed
version of the Oracle RDBMS being used to access the gateway
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 -
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 -
Note.221136.1 How To Trace DRDA Gateway (TG4DRDA or DG4DRDA) On Unix 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
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