-
Master Notes
July 5, 2010
Oracle Gateway Master Note (Doc ID 1083703.1)
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 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.353728.1 Oracle Transparent Gateway for INGRES
Note.353725.1 Oracle Transparent Gateway for Rdb
Note.353729.1 Oracle Transparent Gateway for RMS
Note.417250.1 Oracle Transparent Gateway for INFORMIX
Note.417253.1 Oracle Transparent Gateway for SYBASE
Note.417254.1 Oracle Transparent Gateway for MS SQL Server
Note.417251.1 Oracle Transparent Gateway for TERADATA
Note.420436.1 Oracle Transparent Gateway for DRDA - SNA Support desupport
Note.559947.1 Oracle Access Manager for AS/400
Note.559948.1 Oracle Transparent Gateway for DB2/400
Oracle's Software
Error Correction Support policy document is available in this note -
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.
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.
2. Oracle Software Delivery Cloud
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 -
- go to Patches & Updates section
- search for patch number 10404530 and choose your platform
- click on the patch number
- for most platforms for the gateways you only need to download -
p10404530_112030_platform_5of7.zip
for example -
p10404530_112030_Linux-x86-64_5of7.zip
but for Windows 32-bit this is -
p10404530_112030_WINNT_4of6.zip
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.
3. Installation and
Configuration
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
Note.466267.1
How to Configure DG4MSQL (Database Gateway for MS SQL Server) on Windows 32bit post install
Note.562509.1 How to Configure DG4MSQL (Oracle Database Gateway for MS SQL Server) 64bit Unix OS (Linux, Solaris, AIX,HP-UX) post install
Note.1086365.1 How to Configure DG4MSQL (Database Gateway for MS SQL Server) on a 64bit Windows post install
Note.466228.1
How to Configure DG4ODBC on Linux x86 32bit to Connect to Non-Oracle Databases post install
Note.561033.1 How to Configure DG4ODBC on 64bit Unix OS (Linux, Solaris, AIX, HP-UX) to Connect to Non-Oracle Databases Post Install
Note.466225.1 How to Configure DG4ODBC (Oracle Database Gateway for ODBC) on Windows 32bit to Connect to Non-Oracle Databases Post Install
Note.1266572.1 How
to Configure DG4ODBC (Oracle Database Gateway for ODBC) on 64bit
Windows Operating Systems to Connect to Non-Oracle Databases Post
Install
Note.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
Note.1086359.1 How to Setup DG4DRDA (Oracle Database Gateway for DRDA) on Windows x86 (32bit and 64bit) to Connect to DB2
Note.437689.1 How to Setup DG4IFMX (Oracle Database Gateway for Informix) Release 11
on Linux
Note.437696.1 How to Setup DG4SYBS (Oracle Database Gateway for Sybase) Release 11 on
Linux
Note.554402.1 How to Setup DG4TERA (Oracle Database Gateway for TeraData) on Windows
32bit
Note.823534.1 How to Setup DG4Tera (Oracle Database Gateway for TeraData) on 64bit
Unix
Note.437680.1How to Setup DG4Tera (Oracle Database Gateway for TeraData) Release 11
on Linux
Note.467947.1Setting up Legacy Gateways DG4ADABAS, DG4VSAM, DG4IMS)
Note.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 -
Note.1274157.1 Gateway Configuration Utility for Database Gateway For SQL Server
Note.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
Note.1286444.1 Gateway Configuration Utility for Database Gateway for DRDA - DG4DRDA - to Connect to DB2
Note.1286435.1 Gateway Configuration Utility for Database Gateway for Sybase
4. Troubleshooting
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
Note.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
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
Who to contact for more
information?
Gateway information is available from My Oracle Support (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
There is a My Oracle Support Database Gateways
Community, a place to collaborate with peers in the industry and with
Oracle experts which is live now at:
https://communities.oracle.com/portal/server.pt/community/database_gateways/299
There
is also an Oracle Technology Network forum available at -
http://forums.oracle.com/forums/forum.jspa?forumID=63