1、安裝oracle 的transparent gateway 透明網(wǎng)關(guān)。
安裝ORACLE 選擇自定義安裝， 然后再選擇 安裝透明網(wǎng)關(guān)，再進(jìn)去選擇 安裝FOR SQLSERVER 的組件。
2、修改 oraclehomeora92tgsmsqladmininittg4msql.orq 文件
HS_FDS_CONNECT_INFO="SERVER=YIRONG-NO1;DATABASE=jsoct"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
說明 可以通過 ORACLE 工具中的migration WorkBench 進(jìn)行配置。（過程中需要配置ODBC）
3、建立監(jiān)聽 修改oracle 的 oraclehomeora92networkadminlistener.ora 文件。
# LISTENER.ORA Network Configuration File: F:oracleora92networkadminlistener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yirong-no1)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:oracleora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ora9i2)
(ORACLE_HOME = F:oracleora92)
(SID_NAME = ora9i2)
)
#連接 sqlserver
(SID_DESC =
(GLOBAL_DBNAME = tg4msql)
(PROGRAM = tg4msql)
(SID_NAME = tg4msql)
(ORACLE_HOME = F:oracleora92)
)
)
4、修改TNS
TG4MSQL =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(CONNECT_DATA=(SID=tg4msql))
(HS=)
)
5、創(chuàng)建DBLINK 說明建立的 用戶名，密碼要是 SQLSERVER 的用戶名和密碼
create PUBLIC DATABASE LINK oratoSql
CONNECT TO sa IDENTIFIED BY "lanwei"
USING 'TG4MSQL' ;
6、測試數(shù)據(jù)的是否正常檢索。