Set Oracle to Access Multiple SQL servers at the same time

Source: Internet
Author: User

In Oracle, how does one set access to multiple SQL Server databases? Suppose we want to access the default pubs and Northwind databases in SQL Server at the same time in Oracle.

1. on a windows machine with Oracle9i Standard Edition or Oracle9i Enterprise Edition installed (IP: 192.168.0.2), You must select the Transparent Gateway (Oracle Transparent Gateway) to access the Microsoft SQL Server database: initpubs is newly written under ORACLE9I_HOME \ tg4msql \ admin. ora and initnorthwind. ora configuration file.

The content of initpubs. ora is as follows:

       
        HS_FDS_CONNECT_INFO="SERVER=SQLSERVER_HOSTNMAE;DATABASE=pubs" HS_DB_NAME=pubsHS_FDS_TRACE_LEVEL=OFF HS_FDS_RECOVERY_ACCOUNT=RECOVER HS_FDS_RECOVERY_PWD=RECOVER
       

The content of initnorthwind. ora is as follows:

       
        HS_FDS_CONNECT_INFO="SERVER=sqlserver_hostname;DATABASE=Northwind" HS_DB_NAME=Northwind HS_FDS_TRACE_LEVEL=OFF HS_FDS_RECOVERY_ACCOUNT=RECOVER HS_FDS_RECOVERY_PWD=RECOVER
       

The contents of listener. ora under $ ORACLE9I_HOME \ network \ admin are as follows:

       
        LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521)) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = test9) (ORACLE_HOME = d:\oracle\ora92) (SID_NAME = test9) ) (SID_DESC= (SID_NAME=pubs) (ORACLE_HOME=d:\Oracle\Ora92) (PROGRAM=tg4msql) ) (SID_DESC= (SID_NAME=northwind) (ORACLE_HOME=d:\Oracle\Ora92) (PROGRAM=tg4msql) ) )
       

 

Restart the TNSListener service on the gateway-enabled Windows machine (IP: 192.168.0.2) (when you add an accessible SQL Server database following this step, the TNSListener service must be restarted ).

  • 1
  • 2
  • 3
  • Next Page
[Content navigation]
Page 1: Configure Oracle to Access Multiple SQL servers at the same time Page 1: Configure Oracle to Access Multiple SQL servers at the same time
Page 1: Configure Oracle to Access Multiple SQL servers at the same time

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.