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 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)
- IMS - Database Gateway for IMS (DG4IMS)
- VSAM -
Database Gateway for VSAM (Dg4VSAM)
- Adabas - Database Gateway for
Adabas (DG4Adabas)
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 -
Note.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 -
Note.252364.1 Functional Differences Between Generic Connectivity and Database
Gateways
Note.232482.1 Gateway and Generic Connectivity Licensing Considerations
The
following note has information about the desupport of earlier gateway
versions -
Note.549796.1
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
Oracle's
Lifetime Support Policy document is available here:
http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf
For information about the Gateway support policy refer to the section -
Oracle Gateway Release's
The
certification matrix for the 11.1 and 11.2 Gateways is now available
on OTN from the following URL -
http://www.oracle.com/technetwork/database/gateways/index.html
then
-
Database Gateways Certification Matrix (PDF)
Mainframe
Database Gateways Certification Matrix (PDF)
Legacy Database Gateways
Certification Matrix (PDF)
Please note that the Legacy Gateways -
DG4IMS
DG4VSAM
DG4Adabas
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.
Oracle
Gateway products can be downloaded from the following -
http://edelivery.oracle.com/
- go through the Terms & Restriction proces
-
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.1
or 11.2
- on the next screen there will be a gateway media pack to
download.
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 - 11.2.0.2 and 11.2.0.3
The 11.2.0.2 and 11.2.0.3 versions of the gateways are included in the Oracle Database patch sets 10098816 and 10404530.
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 or 11.2.0.3 versions. The later versions can be installed
in completely separate ORACLE_HOME directories from any existing
installs.
To download the latest 11.2.0.3 gateways -
To
confirm which file is needed for the Gateways review the 'README' file
which details which download files contain which software.
The 11.2.0.3 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 -
http://www.oracle.com/technology/documentation/index.html
Click
on the version required - 11.1 or 11.2 - then 'View Library'
The
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
configuration -
- logon to MOS -
http://support.oracle.com
-
Knowledge tab
- Oracle Database Products
- Oracle Database
-
Gateways
- 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
The
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
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 -
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