oracle 11g的sqlserver透明網關已經可以裝在任何機器上了，不用再裝在sqlserver端了
一、環(huán)境：
gateway與oracle數(shù)據(jù)庫裝在同一臺機器上,ip:10.10.10.1
sqlserver在另一臺機器上,ip:10.10.10.10

oracle版本10.2
gateway版本11.2

oracle安裝目錄：/u01/app/oracle/product/10.2.1/db_1
gateway安裝目錄：/home/gateway/gwhome

二、創(chuàng)建用戶gateway,用戶組與oracle用戶組相同就形
uid=501(gateway) gid=206(oinstall) groups=206(oinstall),207(dba)
修改環(huán)境變量
export ORACLE_HOME=/home/gateway/gwhome
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$ORACLE_HOME/bin:$PATH

三、創(chuàng)建/home/gateway/gwhome目錄

四、安裝gateway軟件，選擇相應的sqlserver組件，最后配置監(jiān)聽的時候選擇執(zhí)行典型配置就可以了

五、配置網關
1.修改監(jiān)聽/home/gateway/gwhome/network/admin/listener.ora
注意(SID_NAME=test)的test必須對應參數(shù)文件的名稱，也就是參數(shù)文件名稱應該為inittest.ora
SID_LIST_LISTENER =
   (SID_LIST =
     (SID_DESC=
         (SID_NAME=test)
         (ORACLE_HOME=/home/gateway/gwhome)
         (PROGRAM=dg4msql)
     )
   )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.1)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /home/gateway/gwhome

2.修改參數(shù)文件/home/gateway/gwhome/dg4msql/admin/inittest.ora
HS_FDS_CONNECT_INFO=[10.10.10.10]:1433//test
# alternate connect format is hostname/serverinstance/databasename
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

3.修改數(shù)據(jù)庫tns文件/u01/app/oracle/product/10.2.1/db_1/network/admin/tnsnames.ora，加入以下內容
dg4msql  =
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.1)(PORT=1521))
    (CONNECT_DATA=(SID=test))
    (HS=OK)
  )

4.創(chuàng)建DBLINK測試
create database link test connect to sa identified by test using 'dg4msql';

六、監(jiān)聽共享問題
數(shù)據(jù)庫可以和網關用同一個監(jiān)聽，如果想用不同監(jiān)聽那把網關監(jiān)聽端口和tns里的端口改一下就行了