Oracle Gateway uses share

Source: Internet
Author: User
Tags db2


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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.