Oracle11g+ 配置多个gateway 连接sqlserver

Oracle官方文档：http://docs.oracle.com/cd/E11882_01/gateways.112/e12061/conf_sql.htm#OTGIW1010

Oracle11g 连接多个 sqlserver

参照官方文档

1.配置tg_1  initdg4msql.ora

  如果连接多个Sqlserver需要配置多个initdg4msql.ora文件 

 > D:\app\Administrator\product\11.2.0\tg_1\dg4msql\admin 
 > copy initdg4msql.ora initdg4msql1.ora
 > copy initdg4msql.ora initdg4msql2.ora

  Change the value of the HS_FDS_CONNECT_INFO parameter in the new files.

  For initdg4msql1.ora, enter the following:

 HS_FDS_CONNECT_INFO=192.168.1.225//DB1
 HS_FDS_TRACE_LEVEL=OFF
 HS_FDS_RECOVERY_ACCOUNT=RECOVER
 HS_FDS_RECOVERY_PWD=RECOVER

 For initdg4msql2.ora, enter the following:

 HS_FDS_CONNECT_INFO=192.168.1.225//DB2
 HS_FDS_TRACE_LEVEL=OFF
 HS_FDS_RECOVERY_ACCOUNT=RECOVER
 HS_FDS_RECOVERY_PWD=RECOVER

2.配置tg_1 LISTENER

> D:\app\Administrator\product\11.2.0\tg_1\NETWORK\ADMIN

  listener.ora

SID_LIST_LISTENER = 
   (SID_LIST = 
     (SID_DESC = 
       (SID_NAME = dg4msql1)      
       (ORACLE_HOME = D:\app\Administrator\product\11.2.0\tg_1)
       (PROGRAM = dg4msql)   
     ) 
     (SID_DESC = 
       (SID_NAME = dg4msql2)      
       (ORACLE_HOME = D:\app\Administrator\product\11.2.0\tg_1)
       (PROGRAM = dg4msql)   
     ) 
   )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = digiocto)(PORT = 1522))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
    )
  )

ADR_BASE_LISTENER = D:\app\Administrator\product\11.2.0\tg_1

3.配置tg_1 tnsnames.ora

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))

dg4msql1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
    (CONNECT_DATA =(SID = dg4msql1))
    (HS=OK)
  )

dg4msql2 =
  (DESCRIPTION=
    (ADDRESS = (PROTOCOL = tcp)(HOST = localhost)(PORT = 1522))
    (CONNECT_DATA=(SID = dg4msql2))
    (HS=OK)
  )  

4.增加dbhome_1 tnsnames.ora

dg4msql1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
    (CONNECT_DATA =(SID = dg4msql1))
    (HS=OK)
  )

dg4msql2 =
  (DESCRIPTION=
    (ADDRESS = (PROTOCOL = tcp)(HOST = localhost)(PORT = 1522))
    (CONNECT_DATA=(SID = dg4msql2))
    (HS=OK)
  )

5.Restart dbhome1 、tg_1 的LISTENER

6.Create DB Link

CREATE PUBLIC DATABASE LINK MSQL1
CONNECT TO "sa"
IDENTIFIED BY "passwd1" 
USING 'dg4msql1';

CREATE PUBLIC DATABASE LINK MSQL2
CONNECT TO "sa" 
IDENTIFIED BY "passwd2" 
USING 'dg4msql2';

7.TEST Connection

SQL> SELECT * FROM ALL_USERS@MSQL1;
SQL> SELECT * FROM ALL_USERS@MSQL2;