oracle透明網關環境的建立

　　安裝oracle 的transparent gateway 透明網關
安裝ORACLE 選擇自定義安裝 然後再選擇 安裝透明網關再進去選擇 安裝FOR SQLSERVER 的組件
修改 oraclehomeoratgsmsqladmininittgmsqlorq 文件

HS_FDS_CONNECT_INFO="SERVER=YIRONGNO;DATABASE=jsoct"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
說明 可以通過 ORACLE 工具中的migration WorkBench 進行配置（過程中需要配置ODBC）

建立監聽 修改oracle 的 oraclehomeoranetworkadminlistenerora 文件


# LISTENERORA Network Configuration File: F:oracleoranetworkadminlistenerora
# Generated by Oracle configuration tools

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yirongno)(PORT = ))
)

)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:oracleora)
(PROGRAM = extproc)
)

(SID_DESC =
(GLOBAL_DBNAME = orai)
(ORACLE_HOME = F:oracleora)
(SID_NAME = orai)
)

#連接 sqlserver
(SID_DESC =
(GLOBAL_DBNAME = tgmsql)
(PROGRAM = tgmsql)
(SID_NAME = tgmsql)
(ORACLE_HOME = F:oracleora)
)

)

修改TNS

TGMSQL =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=))
(CONNECT_DATA=(SID=tgmsql))
(HS=)
)

創建DBLINK 說明建立的 用戶名密碼要是 SQLSERVER 的用戶名和密碼
create PUBLIC DATABASE LINK oratoSql
CONNECT TO sa IDENTIFIED BY "lanwei"
USING TGMSQL ;

測試數據的是否正常檢索

From:http://tw.wingwit.com/Article/program/Oracle/201311/19062.html