本文從六步來幫你輕松搞定 Oracle透明網(wǎng)關(guān)環(huán)境的建立。 1、安裝oracle 的transparent gateway 透明網(wǎng)關(guān)。 安裝Oracle選擇自定義安裝，然后再選擇安裝透明網(wǎng)關(guān)，再進(jìn)去選擇安裝FOR SQL Server的組件。 2、修改 oraclehomeora92tgsmsqladmininittg4msql.orq 文件: HS_FDS_CONNECT_INFO='SERVER=YIRONG-NO1;DATABASE=jsoct'HS_FDS_TRACE_LEVEL=OFFHS_FDS_RECOVERY_ACCOUNT=RECOVERHS_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說明建立的用戶名，密碼要是SQL Server的用戶名和密碼: create PUBLIC DATABASE LINK oratoSql CONNECT TO sa IDENTIFIED BY 'lanwei'USING 'TG4MSQL' ;6、測試數(shù)據(jù)的是否正常檢索。