Oracle Gateway uses share

Oracle Gateway use share 1, background notes

The company has been encountering heterogeneous database connectivity issues, such as Oracle needs Dblink As400,dblink DB2, if the database version is older, the Linux 64-bit environment to configure the driver of such a database, it is a headache.

You can deploy the gateway to a Windows 32-bit server (which effectively resolves database-driven issues) and ODBC to heterogeneous databases using Oracle Gateway.

Separate the gateway from the DB server and install it separately

Turn on monitoring individually to provide connectivity to databases that need to link heterogeneous servers to the database

New Gateway Server installs Windows 32-bit system to effectively resolve database-driven compatibility issues

2, Architecture description 650) this.width=650; "title=" Gateway.png "alt=" wkiom1jlq_mxv6nqaabuayxukeg102.png-wh_50 "src=" https:// S4.51cto.com/wyfs02/m00/8f/92/wkiom1jlq_mxv6nqaabuayxukeg102.png-wh_500x0-wm_3-wmp_4-s_4139837427.png "/>3, GW Installation and configuration instructions

1, install the server gateway, install only transparent gateway os server 2003 sp2,32 bit    memory 2g  hard disk space 50GB transparent gateway version 11gr2 32 bit 2 , configuring listening 3, installing DB2 and AS400 client programs (providing database driver files) 4, configuring ODBC, and Testing connection normal 5, add and modify transparent Gateway profile (file location in home directory C:\product\11.2.0\tg_1\hs\admin  ) Add a file named Init_sid.ora Note: the names in the SID and ODBC are consistent # this is a sample agent init  File that contains the hs parameters that are# needed for an  odbc agent.## hs init parameters#hs_fds_connect_info = hisphs_fds_trace_ level = off## environment variables required for the non-oracle  system# #set  <envvar>=<value>6, modify tnsnamesc:\product\11.2.0\tg_1\network\adminhisp =    (description =     (address_list =       ( address =  (PROTOCOL&NBSP;=&NBSP;TCP) (Host = gateway server IP) (port = 1521))      ) &NBsp;    (connect_data =       (SID = hisp)      )      (Hs = ok)---------Use the Gateway connection   ) 7, modify the Listener, Restart the monitor sid_list_listener =   (sid_list =     (SID_DESC =        (Global_dbname = hisp)        (oracle_home  = c:\product\11.2.0\tg_1)        (sid_name = hisp)              (PROGRAM&NBSP;=&NBSP;DG4ODBC)-----Note: 9i Transparent gateway The program used here is HS     )   ) The gateway server is now configured to complete

4. Oracle DB Configuration

Simply add the following entry in TNS for requirement db Hisp = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = *.*.*.*) (PORT = 1521 ))---------------------------*.*.*.* is the gateway server (Connect_data = (SID = hisp)) (HS = OK)-------------- Connect using the Gateway method)

5. Test result Description

Test Result: Create dblinkcreate database link WCELPPTP connect to "******" identified by "******" using ' hisp ' Test dblink, test OK Tested: Demand DB no O s version limit, both Windows and Linux can be connected properly

This article is from the "Open World" blog, so be sure to keep this source http://voidyao000.blog.51cto.com/12458042/1913299

Oracle Gateway uses share