環境：oracle db ，sql server db， oracle gateway 分別在不同電腦，
進入$GATEWAY_HOME\tg_1\dg4msql\admin，配置 initdg4msql.ora
HS_FDS_CONNECT_INFO=[sqlserver ip]/MSSQLSERVER/JYDB
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
進入$GATEWAY_HOME\network\admin下，編輯listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = dg4msql)
(ORACLE_HOME = D:\product\11.2.0\tg_1)
(PROGRAM = dg4msql)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gateway ip)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
ADR_BASE_LISTENER = D:\product\11.2.0\tg_1
啟動網關監聽，LSNRCTL.EXE
創建dblink
create database link mslink
connect to “zh” identified by “mm”
using ' (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=gateway ip)(PORT=1522))
(CONNECT_DATA=https://bbs.csdn.net/topics/(SID=dg4msql))
(HS=OK)
) '
uj5u.com熱心網友回復：
我在網上找了幾個教程，里面配置的ip很混亂，(ORACLE_HOME = D:\product\11.2.0\tg_1)
(ADDRESS = (PROTOCOL = TCP)(HOST = gateway ip)(PORT = 1522))
(ADDRESS=(PROTOCOL=tcp)(HOST=gateway ip)(PORT=1522))
請指點小弟
uj5u.com熱心網友回復：
還有 我查詢sql server表的時候，執行sql陳述句過半分鐘才給我報錯ora-28545，這是怎么回事，如果失敗怎么這么久才報錯uj5u.com熱心網友回復：
這年頭紅領巾都沒有了／？uj5u.com熱心網友回復：
樓主問題解決了么，怎么解決的，我也遇到同樣的問題了轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/93537.html
標籤：開發