关于Oracle连接SQLSERVER，用透明网关来实现，共享下透明网关的配置过程

Oracle 服务器：
    OS: Windows xp
    IP: 192.168.1.133 (surf.dcsfd.com)
    PORT: 1521
SQL 服务器：
    OS: Windows 2000
    IP: 192.168.1.3
    Database Server Name: BBS-E037D39CEB8
    Database Name: TIT

安装Oracle Transparent Gateway for Microsoft SQL Server(metalink,或Oracle安装中选择自定义)

1.在Oracle主目录下tg4msql\admin目录下，拷贝inittg4msql.ora并改名为init.ora。
  例如，我用的SID是MSSQL，那么我的文件名是initMSSQL.ora

    HS_FDS_CONNECT_INFO="SERVER=BBS-E037D39CEB8;DATABASE=TIT"
    HS_FDS_TRACE_LEVEL=OFF
    HS_FDS_RECOVERY_ACCOUNT=RECOVER
    HS_FDS_RECOVERY_PWD=RECOVER

2.配置Oracle主目录下network\admin目录下的listener.ora:
    SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = MSSQL)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_2)
      (PROGRAM = tg4msql)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = surf.dcsfd.com)(PORT = 1521))
      )
    )
  )

3.配置Oracle主目录下network\admin目录下的tnsnames.ora
 MSSQL=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.133)(PORT=1521))
            (CONNECT_DATA=
                (SID=MSSQL)
            )
     (HS=OK)
        )
 
4.
以as sysdba登录
  create database link test1 connect to sa(sqlserver的用户密码) identified by sa using 'mssql';
   select * from 表名@test1