Oracle Database → Database Link → Transparent Gateway (DG4MSQL) → ODBC → SQL Server。
p10404530_112030_MSWIN-x86-64_5of7.zip)。gateways/stage/products.xml,復用現有 Oracle Home,**簡化配置**。HS_FDS_CONNECT_INFO=SQLServerHost//InstanceName # 注意雙斜杠 //
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=recover_password
# 可選:HS_FDS_SUPPORT_STATISTICS=FALSE
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = dg4msql)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(PROGRAM = dg4msql)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
)
)
dg4msql =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle_host)(PORT = 1521))
(CONNECT_DATA =
(SID = dg4msql)
)
(HS = OK)
)
lsnrctl reload / lsnrctl status 確認 dg4msql 狀態 READY。tnsping dg4msql。CREATE PUBLIC DATABASE LINK sqlserver_link
CONNECT TO "sql_user" IDENTIFIED BY "sql_pass"
USING 'dg4msql';
SELECT * FROM "table_name"@sqlserver_link; (注意雙引號保留大小寫)。HS_FDS_CONNECT_INFO 格式:**雙斜杠**分隔主機與實例名,單斜杠會失敗。HS_LANGUAGE=AMERICAN_AMERICA.ZHS16GBK 或 AL32UTF8。同機安裝復用 Oracle Home 只需改三個文件,最簡潔可靠。跨機部署時 Gateway 端同樣需配置 ODBC DSN (System DSN)。