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