Oracle實(shí)現(xiàn)異種數(shù)據(jù)庫連接服務(wù)的技術(shù)叫做透明網(wǎng)關(guān)（Transparent Gateway）。目前ORACLE利用透明網(wǎng)關(guān)可以實(shí)現(xiàn)和SQL SERVER、SYBASE、DB2等多種主流數(shù)據(jù)庫的互聯(lián)。 筆者由于工作需要，通過oracle訪問sybase數(shù)據(jù)庫，把配置oracle9i TRANSPARENT GATEWAY FOR SYBASE的步驟寫成文檔，供需要的網(wǎng)友參考！配置TRANSPARENT GATEWAY FOR SYBASE步驟1.oracle所在服務(wù)器上安裝sybase client（或者在同一臺server上安裝oracle、sybase服務(wù)器）確保能夠訪問sybase數(shù)據(jù)庫2.安裝TRANSPARENT GATEWAY FOR SYBASE選件，要用自定義安裝。正確選擇sybase的安裝目錄3.選擇一個sid字符串預(yù)備賦給sybase數(shù)據(jù)庫。如：tg4sybs設(shè)置SYBASE的dll路徑到環(huán)境變量PATH（這一步很重要）4.修改初始化文件，默認(rèn)的是：ORACLE_HOMEtg4sybsadmininittg4sybs.ora設(shè)置參數(shù)HS_FDS_CONNECT_INFO格式：HS_FDS_CONNECT_INFO= server_name. database_name[,INTERFACE= interface_file]server_name. database_name是大小寫敏感的。INTERFACE可選例子：如下$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$# This is a sample agent init file that contains the HS parameters that are# needed for the Transparent Gateway for Sybase## HS init parameters#HS_FDS_CONNECT_INFO=migration_serv.taxHS_FDS_TRACE_LEVEL=OFFHS_FDS_RECOVERY_ACCOUNT=RECOVERHS_FDS_RECOVERY_PWD=RECOVER## Environment variables required for Sybase#set SYBASE=d: ybase$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$上例中server_name是migration_servdatabase_name是tax5.配置oracle網(wǎng)絡(luò)服務(wù)的listener,配置文件是：listener.ora默認(rèn)路徑：ORACLE_HOMEnetworkadmin加入如下SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME= gateway_sid)(ORACLE_HOME= oracle_home_Directory)(PROGRAM=tg4sybs)))gateway_sid就是3選擇的sid字符串oracle_home_directory是ORACLE_HOMEtg4sybs若是SYBASE是特定的。假如是其他數(shù)據(jù)庫，會不同。例子如下：$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ (SID_DESC= (SID_NAME=tg4sybs) (ORACLE_HOME = D:oracleora92) (PROGRAM=tg4sybs) )$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$6.停止監(jiān)聽lsnrctl stop重新啟動監(jiān)聽程序lsnrctl start7.配置oracle server的tnsnames.ora使其能夠訪問sybaseconnect_descriptor=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= host_name)(PORT= port_number))(CONNECT_DATA=(SID= gateway_sid))(HS=OK))connect_descriptor是連接串，任取，一般為sybshost_name：oracle server的nameport_number：oracle監(jiān)聽端口gateway_sid就是3選擇的sid字符串例子如下：$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$sybs= (DESCRIPTION= (ADDRESS_LIST = (ADDRESS=(PROTOCOL=TCP)(HOST= dw-server1)(PORT= 1521)) ) (CONNECT_DATA= (SID= tg4sybs) ) (HS=OK) )$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$8.建立database link如：CREATE; DATABASE LINK sybs; CONNECT TO sa IDENTIFIED BY prient; USING 'SBYS' ； 即可訪問sybase 數(shù)據(jù)庫。 需要注重的是，sybase數(shù)據(jù)庫的表名，字段名，假如是小寫的，那么在oracle里訪問的時候要加上雙引號''如：SQL〉select 'a' from 'b'@sybs;